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.

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.

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.

Sure, I can help you with that! Here's how you can limit your worksheet to one page:

1. First, select the worksheet that you want to print.
2. Next, go to the Page Layout tab on the ribbon.
3. In the Scale to Fit group, you'll see two options: Width and Height. By default, both of these options are set to Automatic.
4. To limit your worksheet to one page, you'll need to adjust the scaling. Start by selecting the Width option.
5. In the Width box, enter the number 1 and press Enter. This will set the width of your worksheet to one page.
6. If your worksheet is still too long to fit on one page, you can adjust the height as well. Select the Height option and enter a number that will fit your worksheet on one page.
7. Once you've adjusted the scaling, you can preview your worksheet by going to the File tab and selecting Print. This will show you how your worksheet will look when it's printed.

That's it! Now your worksheet will be limited to one page when you print it. No more accidentally printing multiple pages!