how do you freeze first two rows in excel

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. Freeze Panes are used to lock several rows.įollow the following steps to lock the top row in Excel:.Freeze Top Rowis used to lock the first row.You click on the View tab then Freeze Panes and choose one of the following options, depending on how many rows you want to lock: 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. To print one or more header rows on each page when printing, see Printing rows or columns on every page and Using print ranges.Next → ← prev How to Freeze Cells in Excel The checkmark by Freeze will vanish.įreezing cells changes the way that the cells are displayed on the screen. To unfreeze rows or columns, select Window > Freeze. Now as you scroll around the screen everything above and to the left of these lines will remain in view. You will see two lines appear on the screen, a horizontal line above this cell and a vertical line to the left of this cell. Click into the cell that is immediately below the row you want frozen and immediately to the right of the column you want frozen.Click on the header for the row below where you want the freeze or for the column to the right of where you want the freeze.Ī dark line will appear to indicate where the freeze is put.You can set the freeze point at one row, one column, or both a row and a column as in Figure 10.

How do you freeze first two rows in excel