How to Freeze Rows and Columns in Excel?

Have you ever worked with a large Excel sheet and noticed that the column headings disappear when you scroll down?

When you scroll through a large worksheet, the top row usually disappears.

If you have many columns, you may also need to scroll to the right, you can no longer see the names of the columns.

It can become difficult to know which data belongs to which column.

Excel has a useful feature called Freeze Panes that can help.

It lets you keep selected rows or columns visible while you scroll through your worksheet.

In this guide, let’s see how to freeze rows and columns in Excel with simple examples.

What Is Freeze Panes in Excel?

Freeze Panes is an Excel feature that keeps selected rows or columns visible while you scroll.

For example, suppose your first row contains headings:

Name | City | Department | Salary

When you scroll down through hundreds of rows, the headings normally move up and disappear.

If you freeze the top row, the headings will stay visible while you scroll down.

You can also freeze columns.

For example, if the first column contains employee names, you can freeze that column so that Column A can be visible while scrolling to the right.

How to Freeze the Top Row in Excel?

If your column headings are in the first row, you can easily keep them visible.

Follow these steps:

1. Go to the View tab.

2. Click Freeze Panes.

3. Select Freeze Top Row.

That’s it.

Now the first row will stay visible when you scroll down.

This makes it much easier to understand the data.

How to Freeze the First Column in Excel?

You can also keep the first column visible while scrolling to the right.

For example, suppose the first column contains employee names and your worksheet has many columns.

Follow these steps:

1. Go to the View tab.

2. Click Freeze Panes.

3. Select Freeze First Column.

Now the first column will stay visible when you scroll horizontally.

This is useful when your worksheet has many columns.

How to Freeze Rows and Columns Together?

You can also freeze both rows and columns at the same time.

For example, suppose:

• Row 1 contains your headings.
• Column A contains employee names.

You want to keep both visible while scrolling.

Here’s how:

1. Click the cell B2.

2. Go to the View tab.

3. Click Freeze Panes.

4. Select Freeze Panes.

Excel will freeze:

• The row above the selected cell.
• The columns to the left of the selected cell.

Now:

• Row 1 will stay visible when you scroll down.
• Column A will stay visible when you scroll to the right.

This is very useful when you are working with a large table.

Quick Tip:

The cell you select is important.

If you select B2, Excel freezes:

Row 1 + Column A

A simple way to remember it is:

Everything above the selected cell and everything to the left of it will be frozen.

How to Freeze Multiple Rows in Excel?

You are not limited to freezing only the first row.

You can freeze multiple rows if your worksheet has more than one heading row.

For example, suppose you want to freeze the first 3 rows.

Follow these steps:

1. Select cell A4.

2. Go to the View tab.

3. Click Freeze Panes.

4. Select Freeze Panes.

Excel will freeze the rows above the selected cell.

So:

Select A4 → Rows 1, 2, and 3 will stay visible.

How to Freeze Multiple Columns in Excel?

You can also freeze more than one column.

For example, suppose you want to keep the first 2 columns visible.

Follow these steps:

1. Select cell C1.

2. Go to the View tab.

3. Click Freeze Panes.

4. Select Freeze Panes.

Excel will keep Columns A and B visible while you scroll to the right.

So:

Select C1 → Columns A and B will stay visible.

How to Freeze Multiple Rows and Columns at the Same Time?

You can also freeze multiple rows and columns together.

For example, suppose you want to freeze:

• First 2 rows
• First 2 columns

Select:

C3

Then go to:

View → Freeze Panes → Freeze Panes

Excel will keep:

Rows 1 and 2

and

Columns A and B

visible while you scroll.

Easy Rule to Remember:

The selected cell acts as the starting point.

Excel freezes everything:

Above the selected cell

and

To the left of the selected cell

For example:

Select	Excel freezes
B2	Row 1 + Column A
A4	Rows 1 to 3
C1	Columns A and B
C3	Rows 1 to 2 + Columns A and B

How to Unfreeze Rows and Columns in Excel?

If you no longer want the rows or columns to stay visible, you can remove Freeze Panes.

Follow these steps:

1. Go to the View tab.

2. Click Freeze Panes.

3. Select Unfreeze Panes.

The rows and columns will return to normal.

Freeze Panes vs Split:

These two options can sometimes be confusing.

• Freeze Panes keeps selected rows or columns visible while you scroll.
• Split divides the worksheet into separate scrolling areas.

For example, if you only want your headings to stay visible while scrolling through your data, Freeze Panes is usually what you need.

What If Freeze Panes Is Not Working?

If Freeze Panes does not work as expected, first check which cell you selected.

Remember that Excel freezes:

• Rows above the selected cell.
• Columns to the left of the selected cell.

For example, if you want to freeze Row 1 and Column A, select:

B2

Then choose:

View → Freeze Panes → Freeze Panes

Also check whether you have already frozen something.

If needed, go to:

View → Freeze Panes → Unfreeze Panes

Then try again.

Frequently Asked Questions:

1. What is Freeze Panes in Excel?

Freeze Panes is a feature that keeps selected rows or columns visible while you scroll through an Excel worksheet.

How to freeze the top row in Excel?

Go to:

View → Freeze Panes → Freeze Top Row

Excel will keep the first row visible while you scroll down.

How to freeze the first column in Excel?

Go to:

View → Freeze Panes → Freeze First Column

The first column will remain visible while you scroll to the right.

How to freeze the first row and first column together?

Select B2 and then go to:

View → Freeze Panes → Freeze Panes

This will keep Row 1 and Column A visible.

How to freeze multiple rows?

Select the cell below the rows you want to freeze.

For example, to freeze the first 3 rows, select A4 and choose:

View → Freeze Panes → Freeze Panes

How to freeze multiple columns?

Select the cell to the right of the columns you want to freeze.

For example, to freeze the first 2 columns, select C1 and choose:

View → Freeze Panes → Freeze Panes

How to unfreeze rows and columns?

Go to:

View → Freeze Panes → Unfreeze Panes

Does Freeze Panes change my data?

No.

Freeze Panes only changes how the worksheet behaves when you scroll. It does not change your data.

Final Thoughts:

Freeze Panes is very useful when you are working with a large Excel worksheet.

You can keep your headings visible while scrolling down, or keep important columns visible while scrolling to the right.

The three options you will use most often are:

• Freeze Top Row
• Freeze First Column
• Freeze Panes

And remember this simple rule:

Excel freezes everything above and to the left of the selected cell.

Once you understand this, freezing rows and columns becomes very easy.