Printing Column Headers in Excel

  • Thread starter Thread starter Don Galasso
  • Start date Start date
D

Don Galasso

Hi,
I am using Office 97 at work and need to print very
long spreadsheets in Excel, some over 100 pages in lenght.
I need to have the top line of the spreadsheet repeat
during printing as the top line of every page (as this
line defines the infomation of the specific column). How
can I do this ? Please email any ideas to (e-mail address removed).

Thanks,
Don
(e-mail address removed)
 
Don

Posted here, answered here.

File>Page Setup>Sheet "Rows to repeat at top". Enter 1:1 or point to the row
by using the collapse button in the dialog box.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top