How to Freeze One Column in Excel While You Scroll

To keep Excel’s first column visible while you scroll sideways, choose View > Freeze Panes > Freeze First Column. If you want a different column to stay visible, select the cell immediately to its right in row 1, then choose View > Freeze Panes > Freeze Panes—but Excel will also freeze every column to the left of your selection. Excel cannot freeze an isolated middle column while earlier columns scroll independently.

Freezing a column is useful when a worksheet has many fields and you need to keep labels such as names, product IDs, or dates in view as you move horizontally. It changes how the sheet is displayed, not the data itself, and you can undo it at any time.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows. The instructions also apply to recent desktop versions of Excel; the Mac and web differences are noted below.
A worksheet with at least one column you want to keep visible. Save the workbook if you want to preserve the view for later; freezing panes does not require a special file format.
If you want a column other than A to be the only visible frozen column, be prepared to rearrange or hide columns. Excel freezes a continuous block from the left edge, not a single separated column.

Step-by-Step

Open the worksheet and identify the column. Click the sheet tab that contains your data, then decide which column should remain on screen while you scroll horizontally. For example, column A might contain customer names while columns B through Z contain monthly figures. If you only need the first column, use the built-in Freeze First Column command. If you mean a later column, note that Excel’s Freeze Panes command will also include columns before it.
Leave cell-editing mode. If you are typing in a cell, press Enter or Esc before using the ribbon. Freeze commands can be unavailable or behave unexpectedly while the insertion cursor is active inside a cell. You do not need to select the column or highlight its cells first.
Freeze column A with the one-click option. On the ribbon, open the View tab, choose Freeze Panes in the Window group, and select Freeze First Column. Column A should now remain in place when you move the horizontal scrollbar to the right. You can still scroll up and down through the rows; this command does not freeze the top row.
Check that the freeze is working. Use the horizontal scrollbar at the bottom of the worksheet, or hold Shift while using the mouse wheel if your mouse and Excel settings support horizontal scrolling. Move several columns to the right. Column A should stay visible while the other columns move. This is a display change only: it does not move, lock, or protect any cells from editing.
Freeze panes at a specific position when needed. If your chosen column is not A, click the cell in row 1 immediately to its right. For example, to keep column C and all columns before it visible, select D1. Then choose View > Freeze Panes > Freeze Panes. Excel freezes columns A through C. Selecting a cell in row 1 is important: if you select a cell lower down, Excel also freezes the rows above that cell.
Understand the limit for a middle column. Suppose column B contains the label you want to keep visible, but column A should scroll away. Selecting C1 and choosing Freeze Panes will freeze both A and B, not B alone. Excel does not offer a command to freeze B by itself while A scrolls independently. If you need B to be the only visible anchored column, consider moving or copying that field into column A, or hiding column A before freezing at C1. Hiding A keeps it out of sight, but Excel still treats it as part of the frozen block.
Remove the freeze if you want to change it. Return to View > Freeze Panes and select Unfreeze Panes. Then make a new selection and apply the appropriate freeze command. Excel normally allows one frozen-pane arrangement per worksheet, so unfreeze the existing arrangement before setting a different one.

On Mac: Use the View tab and its Freeze Panes menu; the command names are generally the same, though their placement can vary with the ribbon layout. In Excel for the web: Open View and use Freeze Panes there. If the browser version does not show the option you need, open the workbook in the desktop app and apply the freeze there.

Common Mistakes

Choosing Freeze Panes when Freeze First Column was intended. Freeze Panes uses the active cell as a boundary. If a cell is selected in column B or farther right, Excel may freeze more columns than expected. For column A, use the explicit Freeze First Column command.
Selecting the target column instead of the next column. To freeze through column C, select D1 before choosing Freeze Panes. Selecting C1 freezes only the columns to the left of C, which means A and B; it does not freeze C itself.
Selecting a cell below row 1. Excel freezes all rows above the selected cell as well as the columns to its left. If you only want to freeze columns, choose a cell in row 1, such as D1. Otherwise, you may unintentionally keep a header row or several rows fixed at the top.
Expecting to freeze an isolated column. Freeze Panes always locks a continuous area beginning at the top and left edges of the worksheet. It cannot leave column A scrolling while independently pinning column B. Rearrange or hide preceding columns if the visual result is essential.
Assuming the column is protected from edits. Freezing affects the on-screen view only. To restrict changes, use worksheet protection separately; freezing panes does not prevent someone from typing over a value.
Looking for a visible line in the wrong place. Excel usually marks the boundary of a frozen area with a subtle line. The line can be hard to see with certain themes or zoom levels, so test by scrolling instead of relying on the divider alone.

Tips

Freeze only what readers need for context. A single identifier column is often easier to work with than several frozen columns. A wide frozen block reduces the space available for the rest of the worksheet, especially on a smaller display.
Use a clear leftmost identifier when designing a sheet. If you know readers will scroll across many fields, place the most useful reference—such as a name, item number, or date—in column A. Then Freeze First Column will do exactly what most people expect without requiring rearrangement.
Keep the header row separate from the column freeze. Freeze First Column does not keep row 1 visible as you scroll vertically. If you need both the first column and the top row to remain visible, select B2 and choose View > Freeze Panes > Freeze Panes. That selection freezes row 1 and column A. It is a combined freeze, not a way to freeze only one column.
Plan the selection using the boundary rule. With Freeze Panes, Excel freezes rows above and columns to the left of the active cell. A selection at D1 means columns A through C; a selection at D5 means columns A through C and rows 1 through 4. Remembering this rule makes it easier to predict the result before clicking.
Save after arranging a useful view. The freeze setting is part of the worksheet view and is commonly retained when you save the workbook. If other people use the file, tell them which column is frozen, especially if the frozen area includes hidden columns.
Use the scrollbar to test, not just arrow keys. Moving the active cell with arrow keys is not always the same as scrolling the worksheet view. Drag the horizontal scrollbar far enough to confirm that the intended column stays in place and that the remaining columns are still accessible.

Troubleshooting

The wrong columns are frozen: Choose View > Freeze Panes > Unfreeze Panes, then reapply the command. For Freeze Panes, select the first cell that should remain scrollable: to freeze through C only, select D1. To freeze column A alone, use Freeze First Column instead of choosing a cell by guesswork.

The top rows are frozen too: The active cell was probably below row 1 when Freeze Panes was applied. Unfreeze, select the correct boundary cell in row 1, and apply Freeze Panes again. For example, D1 freezes columns A through C without freezing any rows.

The column seems not to stay in place: Confirm that you are scrolling horizontally, not simply moving the selection. Try dragging the horizontal scrollbar at the bottom of the window. If the sheet has no horizontal overflow, move the view to the right using the scrollbar or temporarily widen the window less so you can test the effect.

Freeze Panes is greyed out: First finish editing the cell by pressing Enter or Esc. If the command is still unavailable, check whether you are in a special view or whether the workbook is opened in a restricted or read-only state. Try switching to View > Normal, if another view is active, or open the workbook in desktop Excel if you are using a browser version with limited controls.

You cannot freeze only column B: This is a limitation of the feature, not a problem with your workbook. Excel freezes a block from column A through the selected boundary. Move the desired field to column A, or hide column A and freeze at C1 if keeping B visible is more important than keeping A accessible. Remember that unhidden A will also be part of the frozen block.

The freeze disappears after reopening: Check that you saved the workbook after applying it, and confirm that you are opening the same worksheet and file. If you use multiple worksheet tabs, each sheet can have its own freeze setting, so apply the command on the sheet where you need it.

Frequently Asked Questions

Can I freeze just the first column in Excel?
Yes. Choose View > Freeze Panes > Freeze First Column. Column A stays visible while you scroll horizontally.

How do I freeze column B only?
Excel cannot freeze B alone while A scrolls. Selecting C1 and choosing Freeze Panes freezes both A and B. To make B the only visible anchored column, move its contents to A or hide A before freezing.

Can I freeze one column and the top row at the same time?
Yes. To freeze column A and row 1, select B2 and choose View > Freeze Panes > Freeze Panes. The command freezes the rows above and columns to the left of the selected cell.

Does freezing a column lock it against editing?
No. It only keeps the column in view as you scroll. Use worksheet protection if you need to prevent edits, and configure the protection separately.

How do I unfreeze a column?
Choose View > Freeze Panes > Unfreeze Panes. You can then apply a different freeze arrangement if needed.

Will freezing a column change my data or printout?
No. Freezing changes the on-screen worksheet view, not cell contents or print layout. Adjust print settings separately if you want a column to repeat on printed pages.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.