Connecting Tech Pros Worldwide Help | Site Map

Print area? limit? Excel 2003

Familiar Sight
 
Join Date: Jun 2008
Location: Sweden
Posts: 130
#1: Nov 14 '08
Hi

I'm trying to print a excel sheet in excell 2003, but it's a limit in the sheet that looks like a print area but it dosen't dissaper when chosing File -> Print Area -> Clear Print Area.

While printing it acts as a print area so I can't print on more than 70% of the papper.

It's realy annoing, and i haven't find any solution so far.
Moderator
 
Join Date: Feb 2008
Location: Beauly, near Inverness, Scotland
Posts: 1,576
#2: Nov 16 '08

re: Print area? limit? Excel 2003


Hi. I wonder if you have a blanked-out cell or some other form of hidden content that you can't see on your sheet? This would certainly affect the area printed, and as it has nothing to do with Clear Print Area it will not be cleared by performing a Clear Print Area command. Excel 2003 does not normally misbehave over print areas, which is what makes me think you something blank or hidden somewhere on your sheet.

Check where the last cell on your sheet is (shortcut Ctrl-End). If it is not where you expect it to be delete that cell/row/column as necessary, then resave the sheet.

-Stewart
Reply