However, it is essential to note that we can only freeze adjacent or contiguous rows in Excel. We can easily freeze a set of rows from the top row to the desired row. In the image above, we can see that even after scrolling the row to the 15th row, the 5th row is fixed at the top.Įxcel also gives the flexibility of freezing multiple rows within the sheet, restricting the scrolling of the corresponding rows. If we scroll through our sheet, we will see that the 5th row appears at the top of the Excel window while the other rows continue to scroll normally. As soon as we click on the ‘Freeze Top Row’ option, the respective row gets locked immediately.Next, we need to navigate the View tab on the ribbon and click the drop-down arrow associated with the Freeze Panes We must select Freeze Top Row from the drop-down list, as shown below:.In our example sheet, we place the 5th row at the top of the visual field because we need to freeze/ lock the 5th row. First, we must scroll the sheet until the row we want to freeze comes at the top of the visible area.So, we should place the desired row at the top of the visible Excel window before following the below steps: For example, if the visible area of our Excel window displays the 5th row at the top, the 5th row will be used as the top row or the first row. Instead, it freezes the first or top row that appears in the active Excel window. Let us discuss both the ways that will help us freeze rows depending on the desired use cases:īefore moving on to the steps to freeze the top row, we must understand that this method does not typically freeze the top row of the worksheet. Excel does not limit the number of rows we can freeze, making this feature more productive when working on large data sets within a worksheet. But sometimes, we may need to freeze a group of rows. We may only need to freeze one row or the top row in most cases. When freezing rows in Excel, there may be different cases. If we freeze the entire row with title/headings, we can easily read the data for specific headings and act accordingly. If we scroll the sheet, the title/headings will not be displayed, and the data will be difficult to read or understand. It is mainly helpful to compare data from different parts of the sheet.įor example, suppose we have the title or headings in the first row and the relevant data in the rows below. When we freeze one or more desired rows in Excel, the corresponding row is locked to be visible on the screen even if we scroll the sheet to the very bottom. This makes it easier to navigate the spreadsheet when we have large data sets within a sheet. What is the Freeze Rows feature in Excel?įreezing Excel rows is one of the phenomenal features to increase the readability of data in a worksheet.