how can i freeze first two rows in excel

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. 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. Next → ← prev How to Freeze Cells in Excel

How can i freeze first two rows in excel