Excel Freeze Panes: Keep Top Row and Left Column Visible

To freeze the top row and left column together in Excel for Microsoft 365 on Windows, select cell B2, then choose View > Freeze Panes > Freeze Panes. Row 1 stays visible when you scroll down, and column A stays visible when you scroll right. For more than one header row or column, select the cell just below and to the right of the area you want to keep visible.

What Freeze Panes Does

Freeze Panes keeps chosen worksheet rows and columns in view while you scroll through the rest of the sheet. It is useful when a data list is wider or longer than the visible window: the row labels or column headings remain available as you inspect distant cells. The frozen area does not move with the scrolling area, but it remains part of the same worksheet.

Freezing is a viewing aid, not a data-protection feature. It does not prevent someone from editing the frozen cells, change the order of the data, or keep a particular cell selected. It also does not create a permanent split into separate worksheets. You can remove the setting later with View > Freeze Panes > Unfreeze Panes.

Excel provides separate commands named Freeze Top Row and Freeze First Column, but those commands each address one edge of the sheet. To keep the top row and left column visible at the same time, use the general Freeze Panes command after selecting the appropriate cell.

How to Freeze the Top Row and First Column Together

Open the worksheet and make sure it is the sheet you want to change. Freeze settings apply to the active worksheet, not automatically to every sheet in the workbook.
Select cell B2. The selection matters: Excel uses the rows above the cell and columns to its left to determine what to freeze.
Open the View tab on the ribbon.
Choose Freeze Panes, then choose Freeze Panes again from the menu.
Scroll down and to the right to check the result. Row 1 and column A should remain visible while the rest of the sheet moves.

In some Excel layouts, the Freeze Panes menu appears as a dropdown in the View tab’s Window area. The command name and selection logic are the important parts, even if the ribbon arrangement looks a little different. If the sheet was already frozen, Excel may show Unfreeze Panes as the first command; unfreeze it before setting a new arrangement.

Why Cell B2 Is the Right Choice

Excel freezes everything above and to the left of the active cell; it does not freeze the selected cell itself. B2 is the intersection immediately below row 1 and immediately to the right of column A. That is why it produces the familiar combination: the first row remains at the top, and the first column remains at the left.

The same rule works for larger headings. Suppose a report has two title or header rows and its row labels occupy columns A and B. Select C3 before choosing Freeze Panes. Rows 1 and 2 are above C3, while columns A and B are to its left, so all four remain fixed. If you select B3 instead, Excel freezes rows 1 and 2 but only column A. If you select D2, it freezes row 1 and columns A through C.

This selection-based approach is more flexible than relying on the named Freeze Top Row and Freeze First Column commands. It lets you choose a rectangular frozen area that matches the actual layout, including several heading rows or identifying columns.

Choosing Which Rows and Columns to Keep Visible

Before freezing, decide what information you need to understand a cell when it is far from the top-left corner. For a sales export, you might need the column names and a customer name. For a schedule, you may need dates across the top and employee names down the side. Freeze only the rows and columns that provide useful context; a large fixed area leaves less room for the scrolling data.

One heading row and one label column: select B2.
Three heading rows and one label column: select B4.
One heading row and three identifying columns: select D2.
Two heading rows and three identifying columns: select D3.

These examples assume the rows and columns to be frozen are contiguous, starting at the top and left edge. Freeze Panes is designed to preserve that top-and-left rectangle; it cannot keep an arbitrary row in the middle of a sheet visible while other rows scroll past it. If you are unsure which area your selection will freeze, look for the divider lines that appear after you apply the command, then unfreeze and try another cell if needed.

How to Change or Remove a Freeze

Excel uses one freeze arrangement at a time on a worksheet. To adjust it, go to View > Freeze Panes > Unfreeze Panes, then select a new cell and choose View > Freeze Panes > Freeze Panes. For example, if a sheet currently freezes just the top row and you later decide to keep columns A and B visible too, unfreeze first, select C2, and apply Freeze Panes.

The dedicated commands are convenient when you need only one edge fixed. Choose View > Freeze Panes > Freeze Top Row to keep the first row visible, or View > Freeze Panes > Freeze First Column to keep column A visible. To combine both, use the general command from B2 rather than expecting the two dedicated commands to stack. Applying a different freeze choice replaces the existing arrangement.

Freeze settings are worksheet-specific. If a workbook has several tabs, check each one; freezing the first sheet does not freeze the others. A copied worksheet may carry its own layout settings, so verify the result when using duplicated sheets or distributing a workbook.

Freeze Panes Compared with Split and Tables

Freeze Panes and Split both divide the worksheet view, but they solve different problems. Freeze Panes keeps a selected top-and-left section stationary while the remaining area scrolls. Split divides the window into independently scrollable panes. If you want to compare two distant parts of a sheet at once, Split may suit that task better; if you want headings to stay visible as you browse one continuous list, Freeze Panes is usually the clearer choice.

Excel tables can also make column headings easier to work with. When you scroll down within a table, Excel can show the table’s column names in place of the worksheet column letters. That behavior can help with a structured list, but it does not keep a left-side identifier column visible when you scroll horizontally. A table and frozen panes can serve different purposes, and a table is not a replacement when the goal is to hold both a top row and a left column in view.

Neither feature changes the underlying data. Sorting, filtering, formulas, and printing are separate matters. Frozen panes affect the on-screen view; they do not, by themselves, repeat headings on printed pages. For print headings, use the worksheet’s page layout settings rather than assuming a freeze will carry over to printouts.

Common Problems and How to Fix Them

The wrong rows or columns are fixed: unfreeze, then select the cell at the boundary of the intended fixed area. Remember that Excel freezes above and left of the selection, not the selected cell.
Only the top row or first column is frozen: the dedicated Freeze Top Row or Freeze First Column command may have been used. Unfreeze, select B2, and use the general Freeze Panes command.
The menu shows Unfreeze Panes instead: a freeze is already active. Choose Unfreeze Panes before setting a different one.
The frozen area seems too large: the selected cell was too far down or to the right. For example, selecting D5 freezes rows 1 through 4 and columns A through C. Reset the freeze and use a cell closer to the upper-left corner.
The divider is hard to spot: look for a horizontal or vertical boundary line in the worksheet, and scroll to test whether the intended labels stay put. Zoom level, gridlines, and cell formatting can make the boundary less noticeable.

A common misconception is that freezing a row locks it against edits or deletion. It does not. Use worksheet protection or appropriate sharing controls if you need to limit editing, and treat Freeze Panes only as a way to make navigation easier.

Excel on Mac and in a Web Browser

In current Excel for Mac, select the boundary cell, then use the View tab’s Freeze Panes menu and choose Freeze Panes. The same principle applies: select B2 to keep row 1 and column A visible, or choose a cell farther down and right to freeze more rows and columns. Ribbon placement and wording can vary somewhat between updates, so look under View if the menu is arranged differently from Windows.

Excel for the web also offers freeze controls under View. Select the cell that marks the lower-right boundary of the area to retain, then use the Freeze Panes option where available. The browser interface may present a more compact menu than desktop Excel. If a command is missing or the workbook’s view behaves differently, opening the file in the desktop app is a practical way to access the full ribbon controls.

For all platforms, verify the outcome by scrolling both directions. The goal is not merely to see a divider but to confirm that the correct headings stay visible while the data moves.

Frequently Asked Questions

Can I freeze the top row and first column at the same time?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. The general Freeze Panes command applies the row-above and column-left rules together.

What cell should I select to freeze two rows and the first column?
Select B3, then apply Freeze Panes. Rows 1 and 2 are above B3, and column A is to its left.

Why does Freeze Panes not freeze the selected cell?
The selection marks the boundary. Excel freezes rows above it and columns to its left, leaving the selected cell in the scrolling area.

How do I unfreeze panes in Excel?
On the worksheet with the freeze, choose View > Freeze Panes > Unfreeze Panes. You can then apply a different arrangement if needed.

Does freezing the top row make it repeat on printed pages?
No. Freeze Panes changes the on-screen worksheet view only. Set print titles in the page layout or page setup controls if you want headings repeated on printed pages.

Can I freeze a row in the middle of the worksheet?
Not as an independent row while rows above it scroll. Freeze Panes keeps a contiguous area from the top and left edges; it does not pin an arbitrary interior row.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.