Prantick Bala
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.
Download Practice Workbook
3 Ways to Freeze Top 3 Rows in Excel
1. Freeze Top 3 Rows with Panes
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 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 (4 Easy Methods)
2. Freeze Top 3 Rows by 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 (4 ways)
Similar Readings
- How to Freeze Top Row and First Column in Excel (5 Methods)
- Freeze 2 Columns in Excel (5 Methods)
- How to Freeze Multiple Panes in Excel (4 Criteria)
- How to Freeze First 3 Columns in Excel (4 Quick Ways)
3. Magic Freeze Button
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 Apply Custom Freeze Panes in Excel (3 Easy Ways)
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.
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 ways from here. If you have any kind of confusion, please leave a comment.
