Excel Freeze Panes Not Working? Fix the Common Causes

If Excel Freeze Panes is not working, first choose the cell just below the rows and to the right of the columns you want to keep visible, then select View > Freeze Panes > Freeze Panes. If the wrong area stays fixed—or nothing appears to happen—unfreeze the current setting and try again from the correct cell.

How Freeze Panes is supposed to work

Freeze Panes keeps selected rows at the top of the worksheet and selected columns on the left while you scroll through the rest. It does not pin whichever cell you click, and it cannot hold a section in the middle of the sheet in place. The active cell is a boundary marker: Excel freezes the rows above it and the columns to its left.

For example, select C5 and choose View > Freeze Panes > Freeze Panes. Rows 1 through 4 and columns A and B remain visible as you scroll. The cell C5 itself is not frozen. To keep only the header row visible, choose View > Freeze Panes > Freeze Top Row; to keep only column A visible, choose Freeze First Column.

This behavior explains many apparent failures. If you select A5, Excel can freeze rows above row 5, but it has no columns to the left of A to freeze. If you select C1, it can freeze columns A and B, but there are no rows above row 1 to hold in place. Choose the selection based on the exact combination you need.

Reset the existing freeze before trying again

Excel normally allows one frozen pane arrangement at a time on a worksheet. If a previous setting is active, selecting a different cell and clicking Freeze Panes may not replace it as expected. Clear the old arrangement first: go to View > Freeze Panes > Unfreeze Panes. Then select the correct cell and apply the new setting.

Open the worksheet where scrolling is behaving incorrectly.
Choose View > Freeze Panes and check whether Unfreeze Panes is available. If it is, click it.
Select the cell below the last row and to the right of the last column you want to keep visible.
Choose View > Freeze Panes > Freeze Panes. Scroll down and across to confirm the intended rows and columns stay visible.

Freeze settings apply to an individual worksheet, not every sheet in a workbook. If several tabs need the same arrangement, repeat the steps on each one. A freeze setting is a view setting rather than a change to the cell contents, so resetting it does not delete worksheet data.

Check that you selected the right cell

When both rows and columns should remain visible, use the intersection rule: select one cell below the rows to freeze and to the right of the columns to freeze. To keep the first three rows and first two columns visible, select C4. Selecting C3 would keep only rows 1 and 2, along with columns A and B; selecting B4 would keep the first three rows but only column A.

The worksheet may be scrolled when you make the selection, which can make the boundary harder to judge. Use the Name Box, to the left of the formula bar, to jump directly to a cell such as C4. Then apply Freeze Panes. The Name Box is especially useful in a large sheet where scrolling back to the top before setting the boundary would otherwise be awkward.

Also distinguish a selection from the frozen area. Excel freezes entire rows above the selected cell and entire columns to its left. It cannot freeze only part of a row, or keep a particular record visible while the rest of the worksheet moves.

Make sure you are using Freeze Panes, not Split

Split and Freeze Panes can look similar because both divide the worksheet into regions. Split creates separate panes that can scroll independently; it does not make the top rows or left columns stay fixed in the same way. If you see movable divider bars or different sections scrolling separately, turn off Split from the View tab, then set Freeze Panes using the desired boundary cell.

Freeze Panes is usually the right choice for a long list with headings or identifying columns. For instance, a sales report with names in column A and month headings in row 1 is easier to read if the top row and first column remain visible. Split can be useful when you want to compare distant parts of one worksheet at the same time, but it is not a substitute for freezing headers.

Look for signs that the panes are already frozen

The frozen boundary can be subtle, particularly at a low zoom level or when gridlines and borders are prominent. Look for a darker horizontal line below the frozen rows and a darker vertical line to the right of the frozen columns. Then scroll several rows down or several columns right. A frozen header should remain in place while the worksheet body moves.

If the line is not obvious, use View > Freeze Panes. When panes are frozen, the menu offers Unfreeze Panes. You can use that command as a reliable reset even if you cannot easily see the boundary. Do not assume that a row is frozen just because it remains visible before you scroll; test the sheet by moving well beyond the frozen region.

Zooming out or maximizing the Excel window can help reveal the boundary and make the fixed region easier to distinguish. Zoom does not change which rows or columns are frozen, but a very small window or a crowded display can make the result look unexpected.

Check the worksheet view and scrolling behavior

Freeze Panes is designed for worksheet navigation. If you are looking at a print preview or a page-oriented view, return to View > Normal and test scrolling there. Also check whether the sheet is split, whether a scroll bar has been moved far to the side, and whether rows or columns are hidden. A hidden row can make the frozen boundary seem to skip a number, even though Excel is holding the worksheet position you selected.

Frozen rows stay at the top of the worksheet window, and frozen columns stay at the left. They do not repeat as printed page headings; that is a separate print setting. If the real problem is that headings disappear on paper, use Page Layout > Print Titles and set rows to repeat at the top or columns to repeat at the left. Freeze Panes affects on-screen scrolling, not the printed page layout.

If the worksheet is protected or the workbook is opened in a restricted state, commands may be unavailable or the interface may behave differently. Check whether the View tab command is enabled and whether the file is editable. Do not remove protection unless you have permission and understand why it was applied.

Excel for the web and Mac differences

In Excel for Microsoft 365 on Windows, use the View tab and its Freeze Panes menu. Excel for the web also provides Freeze Panes from the View tab, though the ribbon layout can differ slightly by browser window size. If the command is hard to locate, expand the ribbon or check the View tab rather than searching for a worksheet formula or formatting option.

Excel for Mac has Freeze Panes controls on the View tab as well, and the same selection rule applies: the active cell determines which rows above and columns to the left are held. Menu wording or ribbon placement can vary by release, so look under View for Freeze Panes and Unfreeze Panes. These steps do not depend on a Windows-only keyboard shortcut, so no shortcut translation is needed.

If a workbook looks different across desktop and web versions, check that you are on the same worksheet and that the window is scrolled to a comparable position. Freeze Panes is a worksheet view feature; a different active sheet or an existing split can make it appear that the setting did not carry over.

When to use another approach

Freeze Panes is best when you need headers or labels visible while navigating a worksheet. It is not designed to keep arbitrary cells pinned, keep the same headings visible on printed pages, or make a static copy of a section. Choose another feature if your goal is different:

For repeated headings on printed pages, use Page Layout > Print Titles.
For independent scrolling regions used to compare distant worksheet areas, use View > Split.
For a long table that is difficult to navigate, consider filters, sorting, or Excel table features alongside frozen headers.

These tools solve separate problems. For example, freezing row 1 keeps the column labels visible while scrolling onscreen, while Print Titles repeats the selected heading row on each printed page. Setting one does not automatically set the other.

Frequently Asked Questions

Why does Excel freeze the wrong rows or columns?
Freeze Panes uses the active cell as the boundary. It freezes rows above that cell and columns to its left. Unfreeze the current panes, select the correct boundary cell, and apply Freeze Panes again.

How do I freeze the top row and first column at the same time?
Select cell B2, then choose View > Freeze Panes > Freeze Panes. The first row and first column are above and to the left of B2, respectively, so both remain visible while you scroll.

Why can I not freeze panes in the middle of a worksheet?
Excel can freeze only rows from the top and columns from the left. It cannot anchor a middle section while allowing the areas above or to the left to scroll independently. Use Split if independent scrolling is what you need.

Does Freeze Panes affect printing?
No. It controls what stays visible while scrolling on screen. To repeat headings on printed pages, go to Page Layout > Print Titles and choose the rows or columns to repeat.

Why is Unfreeze Panes showing instead of Freeze Panes?
That indicates a freeze setting is already active on the current worksheet. Choose Unfreeze Panes first, then select a new boundary cell and apply the desired freeze arrangement.

Can I freeze panes on every worksheet at once?
Freeze Panes is set per worksheet. Apply the setting separately to each sheet that needs it, and verify the boundary on each tab because different sheets may have different header layouts.

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.