Need The Excel Header On Each Print Page To Be The First Row Of The Table

Question

I need the First Row in an Excel Spreadsheet to Print as the header on all pages.

Answer 1

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

Answer 2

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.

Answer 3

The old-fashioned way to do it is to define the name "Print_Titles" to be the rows you want printed at the top. Select the rows you want as a header, click in the text-edit box to the left of the formula bar, type "Print_Titles" and hit Enter. Defining the name via the "Define Names" dialog or programatically works fine too, but I don't know where they hid the dialog box in the 2007 UI...

Answer 4

thanks every body