PC Review


Reply
Thread Tools Rate Thread

How can I limit a worksheet to one page?

 
 
xicapaty
Guest
Posts: n/a
 
      17th Nov 2009
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.
 
Reply With Quote
 
 
 
 
trip_to_tokyo
Guest
Posts: n/a
 
      17th Nov 2009
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.

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      17th Nov 2009
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.


 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      17th Nov 2009
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.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet Limit =?Utf-8?B?QmlsbENQQQ==?= Microsoft Excel Misc 1 5th Feb 2006 05:19 AM
RE: Worksheet Limit =?Utf-8?B?Sm9uYXRoYW4gQ29vcGVy?= Microsoft Excel Misc 0 4th Feb 2006 08:07 PM
Converting a muliple page worksheet to a single page worksheet =?Utf-8?B?dGthbmFzb290QHlhaG9vLmNvbQ==?= Microsoft Excel Misc 2 30th Jun 2005 09:40 PM
worksheet limit sali Microsoft Excel Programming 0 26th May 2005 02:34 PM
Worksheet Limit? Monte Sliger Microsoft Excel Discussion 5 11th Oct 2004 08:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:58 PM.