You use Microsoft Excel's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page ...

Steps to freeze multiple rows in Excel Click on the cell in column A of the row immediately below the rows you want to lock. For example, if you wish to lock rows 1 and 2, you should click on Cell A3.

Specifically, to freeze just the top row and the leftmost column, select cell B2. Now activate the Freeze Panes command. Excel will freeze every column to the left of B2 and every row above B2.

How to freeze multiple rows and columns in Excel. You can freeze multiple rows by selecting a cell below the row you want to be fixed in place. The same applies to multiple columns – select the ...

So, for example, if you freeze at cell H10, every cell from A1 to G9 will be pinned. Whatever freeze function you use, you can disable it at any time by clicking the Unfreeze Panes button. How to ...