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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skipping the first row in a repeated header 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Space at end of multi page list to accommodate new entries 1
Section and Page numbering 0
How to make repeating drop-down lists? 2
Integrating information from Word to Excel (not mail merge) 1
I need help with removing the header & footers on the last page in word 2010 7
(headers & footers Issue) I have 2 even pages back to back!! 1

Top