Now, we will discuss how to freeze rows and columns simultaneously. Till now, in this article, we have discussed how to lock rows. Subsequently, the following is our output.ĥ.Next, go to the View tab and select Split from the Window.Here, I have selected Row 8 as I want to see the first 7 rows of our dataset frozen. First, select a row below the rows you want to freeze.So, the steps involved in this method are: The fun part is, when you work on one area, rows on the other area remain locked. By applying the Split option, you can work in different areas of a dataset simultaneously. The Split option in Excel divides the working window into 2 areas where you can scroll a single dataset separately. How to Group Rows in Excel with Expand or Collapse (5 Methods).Hide Rows Based on Cell Value in Excel (5 Methods).Hide Rows and Columns in Excel: Shortcut & Other Techniques.How to Collapse Rows in Excel (6 Methods).Finally, the first 3 rows of the dataset are now locked.After that, go to the Quick Access Toolbar, select the Freeze Panes from the Freeze Panes drop-down.Now, like Method 2, select the 5th row to lock rows 1 to 4.As a result, the Freeze Panes option is added to the Quick Access Toolbar.Then, choose Freeze Panes from the Popular Commands list and click on ‘ Add>’.First, go to the Customize Quick Access Toolbar drop-down and click on ‘ More Commands’.This method is very fast and works like magic. This time we will use the Quick Access Toolbar option to freeze rows. Freeze Rows Using Quick Access Toolbar (Magic Freeze Button) As a consequence, the first two rows are locked.ģ.Then, go to the View tab, Choose Freeze Panes from the Freeze Panes drop-down.Next, select the row below the rows you want to lock (here, the 3rd row). First, go to the worksheet where you want to freeze the first two rows.Now, if we want to freeze the first two rows of the dataset, then here are the involved steps. Let’s assume we have a dataset of students’ language-wise test scores. And, this time you can use the Freeze Panes option again. Unlike the previous method, you can freeze a set of rows too. ➤ Then, go to the View tab, select Unfreeze Panes from the Freeze Panes drop-down. ➤ Initially, go to the worksheet where the row is frozen. If you want to unfreeze the rows, then follow the below steps: A gray straight line under the row indicates the locked row. Consequently, the top row of our dataset is frozen.Next, go to the View tab, select Freeze Top Row from the Freeze Panes drop-down.First, go to the worksheet where you want to lock the top row.Now, we will apply the ‘ Freeze Panes’ option to freeze the header row. For example, we have a dataset containing students’ names and test scores. Freeze Top Rows in Excel Using Freeze Panesįreezing Panes is one of the easiest options to lock rows in Excel. To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc.6 Methods to Freeze Rows in Excel 1. Note: to unlock all rows and columns, click the Freeze button again. Scroll down to the rest of the worksheet. To freeze the top row, select row 2 and click the magic Freeze button.ħ. Under Choose commands from, select Commands Not in the Ribbon.Ħ. The orange region above row 3 and to the left of column C is frozen.Īdd the magic Freeze button to the Quick Access Toolbar to freeze the top row, the first column, rows, columns or cells with a single click.ģ. To freeze cells, execute the following steps. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen. All columns to the left of column E are frozen. To freeze columns, execute the following steps. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. On the View tab, in the Window group, click Freeze Panes.Ĥ. To freeze rows, execute the following steps.Ģ. Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. To freeze the first column, execute the following steps. On the View tab, in the Window group, click Freeze Panes. To unlock all rows and columns, execute the following steps.ġ. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.