You can also freeze multiple rows in Excel. Your top row (Row 1) will now have a grey line below it, which indicates that it has been frozen or locked. To do this, go to the View tab in Excel, and select Freeze Panes > Freeze Top Row. This way, when you scroll down through hundreds of rows, you’ll still have those headings at the top to give you the information you need. You may want to freeze the top row in Excel because it holds your column titles.
Which clicks you use will depend on what you want to do – freeze the top panes only or a group of several rows. You can freeze rows in Excel with just a few clicks. Please let me know if you have any queries.Learn the basics of freezing rows and columns in Excel to control your view of data. Hopefully, these methods and explanations will be enough to solve your problems. In the above article, I have tried to discuss the methods elaborately. In the beginning, go to the worksheet, right-click on the sheet name and click on View Code.Let’s assume, we want to lock the first 4 rows and Column 1 and Column 2 of our dataset. Likewise, described in Method 6, we can freeze rows and columns simultaneously by using VBA. Finally, here the first 4 rows and 2 columns of the dataset are locked.Secondly, go to the View tab, Choose Freeze Panes from the Freeze Panes drop-down.Firstly, go to the worksheet and select Cell C5 (right to the column and below to the row you want to freeze).
#Freeze top 3 rows in excel how to
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)
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.