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
<(E-Mail Removed)> 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 <(E-Mail Removed)>
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.