How to Freeze Top 3 Rows in Excel (3 Methods)

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.

dataset


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.

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.

scroll down

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.

freeze top 3 rows in Excel

It will freeze the top 3 rows of your worksheet. So, if you scroll down, you will find the top 3 rows always visible.

freeze top 3 rows in Excel

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.

freeze top 3 rows in Excel

It will freeze the top 3 rows of your worksheet. So, if you scroll down, you will find the top 3 rows always visible.

freeze top 3 rows in Excel

Read More: How to Freeze Top Two Rows in Excel (4 ways)


Similar Readings


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.

toolbar

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.

excel options

As a result, you will see a Freeze Panes icon in the top bar of your Excel file.

freeze top 3 rows in Excel

Now,

➤ Select the 4th row and click on the Freeze Panes icon.

freeze top 3 rows in Excel

It will freeze the top 3 rows of your worksheet. So, if you scroll down, you will find the top 3 rows always visible.

frozen row

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.


Related Articles

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo