Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / May 2005

Tip: Looking for answers? Try searching our database.

page not fully used on scaling/fit to

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Datasort - 19 May 2005 21:47 GMT
I am trying to landscape print on legal paper.  I have selected scaling/fit
to: 1 page wide and 99 tall.

The left and right top and bottom margins are set to 0 (trying anything).  

The problem is that I have about 2 inches of white spade on the right of the
landscape page.   Essentially I am not using the entire page to print and my
columns are really squeezed.

Any Thoughts

Thanks in advance,

Stewart Rogers
David McRitchie - 23 May 2005 10:09 GMT
Those are two different dimension limits,   remove the 99,  from your
   1 pages wide by 99 tall
if you would have printed more than 99 pages your sizes would have been
reduced and that includes the width..

Excel will squeeze printing down but it will not expand it to fit width
of page.

If you are not printing gridlines or borders turn on gridlines so you can
see if you are actually printing empty cells.

Always test in print preview  so you don't waste paper

Use  Ctrl+End to find the last cell if that is further to the right
of your data then you have a problem with lastcell; likewise, if it is further
down than your data you would also have a last cell problem but you are
only mentioning the width.

To correct a last cell problem see
   http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell

Fit Print to Page, and Adjustments to Layout
: http://www.mvps.org/dmcritchie/excel/fitprint.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> I am trying to landscape print on legal paper.  I have selected scaling/fit
> to: 1 page wide and 99 tall.
[quoted text clipped - 10 lines]
>
> Stewart Rogers

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.