Problem with Header in Excel worksheet

R

Roger Thompson

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?
 
B

Bob Umlas, Excel MVP

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
 
G

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
 
R

Roger Thompson

Thanks to both of you, problem solved

Bob Umlas said:
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
Click to expand...
 
Top