How to Freeze Top Row in Excel (4 Easy Methods)

Sometimes we need to freeze the top row of our dataset in excel to be able to compare between vales conveniently. It enables us to easily understand which vale represents what when we scroll down in our datasheet. The same goes for the leftmost column when we scroll our datasheet horizontally. Fortunately, Excel allows us to freeze the topmost rows and leftmost columns in that regard. This article shows you how to freeze top rows in excel in 4 different ways. You can freeze the top row in just 2 clicks by following one of the methods. The following picture highlights the results.

the first column & the top row in excel are frozen


Download Practice Workbook

You can download the practice workbook from the download button below.


4 Easy Ways to Freeze Top Row in Excel

Here I am going to show you 4 ways to freeze top rows in excel. We will use the following dataset to illustrate the methods. The top row in the dataset contains a short description of the data. Suppose we want to display this description even if we scroll down through the data. We can apply the following methods to do that easily.

dataset to illustrate the methods to freeze top row in excel


1. Freeze Top Row Using Quick Freeze Tool

This method will allow you to freeze the top row in just 2 clicks. Follow the steps below to see how to do that.

Steps

1. At first, select File >> Options.

2. Then select Quick Access Toolbar. Next scroll down the list of popular commands to find Freeze Panes and select it.

3. After that click on the Add button. Now you can see the Freeze Panes command has been added to the Quick Access Toolbar list. Make sure it is added for all documents.

4. Now hit the OK button.

add quick access toolbar to freeze top row in just 2 clicks

5. Then you will see the Freeze Panes command as a quick access tool as follows.

magic freeze tool in excel to freeze top row

6. Even then if you don’t find it there, you need to activate Show Quick Acces Toolbar.

how to make quick access tools visible

7. Now select the Freeze Panes quick access tool and choose Freeze Top Row.

select freeze top row

8. Finally you got your top row frozen. You will see a solid line below the top row. Now scroll down to see if the top row is frozen and always visible.

frozen top row in excel

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


2. Freeze Top Row From Freeze Panes Window

The Freeze Panes command can also be accessed from the View tab. You can easily do that by following the few steps below.

Steps

1. First, go to the View tab.

2. Then try to find the Freeze Panes command in the Window group.

3. Now freeze the top row using the  Freeze Panes command as in the earlier method.

freeze top row from view tab

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


Similar Readings:


3. Freeze Multiple Top Rows in Excel

You can freeze multiple top rows also. Go through the following steps to do that.

Steps

1. At first, select the row next to the rows you want to freeze.

2. Suppose you want to freeze the first two rows. Then select the third row.

3. Just click on the row number at the left of the row. Then the entire row will be selected.

select next row to freeze multiple rows

4. After that, choose Freeze Panes instead of Freeze Top Row in the Freeze Panes command tool.

select freeze panes to freeze multiple top rows

5. Now you will see a solid line below the second row instead. Scroll down to see if the top two rows are frozen.

multiple top rows frozen in excel

Read More: How to Freeze Top 3 Rows in Excel (3 Methods)


4. Freeze Top Row & Leftmost Column Together

Suppose we want the top row and leftmost column to remain visible all the time whether we scroll vertically or horizontally. Fortunately, Excel has a way around doing that too. The following steps will be enough for you to do that.

Steps

1. It will be easier for you to understand this method if you knew how to freeze the leftmost column first. You just need to choose the Freeze First Column option instead of the Freeze Top Row in the Freeze Panes command.

freeze first column in excel

2. Then you will see a solid line at the right of the first column. Scroll horizontally to see that the leftmost column is frozen. To freeze multiple leftmost columns, select the column next to the columns you want to freeze and then choose Freeze Panes.

first column frozen in excel

3. Now if want to freeze the top row and the first column at the same time then the first scrollable cell will be B2. So, select cell B2 and then select Freeze Panes.

select the first scrollable cell to freeze both of the top row & the first column

4. After that you will see a solid line below the top row and another one at the right of the first column.

5. Finally, scroll vertically and horizontally to see if the top row and the first column are frozen.

both of the top row & first column made frozen in excel

6. You can freeze multiple top rows and leftmost columns in the same way. All you have to do is just select the first scrollable cell and then select Freeze Panes.

Read More: How to Freeze 2 Columns in Excel (5 Methods)


Things to Remember

  • You can only freeze the row or rows from the top and column or columns from the left in excel. Excel doesn’t allow us to freeze any middle rows or columns.
  • Always select the row or column next to the rows or column you want to freeze.

Conclusion

Now you know how to freeze top rows and leftmost columns in excel. You can also review this post to learn more about freezing rows and columns in excel. Please use the comment section below for further queries or suggestions. Stay with us and keep learning more and more about excel to improve your performance.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo