3. In the ribbon, click "Freeze Panes" and then click "Freeze Panes." Once you freeze a row, you can return to the Freeze Panes menu in the ribbon and choose "Unfreeze" to toggle the locked row.
Freezing Pane keeps rows and columns visible while the rest of the worksheet scrolls (based on the current selection). Freeze Top Row: Keep the top row visible while scrolling through the rest of ...