Excel Freeze Columns Not Working? Fix the View

If Excel freeze columns are not working, select the cell immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C1 to freeze columns A and B; if you want row 1 frozen too, select C2 instead. If the result is still wrong, unfreeze the current panes and check the active cell, worksheet view, and any split or hidden columns.

Quick checks before changing the sheet

Start by confirming that you are on the worksheet where the problem occurs. Freeze Panes applies to the active worksheet, not every sheet in a workbook. Click a single cell in the grid, rather than a chart, shape, or sheet tab, and make sure Excel is not in the middle of editing a cell. Press Enter or Esc to leave edit mode before opening the View tab.

Then check which command you used. Freeze Top Row keeps row 1 visible, and Freeze First Column keeps column A visible. Neither command freezes a different row or a group of columns. For a custom layout, use the main Freeze Panes command after selecting the appropriate cell. If there is already a frozen arrangement, choose View > Freeze Panes > Unfreeze Panes before setting it again; otherwise, you may be interpreting the existing boundary as a failed new setting.

How Freeze Panes decides what stays visible

Excel freezes the rows above and the columns to the left of the active cell. It does not freeze the cell you select. The boundary is set by that cell’s position, which is why selecting the wrong one is the most common cause of an unexpected result.

To freeze only column A, choose View > Freeze Panes > Freeze First Column.
To freeze columns A and B, select C1 and choose View > Freeze Panes > Freeze Panes.
To freeze row 1 and columns A and B, select C2 and choose Freeze Panes.
To freeze rows 1 and 2 plus columns A through C, select D3 and choose Freeze Panes.

Excel freezes a continuous block starting at the top and left of the worksheet. Selecting D1 freezes A through C; it cannot freeze just column C while leaving A and B scrollable. Likewise, Freeze First Column means column A, not the first column of a table that happens to start farther across the sheet.

Set the columns again in the right order

Use this reset-and-reapply sequence when the visible divider is in the wrong place or the command seems to do nothing:

Open the affected worksheet and switch to View > Normal if the sheet is in another view.
Choose View > Freeze Panes > Unfreeze Panes. If the menu offers Unfreeze Panes, a freeze is currently active.
Click one cell at the intersection just below the rows and just to the right of the columns you want fixed. For columns only, keep the selected cell in row 1.
Choose View > Freeze Panes > Freeze Panes. Do not choose Freeze First Column unless column A alone is what you need.
Scroll down or right to verify the result. A horizontal line marks frozen rows, and a vertical line marks frozen columns.

For instance, a staff list might have employee IDs in A, names in B, and changing monthly figures from C onward. Select C1 before freezing to keep both identifiers in view while moving across months. If the headings are in row 1 as well, select C2 so both the headings and the two identifier columns remain visible.

Why the Freeze Panes command may be unavailable

If Freeze Panes is dimmed or unavailable, first exit cell-edit mode and click an ordinary worksheet cell. Some commands are unavailable while Excel is editing a formula or text inside a cell. Also check the current view: switch to View > Normal, then look again. The Normal view is the appropriate place to configure a standard scrolling freeze.

A second possibility is that the worksheet is split rather than frozen. Split divides the window into independently scrolling areas, which can look similar to frozen panes but behaves differently. If you see separate pane scroll bars or a movable split boundary, go to View > Split to turn the split off, then apply Freeze Panes. If an old freeze remains, use Unfreeze Panes first. Avoid trying to combine the two arrangements; establish the one you want after clearing the other.

If you are working in a workbook opened from a shared location, remember that another person’s edits or a different open window can make it seem as though your change disappeared. Confirm the workbook name and active sheet, and save your change. If the workbook has multiple windows open, check each window’s view rather than assuming that a setting seen in one is visible identically in another.

Hidden columns, wide columns, and misleading boundaries

Hidden columns can make the freeze boundary confusing. For example, if B is hidden and you freeze through C, Excel is still freezing the columns to the left of the selected cell; the hidden column does not become visible merely because panes are frozen. If you are unsure where the boundary will land, unhide the relevant columns temporarily, set the freeze using a visible cell, and then hide columns again if needed. To unhide, select the column headers on both sides of the hidden range, right-click, and choose Unhide.

Frozen columns can also consume most of the available worksheet width. If A and B are unusually wide, the remaining scrollable area may be so narrow that it looks as if Excel cannot move horizontally. Reduce the width of the frozen columns, zoom out, or freeze fewer columns. Freeze Panes does not resize columns; it only keeps the chosen region stationary while the rest of the sheet scrolls.

Finally, distinguish a frozen pane from a selected cell or a table header. A colored header row, bold formatting, or Excel table styling does not keep anything on screen during scrolling. Conversely, a freeze can work even if the boundary line is subtle at the current zoom. Test by scrolling far enough to move past the first few rows or columns.

Excel for the web and Mac differences

In Excel for Microsoft 365 on Windows, the usual path is View > Freeze Panes. Excel for the web also provides Freeze Panes from the View tab, though the exact menu presentation can vary as the web interface changes. Use the same selection rule: choose the cell below and to the right of the area to keep visible, then apply the freeze. If you cannot find the option in the browser, check that you are editing the workbook in Excel rather than viewing a read-only preview.

Excel for Microsoft 365 on Mac also offers Freeze Panes on the View tab. The wording and placement can differ slightly by version, but the row-and-column selection logic is the same. These steps do not depend on a Windows-only keyboard shortcut, so there is no shortcut translation required. If a workbook behaves differently between Mac, Windows, and the browser, verify the active sheet and freeze boundary on each version; do not assume that a frozen view on one sheet automatically applies to all sheets.

Freeze Panes versus other ways to keep headings visible

Freeze Panes is designed for keeping worksheet rows or columns in place as you scroll. It is useful for wide reports, rosters, inventory lists, and schedules where identifiers at the left need to remain visible. It does not lock cells against editing, prevent columns from being resized, or keep a particular noncontiguous set of columns on screen.

If you only need a heading row to remain visible, Freeze Top Row is quicker. If you need to compare distant sections of the same worksheet at once, View > Split may be more suitable because each pane can scroll independently. For a printed report, repeating headings on each printed page is a separate page-layout task; freezing panes changes the on-screen view and does not by itself repeat headings on paper. Choosing the tool that matches the task prevents a common misunderstanding: a display setting is not a data-protection or print-layout setting.

Frequently Asked Questions

Why does Excel freeze the wrong column? The active cell was probably not one column to the right of the intended frozen area. Unfreeze panes, select the correct cell in row 1, and apply Freeze Panes again. To freeze A and B, select C1.

How do I freeze the first two columns in Excel? Click C1, then choose View > Freeze Panes > Freeze Panes. For the first two columns plus the top row, click C2 before choosing Freeze Panes.

Can I freeze a column other than column A? Yes, but Excel freezes all columns from A through the column immediately before the selected cell. You cannot freeze a later column by itself while earlier columns remain scrollable.

How do I remove frozen columns? On the affected sheet, choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen rows and columns; it does not delete worksheet data. You can then select a new cell and set a different freeze.

Why does Freeze Panes look like it is not working when I scroll? Check that you are scrolling far enough to pass the frozen boundary, and confirm the frozen columns are not so wide that little scrollable space remains. Also verify that you applied the setting on the worksheet you are viewing, rather than on another sheet or window.

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.