Excel Freeze Panes Not Working? Fix the Selection

If Excel is not freezing the rows or columns you selected, click the cell immediately below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C2 to freeze row 1 and columns A:B; if the command appears to do nothing, unfreeze first and check the active cell, worksheet view, and whether a split is already active.

How Freeze Panes decides what stays visible

Freeze Panes is based on the active cell, not on a highlighted range or on the row and column headers you happened to click. Excel keeps every row above the active cell and every column to its left stationary while you scroll the rest of the worksheet. The cell itself is not frozen; it marks the boundary of the frozen area.

For instance, selecting D5 and choosing View > Freeze Panes > Freeze Panes keeps rows 1 through 4 and columns A through C in view. Selecting A2 keeps only row 1 fixed, while selecting C1 keeps columns A and B fixed. The rule explains why choosing the right menu command can still produce the wrong result: if the active cell is not at the intended boundary, Excel freezes a different set of rows or columns.

Freeze Panes is useful in long lists where headings would otherwise scroll away, or in wide tables where an identifying field such as a customer name should remain visible. It does not lock cells against editing, protect data, or prevent scrolling across the frozen area. It changes the worksheet view.

Choose the right cell before freezing

First decide exactly which rows and columns should remain on screen. Then select the cell one row below the last row to freeze and one column to the right of the last column to freeze. If you need to freeze only rows or only columns, the same boundary rule applies, with the other boundary at the edge of the sheet.

To keep row 1 visible, choose View > Freeze Panes > Freeze Top Row.
To keep column A visible, choose View > Freeze Panes > Freeze First Column.
To keep rows 1–3 and column A visible, select B4, then choose View > Freeze Panes > Freeze Panes.
To keep rows 1–2 and columns A–C visible, select D3, then choose Freeze Panes.

The dedicated Top Row and First Column commands are convenient, but they do not combine automatically. If you need both a heading row and an identifying column, use the general Freeze Panes command with a cell such as B2. If your heading is on row 4 rather than row 1, select a cell below row 4 and use the general command; Freeze Top Row would keep only row 1.

Reset the current freeze before trying again

Excel generally allows one frozen boundary arrangement per worksheet view. If panes are already frozen, selecting another cell and choosing Freeze Panes may not replace the existing arrangement. Open View > Freeze Panes and choose Unfreeze Panes first. Then click the correct boundary cell and apply the desired freeze. The menu usually displays Unfreeze Panes when a freeze is already active.

After unfreezing, the worksheet returns to normal scrolling. This does not delete rows, change cell contents, or alter the workbook’s data. It only removes the current view setting, so it is a safe first step when the existing boundary is unclear.

Once you apply the new setting, check it by scrolling down and across. The frozen area is separated from the scrolling area by a line. If the wrong rows or columns remain in place, unfreeze and repeat with a different active cell rather than trying to drag the line.

Check for Split and worksheet view settings

Split and Freeze Panes both divide a worksheet window into areas, but they are different tools. Split creates independently scrollable sections; Freeze Panes keeps the rows above and columns left of a boundary stationary. If Split is active, the panes can make a freeze appear confusing or unavailable. Go to View and check whether Split is selected; turn it off, then set Freeze Panes again.

Also check that Excel is in Normal view. On the View tab, choose Normal if the sheet is in Page Layout or Page Break Preview and the freeze controls are unavailable or behave differently than expected. These view choices do not change the worksheet’s printed content; they affect how it is displayed while you work.

If you are editing a cell, finish or cancel the edit before changing the view. Press Enter to accept the edit or Esc to cancel it, then try the command again. When a command is unavailable, look at the View tab for an active Split setting and confirm you are working in the intended worksheet window.

Common reasons the freeze looks wrong

A freeze can be active even when it does not seem to help. If you freeze row 1 but scroll only a small distance, the heading may still be visible without an obvious dividing line. Scroll farther down to confirm which area is stationary. Similarly, freezing column A will not be noticeable if the sheet is too narrow to scroll horizontally.

Other frequent causes include:

The wrong cell was active. In a multi-cell selection, Excel uses the active cell, typically the white cell within the highlighted selection. Click one specific boundary cell before applying the command.
A preset was used instead of a custom freeze. Freeze Top Row cannot preserve a heading on row 3, and Freeze First Column does not preserve columns A and B together.
An old freeze remained in place. Use Unfreeze Panes before setting a new boundary.
The selected cell was at the edge. Selecting A1 for general Freeze Panes leaves no rows above or columns to the left, so there is no visible frozen area.
The worksheet is not the one you intended. Freeze settings apply to the active sheet view. Check the selected sheet tab before changing them.

A useful check is to select a cell well inside the sheet, such as D5, and examine the result: rows above and columns to the left should remain fixed. If they do, the feature is working; the boundary simply needs to be adjusted for your actual layout.

Using Freeze Panes in Excel for the web and Mac

These steps are for Excel for Microsoft 365 on Windows. Excel for Mac also provides Freeze Panes from the View tab, although the ribbon arrangement and menu labels can vary slightly by release. Use the same boundary-cell rule, and look for Unfreeze Panes if a previous setting needs to be removed. Windows ribbon keyboard sequences should not be assumed to work on a Mac; using the View menu is the clearest cross-platform method.

Excel for the web also supports freezing rows and columns through the View tab. The available controls can depend on the current browser interface and workbook state. If you cannot find the needed option or the view is not updating, open the workbook in the desktop app and apply the setting there. A freeze is a display preference, not a change to the values stored in the worksheet.

Freeze Panes versus Split and protection

Freeze Panes is usually the right choice when the goal is to keep table labels visible while scrolling. Split is better when you want to inspect two parts of the same worksheet at once and scroll those sections separately. For example, a split can help compare distant rows, while freezing the header keeps the column names visible throughout a long list.

Neither feature is a security control. Frozen cells can still be edited if the worksheet permits editing, and a frozen heading is not protected from changes. To restrict editing, use worksheet protection settings; to keep labels visible, use Freeze Panes. These solve different problems and should not be confused.

Freeze settings belong to the worksheet view, so they do not remove or rearrange the underlying data. If another person opens the workbook and sees a different view, they can check the active sheet and its freeze setting rather than assuming rows or columns have been hidden or deleted.

Frequently Asked Questions

Why does Freeze Panes freeze the wrong rows?
Excel freezes the rows above the active cell, not necessarily the rows you highlighted. Unfreeze the current setting, select the cell directly below the last row you want fixed, and choose View > Freeze Panes > Freeze Panes.

How do I freeze both the top row and first column?
Select B2 and choose View > Freeze Panes > Freeze Panes. That keeps row 1 and column A stationary. For a different number of rows or columns, select the cell immediately below and to the right of the desired frozen area.

Why is Freeze Panes greyed out?
Check whether you are editing a cell, whether Split is active, and whether the worksheet is in Normal view. Finish or cancel cell editing, turn off Split if needed, and try again. If the option is still unavailable, check that you are in the intended workbook and worksheet view.

Can I freeze a row that is not at the top?
You can freeze all rows above a selected cell, but Freeze Panes does not freeze an isolated middle row while allowing the rows above it to scroll independently. To keep row 4 visible, for example, freeze rows 1 through 4 by selecting a cell on row 5.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the view boundary without deleting or changing worksheet data. You can then choose a new boundary cell and freeze a different combination.

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.