Excel Freeze Panes Not Working on Selection? Fix It

If Excel Freeze Panes is not working on your selection, first select 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 B3 to freeze rows 1–2 and column A; if panes are already frozen, choose Unfreeze Panes first and apply the setting again.

What Freeze Panes Does—and What the Selection Means

Freeze Panes keeps specified rows at the top of the worksheet and specified columns at the left while you scroll through the rest. The selected cell acts as a boundary marker: Excel freezes everything above it and everything to its left. It does not pin the selected cell itself, and it does not let you choose separate, nonadjacent rows or columns.

That boundary rule explains many apparent failures. If you select D5, Excel freezes rows 1 through 4 and columns A through C. If you wanted only the header row and the first column to stay visible, D5 is the wrong selection: it would also freeze rows 2 through 4 and columns B and C. Select B2 instead, because the desired frozen area is above and to the left of that cell.

Freeze Panes affects the current worksheet view, not the workbook’s data. It does not insert rows, change cell values, or repeat headings when printing. It is intended to make labels remain visible as you navigate a large grid.

Apply Freeze Panes with the Correct Cell Selected

In Excel for Microsoft 365 on Windows, use this sequence:

Open the worksheet and select the cell directly below the rows and immediately to the right of the columns you want to keep visible.
Go to View > Freeze Panes.
Choose Freeze Panes from the menu. Do not choose Freeze Top Row or Freeze First Column unless one of those preset options matches your goal.
Scroll down or right to check that the intended headings and labels remain in place.

For a worksheet with one header row, select A2 and choose Freeze Panes, or choose Freeze Top Row from the same menu. To keep columns A and B visible but no rows, select C1 and choose Freeze Panes. To keep the top two rows and first column visible, select B3. These examples follow the same above-and-left rule.

If the result is not right, choose View > Freeze Panes > Unfreeze Panes. Then select the correct boundary cell and apply Freeze Panes again. Excel does not provide a dialog for adjusting an existing boundary by dragging; replacing the setting is usually the simplest correction.

Check the Frozen Boundary and Scroll Position

After freezing, look for a thin line separating the fixed region from the scrollable area. A horizontal line indicates the boundary below frozen rows; a vertical line indicates the boundary to the right of frozen columns. The line may be subtle, especially at high zoom or against worksheet gridlines, so test by scrolling rather than relying on appearance alone.

Excel can appear not to respond if the worksheet is already positioned at its top or left edge. For example, freezing the first row is not visually obvious until you scroll down. Use the mouse wheel, the vertical or horizontal scroll bar, or the keyboard navigation keys to move into the sheet and confirm that the frozen region stays in view.

Also check which worksheet is active. Freeze Panes is a view setting for an individual sheet. Switching to another tab may show a different scroll position or freeze configuration, which can make it seem as though the command did not apply to the workbook as a whole.

Common Reasons the Command Seems Not to Work

Before changing workbook settings, rule out these common causes:

An existing freeze is still active: Unfreeze Panes, then set the new boundary. Applying a new selection without clearing the old arrangement can leave you judging the wrong configuration.
The selection was one row or column off: The active cell’s position defines what gets frozen. Selecting A1 freezes nothing above or to the left, while selecting C4 freezes more than just a title row.
A preset was chosen instead: Freeze Top Row and Freeze First Column each apply a specific single-row or single-column behavior. They do not use the selected cell as a custom boundary.
You are editing a cell: If the insertion point is inside a cell or the formula bar, press Enter or Esc to finish editing, select a worksheet cell, and try again.
The worksheet is not being scrolled far enough: The frozen region’s behavior becomes apparent only when you scroll beyond its boundary.

Another feature that can cause confusion is Split. A split divides the worksheet window into independently scrollable panes; Freeze Panes keeps selected top rows or left columns stationary while the remaining area scrolls. If the screen shows several scrollable sections or unexpected divider bars, inspect View for Split and turn it off if you do not need that arrangement. Then set Freeze Panes again.

Choose a Boundary That Fits the Worksheet

Plan the frozen area around how people read the sheet. A sales list might have a header in row 1 and customer names in column A. Selecting B2 keeps both visible while the user reviews distant rows or columns. A report with two title or header rows might need B3 instead, provided those first two rows genuinely contain information worth keeping onscreen.

Freeze only what helps orient the reader. If you freeze many rows or columns, the scrolling area becomes small, particularly on a laptop display. For a wide worksheet, freezing the identifier column can be more useful than freezing several descriptive columns. For a long table, preserving a concise header row often matters more than keeping a large title block fixed.

Hidden rows or columns can make the visible boundary harder to interpret. If the freeze appears to include an unexpected range, unhide the relevant rows or columns temporarily and inspect the layout. Also remember that freezing does not make a heading repeat on printed pages; for print output, use the repeating rows and columns options in Page Setup instead.

Excel for Mac and Excel for the Web

In Excel for Mac, the same principle applies: select the boundary cell, then use View > Freeze Panes > Freeze Panes. Menu placement and wording can vary slightly with the Excel version, but the selection still determines which rows above and columns to the left stay fixed. To replace an existing setting, use the Unfreeze Panes command in the View menu first.

Excel for the web also includes Freeze Panes under the View tab. Select the worksheet cell that marks the boundary, then use the Freeze Panes command. If a command is missing or unavailable, check whether the workbook is still loading, whether you are editing a cell, and whether the ribbon is collapsed; expanding the ribbon can reveal controls that are otherwise hidden. Features and layout can change over time, so desktop and web menus may not look identical.

There is no need to switch to a different Excel version just because the selected cell seemed ignored. First verify the boundary rule and clear any existing freeze. Those two checks solve most selection-related misunderstandings.

Freeze Panes Compared with Other Ways to Keep Headings Visible

Freeze Panes is best for navigating a sheet on screen. It does not alter the data and can keep both top rows and left columns visible at once. The two preset commands are quicker when the requirement is only the top row or first column; the custom Freeze Panes option is needed for a combination or a larger region.

If the goal is to repeat column headings on every printed page, use Print Titles rather than Freeze Panes. In Excel for Windows, the relevant controls are on Page Layout > Print Titles. If the goal is to see different parts of the same worksheet at once, Split may be a better fit, although its independently moving sections behave differently from frozen headings. If a file is intended for readers who may not use Excel, a clearly formatted report or exported PDF may be more reliable than relying on a particular viewing arrangement.

Frequently Asked Questions

Why does Excel freeze more rows or columns than I selected?
The active cell marks the lower-right edge of the frozen area. Excel freezes every row above it and every column to its left. To freeze fewer, unfreeze the current panes and select a cell closer to the top-left corner.

How do I freeze the top row and first column together?
Select B2, then choose View > Freeze Panes > Freeze Panes. The top row is above B2 and the first column is to its left, so both stay visible as you scroll.

How do I remove Freeze Panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the frozen boundary for the current worksheet; it does not delete or move worksheet content.

Can I freeze a row in the middle of a worksheet?
Freeze Panes keeps a continuous block of rows starting at row 1 and a continuous block of columns starting at column A. It cannot pin a middle row while allowing the rows above it to scroll independently. Use Split or reorganize the sheet if that behavior is essential.

Does Freeze Panes make headings repeat when I print?
No. It changes the on-screen view only. To repeat headings on printed pages, configure Print Titles on the Page Layout tab and check the print preview.

A Quick Diagnostic Checklist

If the setting still appears wrong, use this short reset: choose Unfreeze Panes; decide exactly which top rows and left columns must remain visible; select the cell one row below and one column to the right of those areas; choose Freeze Panes; then scroll down and sideways to test it. For example, to keep rows 1–3 and columns A–B fixed, select C4. If that test works, the earlier issue was the selected boundary or an existing pane setting rather than a problem with 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.