If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
How can I limit a worksheet to one page?
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. |
#3
|
|||
|
|||
How can I limit a worksheet to one page?
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. |
#4
|
|||
|
|||
How can I limit a worksheet to one page?
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. |
Thread Tools | |
Display Modes | |
|
|