Headers

[Dan Wilson]

Good day. I am using Excel 2002. I have several
worksheets that contain information at the top of the
worksheet that I would like to have printed on each page
that is printed out. I have been painstakingly
controlling the margins, page size and using the Control
Enter command when necessary to print the headers at the
top of each page.

I have tried using the Header/Footer function, but the
left/center/right split does not allow me control over the
various column headers that I wish to use.

Is there a way to copy the existing header columns (more
than one row) into the header function, or there another
way to force the header columns to print on each page?

Thanks, Danno...

 

[Frank Kabel]

Hi
goto the menu 'File - Pagesetup - sheets'. you could enter repating
rows for your header

 

[JE McGimpsey]

File/Page Setup/Sheet enter 1:1 (or another range reference) in "Rows
to repeat at top" textbox.