Prints too many pages

M

Mickey

Hi,
I have a spreadsheet with a header. I have it set to print only pages that
have text. Even though only 1 page has text it prints 2 pages (the 2nd page
just has the header). How can I prevent it from printing the extra page?

Thanks,
Mickey
 
M

Mike Rogers

Mickey

Goto>view>Page break Preview, Drag the blue lines to the area you want to
print.
Or goto>File>print area>clear print area, then select what you want to print
and go back and "set print area".

Mike Rogers
 
D

David Biddulph

Do you have contents in your last column that overflow from that column to
subsequent columns? You could try turning on wordwrap for the last column
(or setting it to align from the right, not from the left).
 
Top