Freeze Pane - Headings

[ChrisCoord]

Good afternoon Guru's,

I use freeze pane to keep the columns on the left and rows on the top visible as I move through my data. This has to remain in place.

However...

I have a number of different areas that a sub divided by Headings in the rows. Is it possible to freeze those so that they stay at the top of the page (within the unfrozen area) until the next heading comes up and replaces it?

 

[baitmaster]

Short answer: No

Long answer: I guess in theory you could create some code that reset the frozen section, and hid a number of rows within it so that it gave the general look and feel that you're after... but No, don't