Dynamic Freeze Panes
Freeze panes are a really useful way of having some column headings always visible as you scroll around a sheet.
However, on a sheet with multiple tables or lists of data, the column headings may be different for each table, so can't be included in the freeze pane. As you scroll through the table you then lose sight of the column headings, making the table harder to use and understand.
It would be great to have dynamic freeze panes in addition to the overall sheet freeze pane. As you're scrolling down a particular table the header row of that table would always be visible, but the header row would then disappear after you scroll beyond the end of the table.
It would be amazing to have this feature, just when you scroll down to the next freeze level, it would replace the first one.
The flow should be similar like, for example, the contact list in Windows phone, where once you reach the next letter, it replaces the last one.
I'd like it to be possible to specify multiple rows for freezing, at arbitrary intervals in a worksheet, and have Excel choose for freezing at the top of the screen the area closest to the active cell.
Kenneth Barber commented
Excel already has this functionality (kind of). The column labels (A, B, C, ...) will be replaced by the column names if you have a table cell selected and the header is off-screen. However, you won't have any formatting, the most important of which is Wrap Text.