Excel Freeze Panes Not Working? Fix the View

If Excel Freeze Panes is not working, switch to Normal view, select the cell below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. If an old freeze is already active, first choose View > Freeze Panes > Unfreeze Panes, then set it again.

Most apparent failures come from selecting the wrong cell, expecting the command to freeze a different area, or overlooking a view or existing setting that affects the result. The feature does not lock cells against editing; it keeps chosen worksheet rows and columns on screen while you scroll through the rest of the sheet.

How Freeze Panes is supposed to work

Excel freezes rows above the active cell and columns to its left. For example, select C5 and choose Freeze Panes, and Excel keeps rows 1 through 4 and columns A and B visible as you scroll. The selected cell itself is not the dividing line: the frozen area is above and to the left of it.

This rule lets you freeze rows and columns together, which is useful when a table has both headings and identifying fields. To keep only the first row visible, use View > Freeze Panes > Freeze Top Row. To keep only column A visible, choose Freeze First Column. These are preset actions; select Freeze Panes itself when you need a custom combination.

Freeze Panes applies to the active worksheet, not to every sheet in the workbook. A different worksheet can have a different freeze setup. It also does not change which cells contain data, how a formula calculates, or what prints on a page.

Set the correct rows and columns

Before choosing the command, identify exactly what should remain visible. If row 1 contains headings and you want columns A and B to stay visible too, select C2. Excel will freeze row 1 and columns A:B. If you want the first three rows and first column to stay in view, select B4. When choosing a custom freeze, the active cell’s position determines both boundaries.

Click the worksheet tab you want to configure.
Scroll to the top and left if that makes the intended boundary easier to identify.
Select the cell one row below the last row to freeze and one column to the right of the last column to freeze.
Choose View > Freeze Panes > Freeze Panes.
Scroll down or right to check that the intended headings remain visible.

For instance, a sales sheet may have a title in row 1, field names in row 2, and customer names in column A. To keep the field names and customer names visible, select B3 before freezing. Choosing B2 instead freezes only row 1 and no columns. That one-cell difference is a frequent source of confusion.

Remove an old freeze before changing it

Excel uses one freeze boundary at a time on a worksheet. If panes are already frozen, selecting a new cell and choosing Freeze Panes does not simply add another boundary. Choose View > Freeze Panes > Unfreeze Panes first. Then select the new boundary cell and apply the desired setting.

This matters when switching between a preset and a custom layout. For example, if Freeze Top Row is active and you now want the top two rows plus column A, unfreeze first, select B3, and choose Freeze Panes. If the menu offers Unfreeze Panes, that is a clue that the sheet currently has a freeze setting. After unfreezing, the worksheet will scroll normally until you apply another one.

Check the worksheet view and visible boundary

Freeze Panes is intended for Normal view. If the command is unavailable or the worksheet is displaying page-oriented layout, choose View > Normal and try again. Page Layout view emphasizes printed pages rather than ordinary scrolling, so it is not the right place to diagnose a freeze-pane setup.

After freezing, look for a thin divider between the fixed area and the scrolling area. It can be subtle, particularly at a low zoom level or when the boundary is close to the edge of the window. Scroll well down the sheet or far to the right: if the selected headings remain visible while other cells move, the feature is working even if the divider is hard to spot. Increasing the zoom temporarily or returning to the top-left corner can make the boundary easier to inspect.

Hidden rows or columns can also make the result seem unexpected. Freeze Panes follows the selected cell’s row and column position, not a visual guess about where the table begins. Check whether rows or columns before that cell are hidden, and unhide them if necessary to verify the boundary. A filter hiding records does not itself create or remove frozen panes.

Why the command may be unavailable

If Freeze Panes is grayed out, first check that Excel is not in cell-edit mode. Press Enter or Esc to finish editing a cell, then check the View tab again. Also confirm that you are in Normal view and that the intended worksheet is active. If the workbook has several open windows, make sure you are looking at the window and sheet where you want the setting.

On Windows, the usual ribbon path in Excel for Microsoft 365 is View > Freeze Panes. The menu contains Freeze Panes, Freeze Top Row, Freeze First Column, and—when a freeze is in place—Unfreeze Panes. Excel for Mac has the equivalent Freeze Panes controls on the View tab; menu wording and ribbon layout can vary with the app version, but the selection rule is the same. On a Mac, use the View tab’s Freeze Panes menu rather than relying on Windows ribbon shortcuts.

Freeze Panes compared with Split

Freeze Panes and Split can both divide a worksheet window, but they solve different problems. Freeze Panes keeps selected top rows and left columns stationary while the rest of the sheet scrolls. Split divides the window into independently scrollable sections, which can help compare distant parts of one worksheet. A split does not mean that the top headings are permanently fixed in the same way.

If the sheet shows multiple scrollable regions or dividers that do not match the expected frozen area, look at View > Split. Turn off Split if you want a conventional frozen-heading layout, then apply Freeze Panes using the correct boundary cell. Avoid treating the two commands as interchangeable: choose Freeze Panes for persistent headers and Split for separate viewing regions.

Excel for the web and other practical limits

Excel for the web also provides Freeze Panes controls on its View tab, though the ribbon may look different from the Windows desktop app. The same core approach applies: select the boundary cell, open the freeze control, and choose the custom freeze option. If a command is missing in the browser, check that you are editing the workbook in Excel rather than viewing it in a read-only state, and confirm that the browser window is wide enough to show the full ribbon.

Freezing panes affects what you see while navigating; it is not a print setting. If headings must appear on every printed page, use the separate print-title settings in the Page Layout tab rather than relying on Freeze Panes. Similarly, if the goal is to prevent someone from changing cells, use worksheet protection or sharing permissions as appropriate. Freeze Panes does not protect data, and protecting a worksheet is not a substitute for a scrolling layout.

A quick troubleshooting checklist

When the result still looks wrong, check these items in order rather than repeatedly clicking the same command:

Confirm that the correct worksheet tab is active.
Choose View > Normal if the sheet is in another view.
Finish editing any cell and return focus to the worksheet grid.
Choose Unfreeze Panes before changing an existing boundary.
Recalculate the boundary cell: the frozen rows must be above it and frozen columns to its left.
Scroll vertically and horizontally to test the result, rather than judging only by the divider.
Check for hidden rows, hidden columns, or an active Split that could make the layout confusing.

As a simple diagnostic, select B2 after unfreezing and choose Freeze Panes. Only row 1 should remain fixed; no columns should. If that works, the feature is available and the earlier issue was likely the boundary selection or an existing layout setting. Then unfreeze and configure the intended custom boundary.

Frequently Asked Questions

Why does Excel freeze the wrong row?
Excel freezes every row above the selected cell, not the row containing the selection. To freeze rows 1 and 2, select a cell in row 3, such as A3, before choosing View > Freeze Panes > Freeze Panes.

How do I freeze the top two rows and the first column?
Unfreeze any existing panes, select B3, and choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 are above B3, and column A is to its left, so all three stay visible while you scroll.

Why is Freeze Panes grayed out in Excel?
Check that you are in Normal view and have finished editing a cell. Then click the intended worksheet and reopen the View tab. In Excel for the web, also confirm that the workbook is open for editing rather than read-only.

Can I freeze rows and columns at the same time?
Yes. Select the cell immediately below the last row and immediately to the right of the last column you want to keep visible, then choose Freeze Panes. For example, C2 freezes row 1 and columns A:B.

Does Freeze Panes make headings repeat when I print?
No. Freeze Panes affects on-screen scrolling only. To repeat headings on printed pages, set print titles from the Page Layout tab; that is a separate page-printing feature.

Choose the fix that matches the symptom

If the menu is available but the wrong area stays fixed, correct the selected cell and reset the existing panes first. If the command is disabled, check Normal view and exit cell-edit mode. If the pane seems to work but the line is hard to see, test by scrolling and inspect hidden rows, columns, or Split. Once the boundary cell matches the layout you want, Freeze Panes should keep the relevant headings and identifiers in view without altering the worksheet’s data.

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.