While working with a large Excel worksheet, you may need to freeze different numbers of rows. It will allow you to navigate through your entire worksheet keeping the frozen rows always visible. In this article, I’ll show you 3 easy ways to freeze the top 3 rows in Excel.
Suppose, you have the following dataset regarding customers’ information, where you want to freeze the 3 top rows.
1. Using Freeze Panes Command to Freeze Top 3 Rows
You can Freeze the top 3 Rows with Panes. First,
➤ Select the 4th row.
Here, you are selecting the 4th row because you want to freeze the top 3 rows. This selection will act as a reference for freezing rows and Excel will freeze all the rows which are at the top of the selected row.
After that,
➤ Go to the View tab and click on Freeze Panes from the Window ribbon.
As a result, the Freeze Panes menu will appear.
There are three options in the Freeze Panes menu. They are- Freeze Panes, Freeze Top Row, and Freeze First Column. The Freeze First Column option is for the freezing columns.
Let’s try the Freeze Top Row option to freeze the top 3 rows. To do that,
➤ Click on the Freeze Top Row.
Now, if you scroll down, you will see only the top row (1st row) is frozen. That means you cannot freeze the top 3 rows with the Freeze Top Row option.
Now, let’s try the Freeze Panes option. After selecting the 4th row,
➤ Click on the Freeze Panes option from the dropdown menu of the Freeze Panes of the View tab.
It will freeze the top 3 rows of your worksheet. So, if you scroll down, you will find the top 3 rows always visible.
Here, on the first 3 rows, I have the article heading and column headers, these will be visible throughout the scrolling task.
Read More: How to Freeze Top Row in Excel
2. Freezing Top 3 Rows with Split Window
Excel offers different features to perform the same task. Freezing is not the exception either. You can also use Split Panes to freeze the 3 top rows of your datasheet.
First,
➤ Select the 4th row.
Here, you are selecting the 4th row because you want to freeze the top 3 rows. This selection will act as a reference for freezing rows and Excel will freeze all the rows which are at the top of the selected row.
After that,
➤ Go to the View tab and click on the Split icon.
It will freeze the top 3 rows of your worksheet. So, if you scroll down, you will find the top 3 rows always visible.
Read More: How to Freeze Top Two Rows in Excel
3. Applying Excel Freeze Button to Fix Top 3 Rows
If you frequently need to freeze rows and columns, you can enable a Magic Freeze Button. With this button, you can freeze the top 3 rows very easily. First, let’s see how to create this magic freeze button.
➤ Click on the drop-down icon from the top bar of the Excel files.
It will open a drop-down menu.
➤ Select More Commands from this menu.
As a result, the Quick Access Toolbar tab of the Excel Options window will appear.
➤ Select Choose Not in the Ribbon in the Choose Command from box.
After that,
➤ Select Freeze Panes and click on Add.
It will add the Freeze Panes option in the right box.
Finally,
➤ Click on OK.
As a result, you will see a Freeze Panes icon in the top bar of your Excel file.
Now,
➤ Select the 4th row and click on the Freeze Panes icon.
It will freeze the top 3 rows of your worksheet. So, if you scroll down, you will find the top 3 rows always visible.
Read More: How to Freeze Columns in Excel
Things to Remember
🔻 Freeze and split panes cannot be used at the same time. Only one of the two options is available.
🔻 Only the rows which are at the top of your selected row will be frozen. So, you need to select the 4th row to freeze the top 3 rows.
Download Practice Workbook
Conclusion
That’s all for the article. I’ve shown you 3 suitable methods to freeze the top 3 rows. Hope now you know how to freeze the top 3 rows in Excel. If you want to unfreeze them, you can find the way from here. If you have any kind of confusion, please leave a comment.
Related Articles
- How to Freeze 2 Columns in Excel
- How to Freeze First 3 Columns in Excel
- Unfreeze Rows in Excel
- How to Unfreeze Columns in Excel
- How to Freeze Random Selection in Excel
- How to Lock Cells in Excel When Scrolling
- How to Unlock Cells in Excel When Scrolling
- How to Lock Rows in Excel When ScrollingÂ
<< Go Back to Freeze Panes | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
