Freeze an Entire Column in Excel: A Step-by-Step Guide

To keep a column visible while you scroll across a worksheet in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze First Column to pin column A. To keep a different column visible, select the cell immediately to its right in row 1, then choose View > Freeze Panes > Freeze Panes. Excel freezes all columns to the left of your selection, so it cannot pin a middle column by itself while earlier columns scroll away.

Freezing a column does not change the worksheet’s data or prevent you from editing it. It keeps the column in view as you scroll horizontally, which is useful when a wide sheet has names, IDs, dates, or other labels at the left. You can also freeze a row at the same time if you choose a cell below row 1 as well as to the right of the columns you want to keep visible.

What You’ll Need

An Excel workbook with the worksheet you want to work on.
A clear idea of which columns should remain visible. Excel freezes a continuous block beginning with column A, not a standalone column from the middle of the sheet.
Access to the View tab or menu. The steps below are for Excel for Microsoft 365 on Windows; Mac and web notes appear below.

Step-by-Step

Open the correct worksheet. Open the workbook and click the sheet tab where you want the column to stay visible. Freeze settings apply to the active worksheet, not automatically to every sheet in the workbook. If you need the same view on other sheets, you will need to set it on each one.
Decide whether you need column A or a wider frozen block. If the label column is the first column, use the built-in Freeze First Column command. If the column you care about is farther to the right, decide whether keeping all columns before it visible is acceptable. For instance, keeping column D visible through the regular Freeze Panes command also keeps A, B, and C frozen.
Clear any existing freeze before changing the setup. On the ribbon, choose View > Freeze Panes > Unfreeze Panes if that option is available. A worksheet can have only one freeze-pane arrangement at a time. Starting from an unfrozen sheet helps avoid mistaking an old frozen area for the new one. If you do not see Unfreeze Panes, the sheet may not currently have panes frozen.
Freeze column A using the direct command. Choose View > Freeze Panes > Freeze First Column. Excel pins the first column so it remains visible as you move horizontally across the worksheet. You can still scroll up and down; freezing the column does not pin its rows vertically. The command applies to the active worksheet only.
Freeze a different column by selecting the cell to its right. First make sure the worksheet is unfrozen. If you want columns A and B to stay visible, select C1. If you want columns A through D to stay visible, select E1. In each case, use row 1 so Excel freezes columns to the left of the selection without also freezing worksheet rows.
Apply the custom freeze. With the appropriate cell selected, choose View > Freeze Panes > Freeze Panes. Do not choose Freeze First Column for this custom setup: that command always pins only column A. If you selected E1, for example, Excel freezes A through D, not just D.
Check the result by scrolling horizontally. Use the horizontal scrollbar at the bottom of the Excel window, or a trackpad or mouse scroll gesture, to move to columns farther right. The frozen column or block should remain at the left of the worksheet while the other columns move. Scroll back to the left and confirm the intended columns are still visible.
Adjust the arrangement if it is not what you wanted. Choose View > Freeze Panes > Unfreeze Panes, select a new cell, and apply Freeze Panes again. For the first-column-only setup, use Freeze First Column after unfreezing. Repeating this process is safe; it changes the view arrangement, not the worksheet contents.

Example: Suppose column A contains employee names, B contains departments, and C onward contains monthly figures. To keep names and departments visible, select C1 and choose Freeze Panes. If you want only the names column to remain visible, select Freeze First Column instead. Excel cannot keep B alone fixed while A scrolls away; the frozen area always starts at the left edge.

Common Mistakes

Selecting the column you want instead of the cell after it. For a custom freeze, Excel uses the selected cell as a boundary. Selecting D1 freezes A through C, not D alone. Select E1 if you want A through D to remain visible.
Expecting a middle column to freeze independently. Freeze Panes creates a fixed block from column A to the selected boundary. It does not offer a setting to lock, for example, column D while columns A through C continue scrolling.
Using the first-column command for a custom setup. Freeze First Column always pins A. Use the regular Freeze Panes command with a cell selected to the right of the desired block when you need more than column A.
Choosing a cell below row 1 by accident. Freeze Panes also locks rows above the selected cell. Selecting C2 freezes row 1 as well as columns A and B. If you only want columns frozen, choose a cell in row 1.
Forgetting an existing freeze. A previous frozen area can make the new result seem wrong or make commands behave unexpectedly. Unfreeze the current panes before applying a different arrangement.
Confusing freezing with hiding or protecting. Frozen columns remain part of the worksheet and can be edited. Hiding a column removes it from view, while sheet protection controls editing. Those features do not substitute for Freeze Panes.

Tips

Freeze only what you need. A large frozen block leaves less room for the scrollable part of the sheet. If a single ID column is enough to identify records, pinning several extra columns may make the worksheet harder to read.
Use a descriptive leftmost column when possible. Since the frozen area starts at column A, put the most useful identifier there when planning a new worksheet. This makes the simple Freeze First Column option a good fit.
Combine frozen columns and rows when useful. Select a cell below and to the right of the areas to keep fixed. For example, select C2 to freeze row 1 and columns A and B together. The top-left portion remains fixed while you scroll through the rest of the sheet.
Keep the selected cell in mind. Freeze Panes is based on the active cell, not just the column heading that happens to be highlighted. When unsure, click the target boundary cell and check its address in the Name Box before applying the command.
Save the workbook after arranging the view. Freeze settings are associated with the worksheet view and are generally retained when the workbook is saved. If a colleague sees a different view, have them check the active sheet and freeze settings in their own Excel session.
Use the same basic logic on other platforms. In Excel for Mac, use the View tab and its Freeze Panes controls; the names of commands are similar, though their location can differ with the ribbon layout. In Excel for the web, use the View tab and Freeze Panes options. If the exact option is not visible, check the full View menu or ribbon rather than assuming the workbook cannot freeze columns.

Troubleshooting

The Freeze Panes option is unavailable or dimmed. Make sure you are in the worksheet grid rather than editing text inside a cell or a chart. Press Enter or Esc to finish editing, click a worksheet cell, then open the View tab again. If the workbook is in a restricted or unusual view, switch to Normal view and try again. Also check whether the worksheet is protected or opened with limited editing permissions; those conditions can restrict changes.

The wrong columns stay fixed. Choose Unfreeze Panes, then reselect the correct boundary cell. To freeze A through C only, select D1. To freeze A through C and row 1, select D2. Remember that selecting a cell in column A cannot freeze columns to its left, because there are none.

The column seems to disappear when you scroll. First check whether the column is hidden or whether you are scrolling vertically rather than horizontally. Use the horizontal scrollbar to test the freeze. If a column is hidden, select the surrounding column headers, right-click, and choose Unhide. Unhiding and freezing are separate actions: a hidden column will not become visible just because panes are frozen.

The sheet behaves differently after reopening the file. Confirm that you saved the workbook after setting the freeze and that you are on the same worksheet. Also check whether you are viewing a different workbook copy. If the freeze is still missing, apply it again and save. A collaborator may have changed the view or may be using another sheet.

You cannot freeze only the column you want. This is a limitation of Freeze Panes rather than an error. Excel pins columns from A through the selected boundary. If you need a later column alone for reference, consider moving or copying that identifier to column A, or use another method such as keeping a separate summary area. Avoid restructuring shared data without considering formulas, links, and other users’ workflows.

Frequently Asked Questions

How do I freeze the first column in Excel?

On the active worksheet, choose View > Freeze Panes > Freeze First Column. Column A will remain visible when you scroll horizontally. To remove the freeze, choose View > Freeze Panes > Unfreeze Panes.

Can I freeze column B without freezing column A?

No. Excel’s Freeze Panes command locks a continuous block starting at column A. If you select C1, both A and B remain fixed. Excel does not have a built-in option to keep B fixed while A scrolls independently.

Can I freeze more than one column?

Yes. Select the cell immediately to the right of the last column you want to pin, then choose View > Freeze Panes > Freeze Panes. For example, selecting D1 freezes columns A, B, and C. The frozen columns must be contiguous from the left edge.

Can I freeze a column and the top row at the same time?

Yes. Select a cell that is both below the row to freeze and to the right of the columns to freeze. For example, C2 freezes row 1 and columns A and B. Then choose the regular Freeze Panes command. The Freeze First Column command is for column A only and does not create this custom combined setup.

Does freezing a column stop other people from changing it?

No. Freezing changes what stays visible while navigating the worksheet; it does not lock cells or protect data. To restrict editing, use Excel’s sheet protection features separately, and make sure the protection settings suit the workbook’s purpose.

Do these steps work in Excel for Mac or the web?

The freeze-pane feature is also available in current Excel for Mac and Excel for the web, though the ribbon or menu placement can differ. Look under View for Freeze Panes. The same selection rule applies: for a custom freeze, select a cell below and to the right of the area you want to keep visible.

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.