How to Freeze Panes in Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Click the cell below the row(s) and to the right of the column(s) you want to freeze.
2. Click the View tab in the ribbon.
3. In the Window group, click Freeze Panes, then select Freeze Panes.