As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Top Row in Perpetuity: How to Freeze the Top Row in Excel

Freezing the top row in Excel is a useful feature that allows you to keep the header row visible while scrolling through large sets of data. This guide will walk you through the steps to freeze the top row, providing a constant reference point as you navigate through your worksheet.

Step 1: Open Your Excel Worksheet

1.1 Launch Microsoft Excel and open the worksheet where you want to freeze the top row.

Step 2: Scroll to the First Row Below the Top Row

2.1 Scroll down to the row just below the row you want to freeze. This ensures that the top row remains visible on the screen.

Step 3: Select the First Row Below the Top Row

3.1 Click on the row number to the left of the row just below the top row. For example, if you want to freeze row 1, click on row 2.

Step 4: Go to the "View" Tab

4.1 Navigate to the "View" tab in the Excel ribbon.

Step 5: Click on "Freeze Panes"

5.1 In the "Window" group, locate the "Freeze Panes" button.

Step 6: Select "Freeze Top Row"

6.1 Click on the drop-down arrow next to "Freeze Panes."6.2 From the drop-down menu, choose "Freeze Top Row."

Step 7: Verify the Frozen Top Row

7.1 The top row is now frozen, and you can scroll through the rest of the worksheet while keeping the header row visible.

Additional Tips:

  • Unfreeze Panes:
  • If you want to unfreeze the panes later, go to the "View" tab, click on "Freeze Panes," and choose "Unfreeze Panes."
  • Freeze Multiple Rows:
  • If you want to freeze more than one row, click on the row below the last row you want to freeze, go to the "View" tab, click on "Freeze Panes," and choose "Freeze Panes."


Freezing the top row in Excel is a practical technique for maintaining visibility of column headers. By following these steps, you can easily freeze the top row, ensuring that important information remains visible while scrolling through your worksheet. Whether you're working with large datasets, creating reports, or any other task, freezing panes enhances the efficiency and organization of your Excel experience.