Results 1 to 2 of 2
  1. #1
    Star Lounger
    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.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts