Problem with Header in Excel worksheet

[Guest]

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?

 

[Guest]

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

 

[Gord Dibben]

Your printrange is not set correctly.

File>Print Area>Clear Area.

Then select your printrange and File>Print Area>Set Area

OR View>PageBreak Preview.

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


Gord Dibben MS Excel MVP

 

[Guest]

Thanks to both of you, problem solved

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