Excel Won’t Let Me Freeze Panes? Fixes to Try

Excel Won't Let Me Freeze Panes? Fixes to Try

If Excel will not let you freeze panes, first switch to View > Normal, finish editing any cell, and make sure you are on the worksheet you want to adjust. In Microsoft 365 for Windows, choose View > Freeze Panes; if the command is unavailable, these checks usually explain why, and if it works but freezes the wrong area, the selected cell is the key.

How Freeze Panes Works

Freeze Panes keeps rows above, columns to the left, or both in view while you scroll through a worksheet. It does not lock cells against editing, protect data, or stop the sheet from scrolling. It changes how the current worksheet is displayed so labels or identifiers remain visible as you move around.

The active cell determines the boundary. For example, select C4 and choose View > Freeze Panes > Freeze Panes to keep rows 1 through 3 and columns A and B visible. Select A4 to keep only rows 1 through 3; select C1 to keep only columns A and B. Excel cannot freeze an arbitrary row in the middle while allowing rows above it to scroll independently: frozen rows are anchored at the top, and frozen columns at the left.

Excel also offers shortcuts in the menu for common cases: Freeze Top Row and Freeze First Column. These refer specifically to row 1 and column A, not whichever row or column happens to be selected.

Check Why the Command Is Unavailable

Work through these checks in order. Often the command is not broken; Excel is in a mode or state where the pane controls are unavailable.

Finish cell editing. If a cursor is active inside a cell or the formula bar, press Enter to accept the edit or Esc to cancel it. Then try the command again.
Return to Normal view. On the View tab, choose Normal. Freeze Panes is intended for the normal worksheet view and may be unavailable or behave differently in Page Layout or Page Break Preview.
Check for a selected object. If a chart, picture, or other object is selected, click an ordinary worksheet cell before opening the Freeze Panes menu.
Look at the workbook window. If Excel is showing a dialog, a worksheet is not active, or the window is in a special display state, close or exit that state and return to the grid.
Check the ribbon layout. In a narrow window or simplified ribbon, controls may be collapsed. Maximize the Excel window or open the View tab’s overflow menus to find Freeze Panes.

Changing worksheet protection is not a good first troubleshooting step. Pane display controls are separate from ordinary cell editing, and removing protection can affect workbook security. If a company-managed workbook has restricted commands, ask its owner or administrator rather than changing protection settings at random.

Reset the Existing Freeze Before Trying Again

A common reason the result seems wrong is that the sheet already has a freeze boundary. Excel generally offers Unfreeze Panes in place of the freeze choices when panes are already frozen. Select View > Freeze Panes > Unfreeze Panes first. Then select the cell that defines the new boundary and apply Freeze Panes again.

For example, suppose you want the top two rows and the first column to remain visible. If an old setting is already keeping row 1 and columns A through C in place, selecting B3 and choosing Freeze Panes may not replace that boundary as expected. Unfreeze first, select B3, and then apply the command. The new setting keeps rows 1 and 2 and column A visible.

Unfreezing does not delete, move, or change worksheet data. It only restores ordinary scrolling. If the menu shows Unfreeze Panes, that is evidence that a freeze is already active, even if the frozen boundary is difficult to notice at the current zoom or scroll position.

Choose the Right Cell for the Boundary

When the command runs but the wrong area stays on screen, identify the first row and first column you want to remain scrollable. Select the cell at their intersection, then apply Freeze Panes. Rows above that cell and columns to its left become the frozen area.

To keep only the header row visible, use View > Freeze Panes > Freeze Top Row.
To keep only the names in column A visible, use View > Freeze Panes > Freeze First Column.
To keep rows 1–3 and columns A–B visible, select C4 and choose Freeze Panes.
To keep rows 1–2 and column A visible, select B3 and choose Freeze Panes.

If you select a cell in row 1, there are no rows above it to freeze; if you select a cell in column A, there are no columns to its left. That is why selecting B2 is the usual starting point when you want to freeze the first row and first column together. Use the main Freeze Panes command for a custom boundary, rather than the Top Row or First Column shortcut.

Confirm You Are in the Worksheet You Mean to Change

Freeze Panes applies to the active worksheet view, not to every sheet in a workbook as a single global setting. If a workbook has separate tabs for January, February, and March, setting a freeze on January does not automatically mean the other tabs will have the same freeze. Click the relevant sheet tab and check its own menu state.

Excel can also show more than one window for a workbook. If you opened another view of the same file, make sure you are changing the window in which you actually work. A frozen boundary can be easy to miss if the active window is small, zoomed unusually, or scrolled far from the top-left corner. Return to cell A1 or use the sheet’s scroll bars to inspect the boundary after applying it.

For a large data sheet, freeze only the labels that are genuinely useful while scrolling. Freezing several rows and many columns can leave little room for the data area, particularly on a laptop display. A simpler boundary is often easier to read and less likely to be mistaken for a stuck or unresponsive worksheet.

Windows, Mac, and Excel for the Web

In Excel for Microsoft 365 on Windows, use the View tab on the ribbon, then open Freeze Panes. Choose Freeze Panes, Freeze Top Row, or Freeze First Column, as appropriate. To remove the current setting, use View > Freeze Panes > Unfreeze Panes.

In Excel for Mac, the freeze controls are also available from the View tab. Ribbon placement can look different depending on the window and version, so look for the Freeze Panes control on that tab. Excel for the web also provides freeze controls from View > Freeze Panes; if you cannot find the command in a compact browser window, widen the window or inspect the ribbon’s overflow options. The precise layout can vary, but the boundary rule remains the same: the selected cell determines which rows above and columns to the left are kept visible.

There is no need to use a special keyboard shortcut to set a freeze. The ribbon menu is the clearest way to see whether Excel offers Freeze Panes or Unfreeze Panes and which preset you are choosing.

Freeze Panes, Split, and Scroll Lock Are Different

Freeze Panes keeps a chosen top section and/or left section visible as you scroll. Split, found on the View tab, divides the worksheet window into separate panes that can be scrolled independently. Split is useful when you want to compare distant parts of the same worksheet; it is not a substitute for keeping a header fixed in one continuous view.

Scroll Lock is different again. It changes how the arrow keys move the worksheet view in some Excel setups; it does not create or remove a freeze boundary. If the arrow keys scroll the sheet when you expected to move between cells, check whether Scroll Lock is on. On keyboards without a Scroll Lock key, the way to toggle it depends on the computer and its on-screen keyboard, so do not assume that toggling it will fix Freeze Panes itself.

Look for the visual boundary between frozen and scrolling areas. In a frozen sheet, the top rows or left columns remain stationary while the rest moves. In a split view, there are separate panes divided by a split bar. Recognizing the difference prevents changing the wrong View command.

When the Freeze Still Looks Wrong

After applying the setting, test it deliberately: scroll down several rows, then sideways. If the top labels stay while lower rows move, the row freeze is working. If the left identifiers stay while the right side moves, the column freeze is working. If nothing appears to happen, the active cell may have been in row 1 or column A, or you may have selected a preset that freezes a different area than intended.

Very short worksheets offer little visible evidence of a freeze, and a wide frozen region can make the scrollable area narrow. Zooming out temporarily or returning to the top-left corner can help you see the boundary. If the worksheet has hidden rows or columns, the frozen region may also look different from the visible sequence of labels; unhide them only if you actually need to inspect that layout.

If the menu remains disabled after switching to Normal view, exiting cell editing, and selecting a regular cell, save the workbook and reopen it. If the problem occurs only in one file, check whether it is opened in a restricted or organization-managed environment and ask the workbook owner about access restrictions. If it occurs in every workbook, restart Excel and check for available Microsoft 365 updates through your organization’s normal update process.

Frequently Asked Questions

Why is Freeze Panes greyed out in Excel?
First finish editing a cell, select a normal worksheet cell, and switch to View > Normal. Also check that you have the intended worksheet active and that the ribbon control has not been collapsed into an overflow menu. If the command is still unavailable, the workbook or device may be subject to managed restrictions.

How do I freeze the top row and first column at the same time?
Click cell B2, then choose View > Freeze Panes > Freeze Panes. The selection is below row 1 and to the right of column A, so both remain fixed. If an old freeze is active, choose Unfreeze Panes first.

Why does Excel freeze the wrong rows or columns?
The selected cell sets the boundary. Excel freezes every row above it and every column to its left. Unfreeze the current setting, select the correct boundary cell, and apply the main Freeze Panes command again.

Can I freeze two nonadjacent rows or columns?
No. Freeze Panes keeps a continuous block beginning at the worksheet’s top and/or left edge. It cannot keep separated rows or columns fixed while allowing the rows or columns between them to scroll independently.

How do I remove Freeze Panes?
Choose View > Freeze Panes > Unfreeze Panes. This changes the worksheet’s scrolling display only; it does not delete data or undo cell formatting.

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.