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

Excel Guide

Row Resilience: How to Freeze Rows in Excel

Freezing rows in Excel is a beneficial feature that allows you to keep specific rows visible while scrolling through your data. This guide will walk you through the steps to freeze rows, providing you with 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 rows.

Step 2: Scroll to the Row Below the Rows to Be Frozen

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

Step 3: Select the Row Below the Rows to Be Frozen

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

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.5.2 Click on the drop-down arrow next to it.

Step 6: Select "Freeze Panes"

6.1 From the drop-down menu, choose "Freeze Panes."

Step 7: Verify the Frozen Rows

7.1 The selected rows are now frozen, and you can scroll through the rest of the worksheet while keeping these rows 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 Top Row Only:
  • If you only want to freeze the top row, click on the row below it, go to the "View" tab, click on "Freeze Panes," and choose "Freeze Top Row."
  • Freeze First Column:
  • Similar to freezing rows, you can freeze the first column by selecting the column to the right of the column you want to freeze and choosing "Freeze Panes."


Freezing rows in Excel provides a stable reference point when dealing with large datasets. By following these steps, you can easily freeze specific rows, ensuring that essential information remains visible while working with the rest of your worksheet. Whether you're analyzing data, creating reports, or any other task, freezing panes contributes to a more efficient and organized Excel experience.