Excel Freeze Panes Not Available? Fix It

When Freeze Panes is unavailable or grayed out in Excel for Microsoft 365 on Windows, first exit cell-editing mode by pressing Enter or Esc, then switch to View > Normal and check that a worksheet—not a chart sheet—is active. In a normal worksheet view, use View > Freeze Panes; the command may also be unavailable because Excel is editing a cell or because you are using a different interface or view.

What Freeze Panes does

Freeze Panes keeps selected rows or columns visible while you scroll through the rest of a worksheet. It is useful when a table is larger than the screen and you need to keep its headings, labels, or identifying columns in view. For example, a sales sheet might have a header row in row 1 and customer names in column A. Freezing both lets you scroll down to later records and across to monthly figures without losing either reference.

Excel bases the freeze on the currently selected cell. It locks the rows above that cell and the columns to its left; it does not lock the selected cell itself. That rule is why selecting the right cell matters, and why choosing a built-in option such as Freeze Top Row is different from freezing a custom combination.

Check these common causes first

Before changing workbook settings, look for the conditions that most often make the command appear unavailable. In Excel for Microsoft 365 on Windows, try these checks in order:

You are editing a cell. If the insertion cursor is visible in the formula bar or inside a cell, press Enter to commit the edit or Esc to cancel it. Then open the View tab again.
The workbook is not in Normal view. Choose View > Normal. Page Layout and Page Break Preview are intended for page setup and printing; return to Normal before trying to freeze panes.
A chart sheet is active. Freeze Panes applies to worksheet grids, not a standalone chart sheet. Click a worksheet tab at the bottom of the Excel window.
You are looking in the wrong place. The command is on the View tab, in the Window group. If the ribbon is collapsed or the window is narrow, the group may be compressed; expand the ribbon or look for the command in the View tab’s reduced layout.
The active selection or interface is confusing the issue. Click an ordinary cell on the worksheet, then reopen the View tab. If the command remains unavailable, save the file and reopen it in the desktop Excel app to distinguish an interface limitation from a workbook-specific problem.

These checks are more useful than assuming that the file is damaged. A workbook being protected or saved in an older file format is not, by itself, a reliable explanation for a disabled Freeze Panes command. Avoid removing protection or changing file formats unless you have another reason to do so.

How to freeze the right rows and columns

To freeze a custom area, select the cell immediately below the rows and immediately to the right of the columns you want to keep visible. Then choose View > Freeze Panes > Freeze Panes. For example, to keep rows 1 through 3 and columns A and B on screen, select C4 first. Excel freezes everything above and to the left of that selection.

For common layouts, the menu includes two simpler commands:

Freeze Top Row keeps row 1 visible as you scroll vertically. It does not freeze any columns.
Freeze First Column keeps column A visible as you scroll horizontally. It does not freeze any rows.

These built-in commands refer specifically to the worksheet’s first row or first column. If your headings begin in row 4, selecting Freeze Top Row will not keep row 4 visible; select a cell in row 5 and use the general Freeze Panes command instead. Likewise, to keep column C visible, select a cell in column D and use the general command.

Unfreeze or change an existing setting

Excel allows one freeze configuration at a time on a worksheet. If panes are already frozen, the menu offers Unfreeze Panes. Choose View > Freeze Panes > Unfreeze Panes before creating a different arrangement. Then select the cell that defines the new boundary and apply Freeze Panes again.

This explains a frequent source of confusion: selecting a different cell and clicking Freeze Panes does not necessarily replace the current arrangement. First remove the existing freeze. The frozen boundary is shown by a line across the sheet or down it, depending on whether rows, columns, or both are fixed. The line can be subtle, especially at a zoom level that makes gridlines hard to distinguish.

Why the result may look wrong

If the command works but the wrong area stays in place, revisit the selected cell and the freeze boundary. Excel freezes all rows above and all columns to the left, not just the row or column containing a heading. For instance, selecting B2 freezes row 1 but no columns; selecting C2 freezes row 1 and columns A and B. Selecting A2 freezes row 1 and no columns.

Also check whether the worksheet is scrolled away from the top or left edge when you set up the freeze. The freeze is based on the cell selection, but a distant scroll position can make it harder to understand which rows and columns are being held in place. Return to the top-left area, select the intended boundary cell, and apply the command again if necessary.

Freeze Panes does not repeat headings on printed pages. It affects the worksheet display while navigating, not the print layout. To repeat a row or column on printed pages, use the separate print-title settings under Page Layout > Print Titles. The two features solve related but different problems.

Excel for the web, Mac, and mobile

In Excel for the web, Freeze Panes is available from the View tab, although the ribbon layout and available controls can vary with the browser window and the current version. If a command is missing in the browser, widen the window, check that you are in a worksheet, and try opening the workbook in the desktop app. The web version can also behave differently from desktop Excel in some workbook workflows, so confirm that the change is visible after saving.

In Excel for Mac, use the View > Freeze Panes menu or the Freeze Panes control on the View ribbon, depending on the ribbon layout. The basic selection rule is the same: select the cell below and to the right of the area to keep visible. Menu appearance can differ by release, so use the View tab or menu rather than relying on Windows-only ribbon screenshots.

On a phone or tablet, the compact interface may not expose the same controls in the same place as desktop Excel. If you cannot find the feature in the mobile app, use Excel for the web or desktop Excel to set the panes. A workbook with panes already frozen may still display them on another device, but the editing controls are not identical across platforms.

Freeze Panes, Split, and print titles compared

Freeze Panes is not the only way to make a large worksheet easier to navigate, but the alternatives do different jobs. Split, available from the View tab in desktop Excel, divides the worksheet window into independently scrollable sections. Unlike freezing, it is intended to let you inspect separate parts of the same sheet at once. If you simply want headers to remain in view while scrolling through a list, Freeze Panes is usually the more direct choice.

Print Titles repeats selected heading rows or columns on printed pages; it does not keep them visible while scrolling on screen. For a report that needs headings both during review and on paper, configure Freeze Panes for screen navigation and Print Titles separately for printing. Neither setting changes the underlying cell data.

A practical troubleshooting sequence

If the command is still unavailable after the quick checks, use a short, controlled sequence rather than changing many workbook settings at once:

Press Enter or Esc to leave any active cell edit.
Click a worksheet tab, then choose View > Normal.
Click a regular cell where you want the freeze boundary to begin.
Open View > Freeze Panes and check whether the menu offers Freeze Panes, Freeze Top Row, Freeze First Column, or Unfreeze Panes.
If the command is still unavailable, save the workbook and reopen it in the desktop version of Excel for Microsoft 365. Check whether the issue occurs in another worksheet or a new blank workbook.

If Freeze Panes works in a new workbook but not the original, compare the active sheet, view, and selection, and consider whether the original file has a workbook-specific restriction or unusual layout. If it is unavailable everywhere, restart Excel and check that you are using the full Excel application rather than a preview or a restricted viewing interface. Do not disable security controls or remove workbook protection without confirming why they are enabled.

Frequently Asked Questions

Why is Freeze Panes grayed out in Excel?
Most often, Excel is in cell-editing mode, the workbook is not in Normal view, or the active sheet is a chart sheet rather than a worksheet. Press Enter or Esc, choose View > Normal, and click a worksheet tab before trying again.

How do I freeze more than one row in Excel?
Select the cell in the first row below the rows to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A4 to freeze rows 1 through 3 without freezing any columns.

Can I freeze a row and a column at the same time?
Yes. Select the cell below the row boundary and to the right of the column boundary, then choose Freeze Panes. To keep row 1 and column A visible together, select B2.

Why does Freeze Top Row not keep my heading visible?
Freeze Top Row always refers to worksheet row 1. If your heading is lower down, select the cell immediately beneath it and use the general Freeze Panes command instead.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. You can then select a new boundary cell and freeze a different combination of rows and columns.

Does Freeze Panes repeat headings when I print?
No. Freeze Panes affects on-screen scrolling. Set rows or columns to repeat on printed pages separately through Page Layout > Print Titles.

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.