Prantick Bala
While working with a large Excel worksheet, you may need to freeze the top row and first column. It will allow you to navigate through your entire worksheet keeping the top row and first column always visible. In this article, I’ll show you 5 easy ways to freeze the top row and first column in Excel.
Suppose, you have the following dataset regarding customers’ information, where you want to freeze the top row and the first column.
Download Practice Workbook
5 Ways to Freeze Top Row and First Column in Excel
1. Freeze Top Row Only
To freeze the top row,
➤ Go to the View tab and click on Freeze Panes from the Window ribbon.
As a result, the Freeze Panes menu will appear.
➤ Click on the Freeze Top Row.
It will freeze the top row of the worksheet. So, if you scroll down, you will see the top row will always remain visible.
Read More: How to Freeze Top Two Rows in Excel (4 ways)
2. Freeze First Column Only
To freeze the first column,
➤ Go to the View tab and click on Freeze Panes from the Window ribbon.
As a result, the Freeze Panes menu will appear.
➤ Click on the Freeze First Column.
It will freeze the first column of the worksheet. So, if you scroll right, you will see the first column will always remain visible.
Read More:Â How to Freeze 2 Columns in Excel (5 Methods)
3. Freeze Top Row and First Column Simultaneously
In earlier sections, we’ve seen freezing the top row and the first column differently. We can freeze them both simultaneously. Let’s see how to do that. To freeze the top row and first column at the same time,
➤ Select cell B2
The reference cell must be below the row and to the right of the column, you want to freeze. So to freeze the top row and the first column, you need to select cell B2 as the reference cell.
➤ Go to the View tab and click on Freeze Panes from the Window ribbon.
As a result, the Freeze Panes menu will appear.
➤ Click on the Freeze Panes.
It will freeze both the top row and the first column of the worksheet. So, if you navigate through your worksheet, you will see the top row and the first column will always remain visible.
Read More: How to Freeze First 3 Columns in Excel (4 Quick Ways)
Similar Readings
- How to Freeze Top 3 Rows in Excel (3 Methods)
- Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)
- How to Freeze Panes with VBA in Excel (5 Suitable Ways)
4. Split Panes to Freeze
Excel offers different features to perform the same task. Freezing is not the exception either. You can also use Split Panes to freeze the top row and the first column of your datasheet.
First,
➤ Select the cell B2
The reference cell must be below the row and to the right of the column, you want to freeze. So to freeze the top row and the first column, you need to select cell B2 as the reference cell.
After that,
➤ Go to the View tab and click on the Split icon.
As a result, the top row and the first column of your dataset will be frozen. You will always see the top row and the first column of the sheet regardless of how far you go in the worksheet.
Read More:Â Freeze Multiple Panes in Excel (4 Criteria)
5. Magic Freeze Button to freeze Top Row and First Column
If you frequently need to freeze rows and columns, you can enable a Magic Freeze Button. With this button, you can freeze the top row and the first column 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.
Now, you will see a Freeze Panes icon in the top bar of your Excel file.
To freeze the top row and first column with this magic button,
➤ Select cell B2 and click on this Freeze Panes icon.
It will freeze the top row and the first column of your worksheet.
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.
🔻 If you want to freeze rows and columns at the same time, the reference cell must be below the row and to the right of the column, you want to freeze. So, to freeze the top row and the first column, you need to select cell B2 as the reference cell.
Conclusion
I hope now you know how to freeze the top row and first column 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.
