need to delete empty pages in my worksheet

  • Thread starter Thread starter Bailey
  • Start date Start date
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.
 
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
 
Back
Top