Is there a way for a row functioning as a header to freeze, but then be replaced by another header row as it scrolls on to screen?

In my example I've got a section called "Benefits", then about 20 rows of information, then when the header "Costs" appears, I'd like for it to replace the frozen header at the top where "Benefits" was.

Is this possible to do in Excel 2010?

  • 2
    Check out this article here LINK – gtwebb Aug 7 '14 at 18:31
  • AFAIK, there isn't an out of the box option that would do what you are expecting! – jjk_charles Aug 7 '14 at 18:34
  • Have you tried split windows to view two separate areas of the same sheet? – CharlieRB Aug 7 '14 at 18:52

In addition to the more thorough VBA solution linked to by gtwebb, here's a very quick and straightforward solution if you're simply dealing with two tables of data one above the other.

enter image description here

Make sure you've used Insert > Table for each one, remembering to select My table has headers:

enter image description here

Then when you scroll down notice how the column headers appear where the column letters normally appear.

enter image description here

When you scroll to the second table, click into the table somewhere (you do need to click) and the column headers will change accordingly.

enter image description here

This is a very limited approach, but works if you're in a hurry.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.