Prints too many pages

[Guest]

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

 

[Guest]

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

 

[Guest]

Even if I delete the header 2 pages print. What am I doing wrong?

Thanks

 

[David Biddulph]

Page Setup/ Page/ Fit to 1 page wide by 1 tall ?

 

[Guest]

I already have it set up that way. Any other suggestions? Thanks

 

[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).