need to delete empty pages in my worksheet
 

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.

need to delete empty pages in my worksheet
 

Bailey

Couple of ways: 1) You can gotofileprint areaClearprint 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 gotoviewpage 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

"Bailey" wrote:

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.