Freeze Row when scrolled to it

[Arrushing]

I'm building a one-sheet loan amortization calculator. The top section of the calculator is the input section, the middle section is the output/summary, and the bottom section is the amortization table.

I'm trying to lock the top row of the amortization table (row 64) as I scroll down the table, but also want to scroll up to the top of the document as well. I'm basically trying to lock the row ONLY when I scroll to it and past it, however want the row to stay where it is as I scroll up to the other sections.

Is there a way to accomplish this?

 

[samitnair]

not quite sure of your ask but try the freeze pane option and use a shortcut key to toggle as you need.

the below script freezes panes as per your selection

Sub AdjustFreezePanes()
ActiveWindow.FreezePanes = False
ActiveWindow.FreezePanes = True
End Sub