How to freeze row in excel?

Select the cell located below the row you want to lock and to the right of the column you want to lock.

Here you can see a number of simple examples explaining which cell, row or column should be selected to freeze certain rows or columns or both rows and columns at once:

• To lock the top-most row only, select cell A2 or the entire row 2,
• To freeze multiple rows on the top, select the row below the last row you want to lock,
• To lock the left-most column only, select cell B1 or the entire column B,
• To freeze multiple columns on the left, select the column to the right of the last column you want to lock,
• To freeze the first column and the top row of the worksheet simultaneously, select cell B2,
• To freeze two rows on the top and two columns on the left at the same time, select cell C3.

Click the View settings icon in the upper right corner of the top toolbar or right-click the selected cell to open the contextual menu. Select the Freeze Panes option in the menu.

That's all. As you can see, a horizontal line appears above the selected cell and a vertical line appears to the left of the selected cell. The areas above and to the left of these lines are locked. Now you can scroll your worksheet to make sure that all the necessary data remain visible.

To unlock previously frozen rows and columns, just open the View settings menu and click the Freeze Panes option once again or right-click anywhere within the worksheet and select the Unfreeze Panes option from the contextual menu.