Header/footer not visibel in excel 2000

[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

 

[Pete_UK]

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

 

[John]

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

 

[Pete_UK]

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

Hope this helps.

Pete