Hanging / Partial Freeze Panes

I am aware of how to use the basic freeze panes feature (using "View" and "Freeze Panes") but what I want to do is slightly different and for the life of me I can't figure it out.

I want a row in the middle of a sheet which, when I am above it, moves as I scroll but when it comes to the top of the visible area of the worksheet it then stays / fixes there as I scroll further down so that the headings row for that part of the sheet are always visible.

Then when I scroll back up above it, it starts to move (down) again.

I don't know if it is even possible but does that make any sense? If so, can anybody help as to how to do that?