How to Freeze Cells in Excel

Freezing Multiple Columns or Rows

1. Select the row or column after those you want to freeze. If the data you want to keep stationary takes up more than one row or column, click the column letter or row number after those you want to freeze. For example:

   1. If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, click row 4 to select it.
   2. If you want columns A and B to remain still as you scroll sideways through your data, click column C to select it.
   3. Frozen cells must connect to the top or left edge of the spreadsheet. It's not possible to freeze rows or columns in the middle of the sheet.^{[2] X Research source}

2. Click the View tab. It's at the top of Excel.

3. Click the Freeze Panes button. It's in the "Window" section of the toolbar. A set of three freezing options will appear.

4. Click Freeze Panes on the menu. It's at the top of the menu. This freezes the columns or rows before the one you selected.

5. Unfreeze your cells. If you want to unlock the frozen cells, click the Freeze Panes menu again and select Unfreeze Panes.