How do I eleiminate an unwanted extra page from an Excel wookbook.

P

paulwrestle

When I have completely filled up 2 pages in a workbook and I am using a
header that I need to repeat on each page, the header will then start
automatically on page 3. That would be fine if I needed more pages for the
report, but that is not the case. Therefore, when I proceed to print I will
always get 2 pages of information and 1 page with an unwanted heading. How
can I delete the 3rd page permanatly so it will never print?
 
D

Dave Peterson

You may want to reset the last cell on that worksheet. It may clean it up.

You can visit Debra Dalgleish's site to see some ways to try to reset that
lastused cell.
http://www.contextures.com/xlfaqApp.html#Unused

And if you added formulas down a column (in preparation for more data), maybe
you could use Data|filter|autofilter to show just the rows that have non-blanks
in a certain column.
 
Top