Headers

  • Thread starter Thread starter Dan Wilson
  • Start date Start date
D

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...
 
Hi
goto the menu 'File - Pagesetup - sheets'. you could enter repating
rows for your header
 
File/Page Setup/Sheet enter 1:1 (or another range reference) in "Rows
to repeat at top" textbox.
 
Back
Top