use a range for a print header

S

sjl

I need the first 3 rows of my spreadsheet to show as a header on every page.
I have a lot of columns with numbers in them and need a header to follow
through on each page.

Thanks you for any help.
SJL
 
G

Gord Dibben

File>Page Setup>Sheet.

Rows to repeat at top.

Enter $1:$3


Gord Dibben MS Excel MVP
 
Top