centering data on pages

  • Thread starter Thread starter Spinal
  • Start date Start date
S

Spinal

Im making a 2004 calendar in excel, and ive set it in the print option to
center the cell both horizonally & vertically.

Each month of the calander starts in a new set of the print boarders so that
each prints on a seperate page, but when i do print preview excel only
centers the last page vertically, the rest of them are all at the top of the
page.

Does anyone know how i can fix this
 
You have probably got a few lines left blank at the bottom of each page.
Excel interprets this space as used, because it is not the end of the
spreadsheet. If those lines were not blank, you would expect the first line
in the page to print right at the top, wouldn't you? Well, Excel thinks they
are there for a reason.The last page centers correctly because Excel sees
that there is no more information following.

What you can do to sort this out is define your own little 'print borders'.
Leave no lines open and insert page breaks where you want to start a new
page. Easy huh!

Please let me know if this works...
Candice
 
Candice Mesk said:
You have probably got a few lines left blank at the bottom of each page.
Excel interprets this space as used, because it is not the end of the
spreadsheet. If those lines were not blank, you would expect the first line
in the page to print right at the top, wouldn't you? Well, Excel thinks they
are there for a reason.The last page centers correctly because Excel sees
that there is no more information following.

What you can do to sort this out is define your own little 'print borders'.
Leave no lines open and insert page breaks where you want to start a new
page. Easy huh!

Please let me know if this works...
Candice
Click to expand...
worked perfectly thanks :)
 
Back
Top