need to delete empty pages in my worksheet

B

Bailey

I have created a 3 page excel worksheet, with custom headers and footers.
There are 2 extra pages to the worksheet that are only showing the headers
and footers, but no data. These two extra pages need to be deleted, but I
don't know how to do that.
 
M

Mike Rogers

Bailey

Couple of ways: 1) You can goto>file>print area>Clearprint area, then
select the entire area you want to print and go back through and this time
select set print area. 2) Or you can goto>view>page break preview, here you
can hook onto the blue lines separating each page and move them to where you
want them to break. Here you can also select the areas that you want to
print and exclude others that you may not want to print.

Either one works for me on xl2k.

Mike Rogers
 

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

Top