How can I limit a worksheet to one page?

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!

"xicapaty" wrote:

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.

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

On Tue, 17 Nov 2009 12:17:01 -0800, xicapaty
wrote:

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.

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

On Tue, 17 Nov 2009 12:32:01 -0800, trip_to_tokyo
wrote:

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!

"xicapaty" wrote:

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.