Centering Charts and info on the page

[Jacob]

Is there a way to center your spreadsheet information on the page. I know how to use center across columns and center within a cell; however i'm talking about when you start in Column A and move to the right but you don't use all your horizontal space. What happens is that a lot of times your information is off centered as if left aligned. I would like for the information to be have even margins on all sides. Not more to the right than to the left. Usually i play with the margins in page setup but this takes time and is only trial and error. I think there has to be a better way.

 

[Jon Peltier]

Hi Jacob -

In Page Setup, on the Margings tab, check the Center Horizontally checkbox.

- Jon

 

[Debbie K.]

If I am understanding you correctly, highlight all the columes (by clicking
on A,B,C so on so they are all highlighted) then move your mouse in between
two of the columes until it becomes a cross and double click. This will
widen all of your columes to just fit the info.

Or if highlight all the columes (by clicking on A,B,C so on so they are all
highlighted) then move your mouse in between two of the columes until it
becomes a cross and move the mouse left or right until your desired width is
accomplished.

Is any of this helpful?

Debbie K

Is there a way to center your spreadsheet information on the page. I know

how to use center across columns and center within a cell; however i'm
talking about when you start in Column A and move to the right but you don't
use all your horizontal space. What happens is that a lot of times your
information is off centered as if left aligned. I would like for the
information to be have even margins on all sides. Not more to the right than
to the left. Usually i play with the margins in page setup but this takes
time and is only trial and error. I think there has to be a better way.

 

[Jacob]

Thanks guys. this was helpful