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 / February 2006

Tip: Looking for answers? Try searching our database.

Why the extra white space?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
T. Jenkins - 09 Feb 2006 17:39 GMT
Quick question here from a reasonably experienced Excel user.  I routinely
use page setup options based on 1 page wide and no limit to the number of
pages long.  I like this because it typically optimizes printouts.  
Frequently, however, I get excessive white space on the right side or the
bottom.  I check the Page Preview mode to ensure the print area is not
incorrectly set (I nearly always leave this up to Excel), but there are no
problems there.

Any troubleshooting tips?

Thanks,
Todd
 
Nick Hodge - 11 Feb 2006 15:06 GMT
If you are not setting the print area manually, Excel is notorious for not
resetting it's 'UsedRange'. To do this manually for columns, click in cell
A1 and press Ctrl+right arrow.  This will tell you where Excel thinks it is!

To rectify, select the *entire* columns that are excess (Click on there
headers) and select Edit>delete (Not clear or the delete key)

Now save the workbook (Very important). now the usedrange will be reset. (Do
the same for rows)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Quick question here from a reasonably experienced Excel user.  I routinely
> use page setup options based on 1 page wide and no limit to the number of
[quoted text clipped - 8 lines]
> Thanks,
> Todd
 
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.