How do I repeat a header row on each page of excel?

G

Gary Steffy

On page one of a multi-page spreadsheet I have a header row that I'd like to
automatically repeat on all but the last page of the spreadsheet. Without
copying the header five times and inserting it, is there a way to program
this to happen?
 
B

Bernard Liengme

Why not post question to a Excel newsgroup?

File|PageSetup; open Sheet tab; locate and fill in the box Rows to Repeat on
Top
These rows will appear on ALL pages including the last
With some VBA programming you could overcome this.

Best wishes
Bernard
 
Top