Printing sheet to fit paper

  • Thread starter Thread starter Howard Brazee
  • Start date Start date
H

Howard Brazee

I waste a lot of paper trying to print an Excel 2000 sheet on a piece of paper.


I don't mind multiple vertical pages, but I can't stand multiple horizontal
pages.

Is there any trick I can use to find out if my document can fit so I don't waste
paper?
 
Hi, Howard,

You can fit to paper, which is neat. In File, Page Setup, select the "Fit
to" radio button and tell it to fit to one horizontal page. You can then
leave Vertical blank to let it work out the rest.

Another trick is that if you to a print preview, you will subsequently see
the dotted page breaks after you return to the worksheet. Also, you might
find View |Page Break View to be helpful.

--
Hope that helps,

Susan Ramlet
MVP - Office

Please reply to the newsgroups where others may benefit.
 
Back
Top