Our Service

The Best Shortcut to Freeze the Top Row in Excel

If you work with large data sets in Excel, you know how important it is to keep your column headers visible as you scroll down. One way to do this is to freeze the top row. This way, no matter where you scroll, the top row stays put.

There are a few different ways to freeze the top row in Excel. The most common is to use the Freeze Panes option under the View tab. But there’s an even better way – a shortcut that will let you freeze the top row with just a few keystrokes.

Here’s how it works:

1. Select the cell below the row you want to freeze.

2. Press Alt + F8 to open the Macro dialog box.

3. In the Macro dialog box, select FreezeTopRow and click Run.

4. That’s it! The top row is now frozen.

This shortcut is a huge time-saver if you find yourself constantly freezing and unfreezing the top row. Give it a try the next time you’re working with large data sets in Excel.

Excel is a powerful tool that can help you manage and analyze data with ease. However, it can be time-consuming to navigate through large spreadsheets. That’s where shortcuts come in handy. One of the most useful shortcuts in Excel is the ability to freeze the top row. This feature allows you to keep the header row visible while scrolling through the rest of the spreadsheet. In this article, we’ll show you the best shortcut to freeze the top row in Excel.

Step-by-Step Guide to Freeze the Top Row in Excel

Step 1: Open Your Excel Spreadsheet

The first step is to open your Excel spreadsheet. If you don’t have one already, you can create a new one by clicking on “New Workbook” in the “File” menu.

Step 2: Select the Row You Want to Freeze

Next, select the row that you want to freeze. In this case, it’s the top row. Click on the row number to select the entire row.

Step 3: Click on the “View” Tab

Once you’ve selected the row, click on the “View” tab in the Excel ribbon. This tab contains all the options related to the appearance of your spreadsheet.

Step 4: Click on “Freeze Panes”

Under the “View” tab, you’ll see an option called “Freeze Panes.” Click on this option to open a dropdown menu.

Step 5: Select “Freeze Top Row”

In the dropdown menu, you’ll see three options: “Freeze Panes,” “Freeze First Column,” and “Freeze Top Row.” Since we want to freeze the top row, select “Freeze Top Row.”

Step 6: Scroll Through Your Spreadsheet

That’s it! You’ve successfully frozen the top row in your Excel spreadsheet. Now, when you scroll through the rest of the spreadsheet, the top row will remain visible.


Shortcuts are a great way to save time and increase productivity in Excel. Freezing the top row is just one of many shortcuts that can help you work more efficiently. By following the steps outlined in this article, you can easily freeze the top row in your Excel spreadsheet and keep your header row visible while scrolling through the rest of the data.


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.