Problem with Header in Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
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...
 
Back
Top