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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top