I am including a header in an excel worksheet. The worksheet is only one page
long but the header automatically appears on a second sheet. When I print the
sheet, the second page also prints with just the header showing but none of
the text.
If I go onto the second page before printing and delete the header, then the
header also deletes from the first page. Any suggestions please?

Reset your print_area -- it's set to be bigger than you think, so the 2nd
blank page is included. Select the range you want to print, then use
File/Print_Area/Set Print Area.

Bob Umlas

"Roger Thompson" wrote:

I am including a header in an excel worksheet. The worksheet is only one page
long but the header automatically appears on a second sheet. When I print the
sheet, the second page also prints with just the header showing but none of
the text.
If I go onto the second page before printing and delete the header, then the
header also deletes from the first page. Any suggestions please?

Your printrange is not set correctly.

FilePrint AreaClear Area.

Then select your printrange and FilePrint AreaSet Area

OR ViewPageBreak Preview.

Drag the bottom blue line up to the bottom of your desired print area.


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 11:38:02 -0800, Roger Thompson
wrote:

I am including a header in an excel worksheet. The worksheet is only one page
long but the header automatically appears on a second sheet. When I print the
sheet, the second page also prints with just the header showing but none of
the text.
If I go onto the second page before printing and delete the header, then the
header also deletes from the first page. Any suggestions please?

Thanks to both of you, problem solved

"Bob Umlas, Excel MVP" wrote:

Reset your print_area -- it's set to be bigger than you think, so the 2nd
blank page is included. Select the range you want to print, then use
File/Print_Area/Set Print Area.

Bob Umlas

"Roger Thompson" wrote:

I am including a header in an excel worksheet. The worksheet is only one page
long but the header automatically appears on a second sheet. When I print the
sheet, the second page also prints with just the header showing but none of
the text.
If I go onto the second page before printing and delete the header, then the
header also deletes from the first page. Any suggestions please?