Center printed area

[Banaticus]

I have a set of cells that I want centered on the paper -- I want the text in the cells to be left/right justified as normal, but I want the cells themselves to be centered.

Can this be done?

[NBVC]

Select the set of cells and go to File|Print Area|Set Print Area

Then go to File|Print Preview and in the Print Preview screen click Setup and go to the Margins tab... at the bottom you can click Center Vertically or Center Horizontally.

This will center the set of cells you selected.

[martindwilson]

in page setup(not print preview) go to the margins tab and check the centre on page horizontal option

[NBVC]

Why not in Print Preview? You can do it through there too!

[martindwilson]

just something i thought i remembered but that was probably print titles now i think of it!