Step 5: Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. Step 4: Scroll to the right of the worksheet. Step 3: And click on the Freeze First Column in the dropdown list. To freeze the first column, execute the following steps. Make sure that all the rows to be locked are visible at the moment of freezing. It is not possible to lock rows in the middle of the sheet. NOTE: Microsoft Excel allows freezing only rows at the top of the spreadsheet. Step 4: Now click Freeze Panes, and it gives the following worksheet with a gray line after the three rows. Step 3: And again, click on the Freeze Panes in the dropdown list.įor example, to freeze the top three rows in Excel, we select cell A4 or the entire row. Step 2: Click on the View tab and go on Freeze Panes. Step 1: Select the row or cell that you want to freeze. In case you want to lock several rows, follow the following steps: Step 3: Then click on the Unfreeze Panes in the dropdown list.Īfter click on the Unfreeze Pane, it unlocks the first row and the worksheet change back to an old worksheet without any gray line. Step 1: Click on the View tab in the Window group. To unlock or unfreeze the rows, execute the following steps. Step 4: Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet. Step 3: Then select the Freeze Top Row from the dropdown list. Step 2: Go to the View tab and click Freeze Panes. Step 1: Create a dataset on an excel worksheet as below.
If you want to easily edit two parts of the spreadsheet at once, splitting your panes will make the task much easier.įreezing rows in Excel is a few clicks thing. You may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet.Įxcel includes several tools that make it easier to view content from different parts of your workbook simultaneously, such as the ability to freeze panes and split your worksheet and a few other features of Excel.įreezing rows or columns ensures that certain cells remain visible as you scroll through the data. Whenever you are working with large datasets in Excel, it can be difficult to compare your workbook information.
Next → ← prev How to Freeze Cells in Excel