Extra blank pages in Excel worksheet

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

For some reason, I am getting extra blank pages between
the worksheet pages that contain data (numbers, bar
charts, and text boxes). These blank pages show up in
Print Preview.
Is there any way I can get rid of these blank pages? I am
also getting one after my last page that has data. For
this one, I have tried Edit > Clear > All to try to
remove any hidden information that may be lurking to the
right of my last column, but nothing seems to help.
 
Kelly
What is happening is that Excel thinks the used range is bigger that it
actually is. This happens in the process of entering data and moving it
around and whatnot. Edit - Clear all does not help. You need to delete all
the rows after and all the columns to the right of your real used range.
Do this.
Select the row below your last row of data.
Select the row, not some cell.
Hold Ctrl-Shift down and press the down arrow key. This selects all the
rows to the bottom of the sheet.
Click on Edit - Delete.
Select the first column to the right of your data and do Ctrl-Shift and
press the right arrow key.
Click on Edit - Delete.
Now save the file. Now do your printing. HTH Otto
 
Hi Otto -
Thanks for the info. I really appreciate your reply. I
tried what you suggested and I still found the extra
blank pages between and after my pages with data. My data
consists mainly of charts, numbers in tables and text
boxes. I finally found that the blank pages would go away
if I scooted the outside border of both the charts and
the text boxes off the edge of the page. I had assumed
earlier that if I used the Alt key when sizing the charts
and text boxes that they would "snap" to the cell borders
and all would be well. But, evidently Excel thought that
some of these charts and text boxes were over the line,
forcing a new page, even though nothing would show on
this page. When I resized these charts and text boxes
without the Alt key, scooting them off the outside cell
border by just a fraction of an inch, the blank pages
went away. So I'm hoping this problem is solved. Thanks
again for your input.
Sincerely,
Kelly
 
Back
Top