How to Freeze Header in Excel (Top 4 Methods)

When we have to keep specific rows or columns visible, we feel the necessity to freeze. However, we require this feature in the case of large datasets. But you do not need to be worried at all. You can easily lock the first row or column from the Freeze Panes’ option directly. Today, we will use the ‘Freeze Panes’ option to freeze header in Excel.

Let’s take a working sheet containing columns B, C, D and E that represent Name, Country, Month, and Purchase respectively, where row 4 is the header part of this Excel Sheet. We will freeze the header in this Excel sheet by using several methods.

Freeze Header in Excel


Download Practice Book


4 Methods to Freeze Header in Excel 

Now we are going to discuss the top 4 methods to freeze the header in Excel Sheet.


1. Freeze Header in Excel Using Ribbon

This is one of the basic methods to freeze the header in an Excel Sheet. Here row 4 is our desired row whom we want to freeze in this Excel Sheet.

Freeze Header in Excel

To freeze row 4 as a header, we have to select row 5 first.

Freeze Header in Excel

Now, we have to follow the following steps.

  • Open the View tab >> go to Freeze Panes >> select Freeze Panes

Freeze Header in Excel

Immediately after selecting Freeze Panes, there appears a darker horizontal line underneath row 4.

Freeze Header in Excel

Related Content: How to Freeze Frame in Excel (6 Quick Tricks)


2. Freeze Header in Excel Using Keyboard Shortcut “ALTR + W + F + F”

We can easily perform this task in a cool way by using a keyboard shortcut ALTR + W + F + F (one after another). As we have discussed before, we want to freeze row 4 as our header in this Excel sheet. Therefore, to perform this method, we have to select row 5 first.

Freeze Header in Excel

After selecting row 5, now it is time to apply the keyboard shortcut. Let’s click on the ALT button from the keyboard and Ribbon appears before something like this. Then, we have to click on the W button to select the View option.

Immediately after clicking W, then we have to click the F button to select Freeze Panes.

Freeze Header in Excel

After, we have to select the F button again to select our desired Freeze Panes.

Freeze Header in Excel

Immediately after selecting Freeze Panes, we can see there appears a darker horizontal line underneath row 4.

This is how we can easily freeze the header in Excel Sheet by using a keyboard shortcut.

Read More: Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)


Similar Readings:


3. Freeze Header in Excel Using Magic Freeze Button

We can perform this operation, more conveniently in Excel Sheet by adding a Magic Freeze Button to the Quick Access Toolbar.

For this, we have to perform the following steps.

  • click down arrow >> select more commands

Immediately after selecting more commands, there appears a dialog box. Now we have to perform some more steps.

  • select Commands Not in the Ribbon >> select Freeze Panes >> click Add >> click OK

Freeze Header in Excel

Immediately after clicking the OK button, there appears an auto Freeze Panes option at the down arrow.

Freeze Header in Excel

After that, we have to select row 5 like previous methods to freeze row 4 as a header. Then we just need to go to the down arrow, select the auto Freeze Panes option and wait for the magic. And eventually, there appears a darker horizontal line underneath row 4.

Read More: How to Apply Custom Freeze Panes in Excel (3 Easy Ways)


4. Freeze Header in Excel Using Table Method

There is another interesting method to freeze the header in Excel by inserting the whole dataset in a Table. For this, we have to select any cell in the dataset first. Then apply the keyboard shortcut CTRL + A to select all the cells in the dataset.

Freeze Header in Excel

After that, apply another keyboard shortcut CTRL + T to create the table. Then there appears a dialogue box showing your data range. If your data range is fine, then select OK and wait for the magic.

Here, we can see that a header is created. This header will act like a frozen header in this Excel Sheet.

Freeze Header in Excel

Then if we scroll down, we can see that the header bar is showing at the column section of this Excel sheet, working as a frozen head.

Related Content: Excel Freeze Panes Not Working (5 Causes with Fixes)


Things to Remember

To freeze header in Excel, you have to select the immediate row underneath the header row. You can freeze your desired columns too by using these methods. In some cases, if you want to freeze top two rows in Excel, you can visit here too.


Practice Section

I’ve given an additional practice sheet in the workbook to practice these explained ways. You can download it from the link given above.

Freeze Header in Excel


Conclusion

In this article, I have tried to explain 4 different ways to freeze header in Excel. Note that, you can also freeze any row or any column, even multiple rows or multiple columns in Excel by just following the same methods. Last but not least, I will be extremely grateful if you comment down below any of your suggestions, ideas, or feedback.


Related Articles

Foyez

Foyez

Hello everyone, This is Foyez Alam. I have recently completed my MBA from Institute of Business Administration (IBA), University of Dhaka. Earlier I have completed my B.Sc in Leather Engineering from University of Dhaka. Now I am working as an Excel and VBA Content Developer in SOFTEKO. Through patience and hard work, I have a passion for learning new things and applying my knowledge to new situations. That's why I am here. Besides this, I love to interact with different people and I love to spend my spare time reading, watching movies, dancing, etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo