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