Excel Freeze First Column Not Working? Causes and Fixes

If Excel’s first column will not stay visible while you scroll, choose View > Freeze Panes > Freeze First Column on Windows. If that command is unavailable or the wrong area stays fixed, first choose View > Freeze Panes > Unfreeze Panes, then apply Freeze First Column again; also check that column A is not hidden.

What Freeze First Column is supposed to do

Freeze First Column keeps worksheet column A visible as you scroll horizontally to the right. It is useful when column A contains names, dates, product IDs, or another label that helps identify the values in later columns. It does not lock the cells against editing, prevent changes to the worksheet, or keep every column in view. It changes how the sheet is displayed in the current window.

The command is designed specifically for the first worksheet column. It does not mean “freeze whichever column is selected.” If you need columns A and B to remain visible, use Freeze Panes instead, selecting a cell immediately to the right of the columns you want to keep. That distinction explains many cases where a user clicks a cell in column B, chooses Freeze First Column, and expects both A and B to stay put.

Freezing is also different from hiding a column, splitting a window, or protecting a sheet. A frozen column remains part of the worksheet and can still be edited if the sheet allows editing. The feature simply keeps the chosen area visible while the rest of the sheet scrolls.

Reset the existing pane before trying again

Excel allows only one freeze-pane arrangement per worksheet window at a time. If panes are already frozen, applying another arrangement may not produce the result you expect. Start by removing the current freeze, then choose the desired option:

Open the worksheet where the problem occurs.
On the ribbon, select View > Freeze Panes > Unfreeze Panes.
Return to View > Freeze Panes and select Freeze First Column.
Scroll horizontally to confirm that column A remains visible.

If Unfreeze Panes is unavailable or appears inactive, there may not be a frozen pane in that window. If the menu instead offers Unfreeze Panes, a freeze is active. Excel’s labels and menu layout can vary slightly by platform, but the commands are in the View tab in Microsoft 365 for Windows.

After unfreezing, check the sheet again before applying a new layout. An existing freeze may have been created to keep several columns or a header row visible. Removing it clears that arrangement, so you may need to recreate the intended combination rather than simply choose Freeze First Column.

Check whether column A is hidden or off-screen

A frozen column can be difficult to recognize if it is hidden, extremely narrow, or obscured by the worksheet layout. If column A is hidden, freezing it does not make its contents appear. Look at the column headers: if the visible sequence begins with B, column A may be hidden. You can select the neighboring columns, right-click a selected column header, and choose Unhide. If the column is merely narrow, drag the boundary next to its header to widen it.

Also make sure you are scrolling the worksheet horizontally rather than looking at a different sheet or workbook window. The horizontal scrollbar is at the bottom of the Excel window. When Freeze First Column is active, dragging that scrollbar to the right should move the other columns while A stays visible. If the scrollbar is missing, Excel may be showing a different window layout or the worksheet may be positioned so that a different part of the sheet is in view.

Another useful check is the worksheet’s direction and layout. In a normal left-to-right sheet, column A is the first column at the left edge. If the sheet is displayed right-to-left, the visual position of columns can be different, so identify column A by its header rather than assuming the leftmost visible edge represents it. The freeze command refers to the worksheet’s first column, not to an arbitrary column that happens to be on screen.

Use Freeze Panes for more than one column

Choose Freeze Panes when you need to keep a custom set of rows and columns visible. The rule is based on the selected cell: Excel freezes the rows above that cell and the columns to its left. For example, to keep columns A and B visible without freezing any rows, select a cell in column C on row 1, such as C1, and choose View > Freeze Panes > Freeze Panes.

To freeze both the first column and the top row, select B2 and choose Freeze Panes. Excel keeps the row above the selection (row 1) and the column to its left (column A). For the top row plus columns A and B, select C2. These examples apply to the general Freeze Panes command; selecting a cell is not necessary when choosing the dedicated Freeze First Column command.

Keep only column A: choose Freeze First Column.
Keep columns A and B: select C1, then choose Freeze Panes.
Keep row 1 and column A: select B2, then choose Freeze Panes.
Keep row 1 and columns A and B: select C2, then choose Freeze Panes.

If the wrong rows or columns remain fixed, unfreeze the panes and select the correct cell before using Freeze Panes again. The selected cell itself is not frozen; the rows above it and columns to its left are.

Tell frozen panes apart from a split window

A split window can look similar because it divides a worksheet into areas that can scroll independently. A split is not the same as a frozen pane: it creates separate scrolling regions, while a freeze keeps designated rows or columns fixed as the rest of the sheet moves. If the worksheet has a line dividing it into independently movable sections, check View > Split and turn off the split if it is not wanted. Then set the freeze arrangement you need.

Do not judge the feature only by a line on the screen. Freeze panes can be indicated by a boundary near the frozen area, but the most reliable test is to scroll horizontally and see whether column A stays in place. If the wrong area moves, unfreeze and apply the correct command rather than dragging a divider and assuming it is a freeze boundary.

Check workbook windows and platform differences

Excel can display the same workbook in more than one window. Each window can have its own view arrangement, so freezing column A in one window does not guarantee that another open window displays the same freeze. If the workbook is open in multiple windows, activate the one that has the problem and set the freeze there. You can close an extra window if you do not need it, taking care not to close unsaved work.

In Excel for Microsoft 365 on Windows, use View > Freeze Panes and select the relevant command. In Excel for Mac, the freeze options are also on the View tab under Freeze Panes; choose Freeze First Column or unfreeze before applying a different layout. Ribbon organization can differ by Mac release, so use the View tab’s freeze control if the menu is arranged differently.

In Excel for the web, open the workbook in the browser and look under View > Freeze Panes. The browser version supports freezing panes, though the ribbon may present the controls differently from the desktop app. If a command is missing in a particular workbook or browser session, opening the file in the desktop app is a practical way to inspect the full ribbon and reset its view. Avoid editing separate copies inadvertently: confirm which workbook is open before making changes.

Why the setting may seem to disappear

Freeze panes affect the view, not the underlying cell data. The arrangement is generally saved with the workbook view, but it can appear different if you open another worksheet, another window, or a separate copy of the file. A colleague may also have changed the view after the file was saved. Reapply the freeze in the specific sheet and window where you need it, then save the workbook if you want that view retained for later.

Zoom level, window size, and a very wide first column can also make the result less obvious. For instance, if column A takes up most of a small Excel window, only a narrow strip of the remaining columns may be visible. Reduce the column width or adjust the zoom to make the scrolling behavior easier to see. Changing zoom does not turn freezing on or off; it only changes how much of the worksheet fits on screen.

Finally, confirm that you are not confusing a worksheet-level view with a locked or protected workbook. Freeze First Column does not remove sheet protection or unlock cells. If the issue is that you cannot edit a value, investigate protection and permissions separately; freezing is not an editing control.

Frequently Asked Questions

Why is Freeze First Column greyed out?

First check whether you are in a worksheet window where the command is available and whether the workbook is open in a mode that permits the action. If panes are already frozen, choose Unfreeze Panes and try again. If the command remains unavailable in Excel for the web, open the workbook in the desktop app and check the View tab there.

Can I freeze the first two columns?

Yes. Unfreeze any existing panes, select C1, then choose View > Freeze Panes > Freeze Panes. Excel freezes the columns to the left of the selected cell, so columns A and B remain visible as you scroll sideways.

How do I freeze the first column and top row together?

Choose View > Freeze Panes > Unfreeze Panes if needed, select B2, and then choose View > Freeze Panes > Freeze Panes. The row above B2 and the column to its left stay visible: row 1 and column A.

Does Freeze First Column keep column A visible when I scroll down?

It keeps column A visible during horizontal scrolling. It does not freeze a row. Scrolling down should move the worksheet rows normally; to keep a header row visible as well, use Freeze Panes with an appropriate selection, such as B2 for row 1 and column A.

Why does column A still not show?

Check whether column A is hidden or too narrow, and confirm that you are on the intended worksheet and workbook window. A freeze cannot display a hidden column’s contents. Unhide or widen A, then test by moving the horizontal scrollbar to the right.

A quick way to verify the repair

After applying the setting, use the horizontal scrollbar or Shift plus the mouse wheel if your setup scrolls horizontally that way. Column A should remain in view while columns farther to the right move. Then scroll vertically: the rows should continue to move unless you separately froze a row. If the behavior is still wrong, unfreeze panes, check for a hidden column or split, and repeat the steps in the active workbook 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.