Header/footer not visibel in excel 2000

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

In my spreadsheet I have images in header and footer which display fine in
print preview in both excel 2003 & 2007. However these images do not appear
in print preview in excel 2000? What is the problem and how can I fix it?

Thanks

Regards
 
Excel 2000 did not have that facility, it was added later.

One way around it is to have your images in the top few rows of the
sheet (i.e. not as part of the header), and then to set up those rows
to print at the top of each page (a kind of pseudo-header).

Hope this helps.

Pete
 
Thanks. How can I get the rows to print on top of each page?

Thanks again.

Regards

Excel 2000 did not have that facility, it was added later.

One way around it is to have your images in the top few rows of the
sheet (i.e. not as part of the header), and then to set up those rows
to print at the top of each page (a kind of pseudo-header).

Hope this helps.

Pete
 
In File | Page Setup | Sheet tab you can set the Rows to repeat at Top
as required.

Hope this helps.

Pete
 
Back
Top