How to get the Excel header on each print page to be the first row of the table

How to get the Excel header on each print page to be the first row of the table I need the first row in an Excel spreadsheet to print as the header on all pages.
Asked by: Guest \| Views: 400

Total answers/comments: 3

Comments display order:

bert [Entry]

Go to file->Page Setup and choose the sheet tab. There is an option 'rows to repeat at top'.

bert [Entry]

"also programatically (at least in c#) it's to the effect of:

[excel sheet].PageSetup.PrintTitleRows = ""$[firstrow]$[lastrow]"";

I would expect other languages to handle it similarly though, being that it's a com interface."

bert [Entry]

"In MS Excel 2007, go over to the Page Layout tab, the first section of that tab is titled ""Themes"", the second section is titles ""Page Setup"" the last option there is ""Print Title"" click it.

A dialog box will appear, simple click on the left column number 1 or your title line and the formula will auto fill. You have selected it and now ""print""."
"In MS Excel 2007, go over to the Page Layout tab, the first section of that tab is titled ""Themes"", the second section is titles ""Page Setup"" the last option there is ""Print Title"" click it.

A dialog box will appear, simple click on the left column number 1 or your title line and the formula will auto fill. You have selected it and now ""print""."