Excel Freeze Panes Not Freezing Selection? Fix It

Excel Freeze Panes does not lock the cell or range you select; it keeps the rows above and columns to the left of the active cell visible while you scroll. In Excel for Microsoft 365 on Windows, select the cell just below the rows and just right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes.

What Freeze Panes actually does

Freeze Panes creates a boundary in the worksheet. Rows above that boundary stay on screen during vertical scrolling, and columns to its left stay on screen during horizontal scrolling. The cells on the boundary itself are not what Excel freezes. This is why selecting a header cell and choosing Freeze Panes can seem to do nothing: if the active cell is in the first row and first column, there may be no rows above or columns to the left to keep visible.

For example, suppose row 1 contains column headings and your data runs down the sheet. Select A2, then choose View > Freeze Panes > Freeze Panes. Row 1 remains visible as you scroll down. To keep columns A and B visible as well, select C2 instead. To keep the first two rows and first two columns visible, select C3.

Freeze Panes is useful for long lists, schedules, inventory sheets, and wide reports: the labels stay in view so you can tell what a row or column represents. It does not protect cells from editing, prevent scrolling in the rest of the worksheet, or lock a particular data range.

Select the cell that sets the boundary

The active cell—the one Excel treats as the current cell in your selection—sets the freeze boundary. A multi-cell selection can be misleading because Excel uses its active cell, not the entire highlighted area. If the active cell is not where you expect, click the exact boundary-setting cell before using the command.

Use these examples to plan the selection:

Keep row 1 visible: select A2.
Keep rows 1 through 3 visible: select A4.
Keep column A visible: select B1.
Keep columns A through C visible: select D1.
Keep rows 1 and 2 plus columns A and B visible: select C3.

Excel freezes continuous blocks starting at the top of the sheet and the left edge. It cannot freeze only row 5 while letting rows 1 through 4 scroll away, or freeze column D while columns A through C scroll independently. If you need a particular row or column to act like a header, move or copy it to the top or left of the data, or consider a different layout.

Unfreeze first, then apply the new setting

An existing freeze can make a new selection appear to have no effect. Excel generally allows one frozen-pane arrangement at a time on a worksheet. Clear the current arrangement before creating another:

Open the worksheet where the panes are frozen.
Choose View > Freeze Panes > Unfreeze Panes.
Click the cell that defines the new boundary, such as C3 to hold the first two rows and columns.
Choose View > Freeze Panes > Freeze Panes.

If you only need a standard header, the menu also offers Freeze Top Row and Freeze First Column. These are quick choices for row 1 or column A. They are not substitutes for selecting a custom boundary: use Freeze Panes when you want multiple rows, multiple columns, or both.

After unfreezing, Excel may return the worksheet to a different scroll position. That does not mean the command failed. Check the pane divider and scroll the sheet to confirm which rows and columns stay in place.

Common reasons the selection seems ignored

When freezing does not match your intention, check the setup before assuming the workbook is broken. These are frequent causes:

The active cell is A1. There are no rows above or columns to the left of A1, so a custom freeze has no visible area to preserve.
You selected the header instead of the cell below it. To keep row 1, select a cell in row 2. To keep rows 1 and 2, select a cell in row 3.
An old freeze is still active. Choose Unfreeze Panes, then set the new boundary.
You chose Freeze Top Row or Freeze First Column. Those commands freeze only the top row or leftmost column, regardless of a custom selection.
You expected a selected cell or range to stay visible. Freeze Panes preserves whole rows above and whole columns to the left; it does not pin an arbitrary block of cells.
The sheet is scrolled or partly hidden. Check whether rows or columns are hidden, or whether the worksheet is positioned far from the top-left. Hidden rows and columns can make the visible result confusing.

Also check that the command is being applied to the intended worksheet. Freeze settings are associated with the sheet, so freezing one tab does not automatically freeze every other tab in the workbook. If the command is unavailable or the result is difficult to interpret, switch to View > Normal and try again there.

How to verify the result and adjust the view

Once panes are frozen, scroll down or across. The frozen rows should remain at the top while the lower rows move; frozen columns should stay at the left while the columns to their right move. Excel displays a divider at the edge of the frozen area. If only one direction is frozen, you will see the corresponding divider rather than a full grid dividing both directions.

For a practical check, use a sheet with headings in row 1 and records below. Select A2 and apply Freeze Panes. Scroll down several screens: row 1 should remain visible. If you also need identifiers in column A while reading far-right fields, unfreeze and apply the setting from B2. If you need both the headings and identifiers, use C2 instead. This works because the selected cell’s position determines the rows-above and columns-left boundary.

Freeze Panes does not change the worksheet’s data, formulas, print layout, or sort order. It changes how the sheet is displayed while you work. If the divider is in the wrong place, unfreeze and reapply it rather than dragging the divider as if it were a Split control.

Freeze Panes versus Split

Freeze Panes and Split both divide the worksheet view, but they solve different problems. Freeze Panes keeps specified top rows and left columns visible while the main area scrolls. Split creates separate viewing areas that can be scrolled independently, which can help compare distant parts of one worksheet.

For instance, use Freeze Panes to keep a table’s headings visible while you review hundreds of records. Use Split if you want to inspect the first few rows and a much later section at the same time. A split is not a way to pin a chosen cell, and it can be confusing if you only want fixed headers. If an unexpected divider appears, check View for the Split command and turn it off, then apply the appropriate freeze setting.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, the standard route is View > Freeze Panes. The submenu contains Freeze Panes, Freeze Top Row, Freeze First Column, and, when a freeze is already in place, Unfreeze Panes. The steps in this guide use that Windows ribbon path.

In Excel for Mac, use the View tab and its Freeze Panes command; menu labels and ribbon layout can vary slightly by release. The same boundary principle applies: place the active cell below and to the right of the rows and columns to preserve. Excel for the web also provides freeze controls on the View tab, though available options and the interface can differ from desktop Excel. If a specific custom arrangement is hard to set in the web interface, open the workbook in the desktop app and set the boundary there.

There is no need to change cell formatting or convert a range to a table just to freeze headings. A table can offer its own helpful behaviors, such as filtering and displaying column names in certain views, but it does not replace the worksheet’s Freeze Panes setting for keeping rows and columns visible during scrolling.

Useful layout choices before freezing

Before freezing a large report, decide which labels people need while they move through it. Keep the most important headings in the first row or rows, and put identifying fields such as an ID or name in the first column or columns. This makes a useful freeze boundary possible without preserving a large block that leaves too little room for the data.

For example, if a worksheet has a two-row title area followed by a column-heading row, freezing the first three rows may keep all the context visible. But if those rows occupy much of a laptop screen, the remaining scrolling area can feel cramped. You might instead move the title out of the data area or simplify the heading layout. Freeze only what readers need to interpret the visible records.

When sharing a workbook, save it after setting the view and tell collaborators which sheet contains the frozen panes. Freezing is a viewing aid, not a data safeguard. Use worksheet protection separately if you need to restrict editing, and keep an appropriate backup before making structural changes to important workbooks.

Frequently Asked Questions

Why does Freeze Panes freeze the wrong rows?
Excel uses the active cell to set the boundary. Select the cell immediately below the last row you want to keep visible, then unfreeze and apply Freeze Panes again.

Can I freeze the first two rows and the first column?
Yes. Select B3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 and column A should remain visible as you scroll.

Can I freeze a single cell in Excel?
No. Freeze Panes keeps whole rows above and whole columns to the left of the active cell; it cannot pin one individual cell or an arbitrary rectangular selection.

How do I remove frozen panes?
On the worksheet with the freeze, choose View > Freeze Panes > Unfreeze Panes. You can then set a different boundary or leave the sheet unfrozen.

Does Freeze Panes work when I print?
Freeze Panes affects the on-screen worksheet view, not printed page repetition. To repeat headings on printed pages, use the separate Print Titles settings on the Page Layout tab.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.