Printing Column Headers in Excel

[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)

 

[Gord Dibben]

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