How to Freeze Panes in Microsoft Excel

Quick summary

Freezing panes in Microsoft Excel keeps selected rows and columns visible as you scroll through large spreadsheets. To freeze panes, select the correct cell position, then use the Freeze Panes option under the View tab in the ribbon.

Steps

1. Click the cell below the row(s) and to the right of the column(s) you want to freeze — this sets the freeze boundary.
2. Click the View tab in the Excel ribbon to access window layout options.
3. In the Window group, click Freeze Panes, then select Freeze Panes from the dropdown to lock your rows and columns in place.