Pages

  • Thread starter Thread starter Sari
  • Start date Start date
S

Sari

How can I delete all the extra pages?
And from where do they suddently appear?
Thank you for your help!
 
Hi Sari,
If you mean extra printed pages that are empty, it has to do with
your used range. LastCell location Ctrl+End

It is caused by inserting and deleting rows and/or columns,
and Excel not fixing it last cell indication. Another cause might
be introducing spaces or formulas into cells so that what looks
empty really isn't.

You can use the MakeLastCell macro at
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell
to delete all rows and columns past active cell when you run the macro.
 
Back
Top