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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

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

how do i remove extra pages from my speadsheet? 1
printing excel workbook 1
How to delete extra pages at end of excel file when printing 2
Have Extra Page - how do I get rid of it? - Excel 2007 2
How do I delete unwanted extra pages on Excel worksheets 4
Access Page Header with merge field 0
Printing header rows.. 5
printing a header in Excel 2

Back
Top