How can I limit a worksheet to one page?

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

 

[trip_to_tokyo]

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!

 

[Gord Dibben]

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

 

[Gord Dibben]

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