View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Problem with Header in Excel worksheet

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?