How can I limit a worksheet to one page?

  • Thread starter Thread starter xicapaty
  • Start date Start date
X

xicapaty

I want my worksheet to be on one page so that a lot of pages don't print out
if I forget to specify only one page when I print.
 
In EXCEL 2007 try this:-

Page Layout tab / Page Setup group / single left hand click on the arrow in
the lower right hand corner / Page Setup should launch / Page tab / slect Fit
to: (so that it has a gree dot in it) / and make ssure that to the right of
this it reads 1 page(s) wide by 1 tall.

Please hit Yes if my comments have helped.

Thanks!
 
What prints out is generally set by the range you have set for printrange.

First set the printrange then in page setup set that range to "Fit to:1 wide
x1 tall" if you need to.


Gord Dibben MS Excel MVP
 
That will give some unreadable print job if printrange is A1:H345

Wouldn't it be better to limit the printrange?


Gord Dibben MS Excel MVP
 
Back
Top