Headers

H

Holden Caulfield

I have an Excel spreadsheet with column headers I would like to be printed on
a worksheet that prints out more than one page and would like to have the
column descriptions print out on subsequent pages. Is there a way to do this?
 
G

Gord Dibben

File>Page Setup>Sheet

Rows to repeat at top.

Enter $1:$1 to have row 1 repeated at top of each page.


Gord Dibben MS Excel MVP
 
Top