Freeze a certain row to the top when scrolling down to it?

[RicoJ]

Hi guys,

I am new to Excel and I am wondering if there is a way to freeze a row to the top when you scroll down until it becomes the top row? For example, I want to see row 50 frozen at the top only after I scroll down and row 50 comes on top.

I only know that we can freeze top rows or leftmost columns using the freezing pane tab. But apparently this doesn't do what I'm looking to do.


Thanks for your help!


Rico

 

[hazel22]

At first select the next row you want to set freeze. Then go to "view" tab and click on "Freeze Panes".