View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Problem with Header in Excel worksheet

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?