Results 1 to 2 of 2
2006-11-15, 15:41 #1
- Join Date
- Oct 2006
- Colorado Springs, Colorado, USA
- Thanked 0 Times in 0 Posts
view header row at page breaks (2003)
Is there any way to have excel show header rows at each page break when editing the spreadsheet? I know how to freeze panes to get the header row frozen at the top of the spreadsheet, but I'd like to see the header row in the sheet at every page break. (This is not a printing setting, but while you are editing the sheet.) I'm thinking this can't be done, but thought I'd throw it out to the experts.
2006-11-15, 15:48 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: view header row at page breaks (2003)
No, that is not possible. If you wrote code to insert the header row after every page break, you'd be shifting the data down, so the page breaks would shift relative to the data. This is not desirable.
As you mention, you can use Freeze Panes to display the header row at the top of the spreadsheet, and you can set 'Rows to repeat at top' in the Sheet tab of File | Page Setup to display the header row on every page of the printed output.