When working with large amounts of data in Microsoft Excel, you may find yourself in need of a way to keep certain information visible at the top of your worksheet while you scroll through the rest of the document. This can be accomplished by freezing rows in Excel. Freezing rows will keep them locked in place so that they remain visible no matter where you scroll.
To freeze rows in Excel, first select the row or rows that you want to keep visible. Then, click the View tab on the ribbon and click Freeze Panes in the Window group. You can also use the keyboard shortcut Alt+W+F to freeze panes. If you want to keep multiple rows visible, select the row below the last row that you want to keep visible and freeze panes.
Once you have frozen your desired rows, they will remain locked in place no matter where you scroll. This can be helpful when working with large amounts of data or when you need to reference information located above or below the area where you are currently working.
If you want to unfreeze rows in Excel, simply click the View tab and click Unfreeze Panes in the Window group. You can also use the keyboard shortcut Alt+W+U to unfreeze panes.