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.
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.
To freeze row 4 as a header, we have to select row 5 first.
Now, we have to follow the following steps.
- Open the View tab >> go to Freeze Panes >> select Freeze Panes
Immediately after selecting Freeze Panes, there appears a darker horizontal line underneath row 4.
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.
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.
After, we have to select the F button again to select our desired Freeze Panes.
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.
- How to Freeze Top Row and First Column in Excel (5 Methods)
- Freeze Selected Panes in Excel (10 Ways)
- How to Freeze Top Two Rows in Excel (4 ways)
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
Immediately after clicking the OK button, there appears an auto Freeze Panes option at the down arrow.
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.
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.
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.
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.
I’ve given an additional practice sheet in the workbook to practice these explained ways. You can download it from the link given above.
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.