Microsoft Excel is a versatile tool for managing and analyzing data. When dealing with extensive spreadsheets, it can be challenging to keep essential information in view while scrolling through multiple rows. In such cases, freezing rows can be a game-changer. In a previous article, we discussed how to freeze the top row and the first column, but what if you need to keep two rows at the top of your worksheet visible? In this step-by-step guide, we’ll show you how to freeze two rows in Excel, allowing you to keep important data accessible as you navigate your spreadsheet.

Why Freeze Rows in Excel?

Freezing rows in Excel is a practical feature when you’re dealing with large datasets. It ensures that specific rows remain visible as you scroll down through your spreadsheet, making it easier to understand and work with your data. While our previous article covered freezing the top row, here, we’ll address the need to freeze two rows.

Here’s how to freeze two rows in Excel:

  1. Open your Excel spreadsheet: Launch Excel and open the spreadsheet where you want to freeze two rows.
  2. Select the row below the rows you want to freeze: Click on the row number just below the second row you want to freeze. For example, if you want to freeze Rows 1 and 2, select Row 3.
  3. Navigate to the “View” tab: In the Excel ribbon at the top of the window, locate the “View” tab and click on it.
  4. Find the “Freeze Panes” option: Under the “View” tab, you’ll see the “Freeze Panes” button in the “Window” group.
  5. Choose “Freeze Panes”: Click on “Freeze Panes,” and you’ll see a dropdown menu.
  6. Select “Freeze Panes” again: In the dropdown menu, click on “Freeze Panes” once more. Excel will freeze the rows above the selected row.
  7. Test it out: Scroll down through your spreadsheet, and you’ll notice that the two rows you selected remain visible as you navigate the data.

Unfreezing Rows:

If you want to unfreeze the rows you’ve previously frozen, follow these steps:

  1. Navigate to the “View” tab.
  2. Click on “Freeze Panes” in the “Window” group.
  3. Choose “Unfreeze Panes.”

By unfreezing, you return your spreadsheet to its default state without frozen rows.


Freezing rows in Excel is a valuable feature, especially when working with extensive data. By following these simple steps, you can keep not one but two rows at the top of your spreadsheet visible while scrolling, enhancing your data analysis and management. Whether you’re using Excel for professional tasks or personal projects, this skill is a handy addition to your Excel toolkit.

Read the previous article on freezing the top row and first column in Excel here.

Now you have the knowledge to freeze both the top two rows and the first column in Excel, tailoring your data presentation to your specific needs. Happy spreadsheet work!

Leave a Reply

Your email address will not be published.