To freeze cells in Microsoft Excel: open a worksheet, select the rows and columns that are to be locked, and then navigate to the Freeze Panes options from the View tab. From the list of options, select the most appropriate choice to freeze a single row, single column or multiples.
- Select the cells
To freeze a row, highlight the row of cells directly below the row you want to freeze. To freeze a column, highlight the column of cells directly to the right of the column you want to freeze. To freeze both a column and a row, click on the cell that is below and to the right of the row and column you want to freeze.
- Navigate to the freeze options
Go to the View tab, and click on the arrow next to Freeze Panes, which is located in the Window group.
- Lock the cells
From the list of options, select Freeze Row or Freeze Column, if you want to freeze a single row or column. To select multiple rows and columns or both rows and columns, click on Freeze Panes. To unfreeze the cells, go back to the View Tab, and select Unfreeze Panes under Freeze Panes.