How to Freeze One Column in Excel

To keep the first column visible while you scroll, select View > Freeze Panes > Freeze First Column. To keep a later column in view, select the cell immediately to its right in row 1, then choose View > Freeze Panes > Freeze Panes. Excel freezes every column to the left of that cell, not just the one beside it, so it cannot freeze an isolated column while leaving earlier columns unfrozen.

What You’ll Need

Excel for Microsoft 365 on Windows, with the workbook open.
A worksheet with the column you want to keep visible. It helps to know whether you need column A or a later column, because Excel handles those cases differently.
If the sheet is in a special view or you are editing a cell, be ready to return to Normal view or finish the edit before using Freeze Panes.

Step-by-Step

Open the worksheet and identify the column. Click the sheet tab that contains your data. Decide which column needs to remain visible as you scroll horizontally. A common example is a names or product column at the far left, so you can tell which record each row belongs to. If you mean column A, use the first-column method in the next step. If you mean a later column, use the custom method in step 3.
Freeze column A, if that is the column you need. On the ribbon, select View > Freeze Panes > Freeze First Column. This locks column A in place while you scroll horizontally through the rest of the worksheet. You do not need to select a cell first. You should see a thin vertical boundary to the right of column A, showing where the frozen area ends. Scroll right to confirm that column A remains visible.
For a later column, choose the cell immediately to its right in row 1. Freeze Panes works from the worksheet’s upper-left corner. It freezes columns to the left of the selected cell and rows above it. For example, to keep column D and the columns before it visible, select E1. Because E1 is in the first row, no rows above it are frozen. To keep column B and the columns before it visible, select C1. This is the right setup when the earlier columns are also useful context.
Apply the custom freeze. With the appropriate cell selected, choose View > Freeze Panes > Freeze Panes. In the menu, choose the first command named Freeze Panes, not Freeze Top Row or Freeze First Column. The selected cell matters: Excel freezes the rows above it and columns to its left. If you selected E1, columns A through D stay visible while you scroll horizontally.
Check that the freeze is working. Use the horizontal scroll bar at the bottom of the Excel window, or shift the mouse wheel if your setup scrolls horizontally that way. The frozen column or columns should stay in place while the other columns move. If you freeze panes below row 1 as well, scroll down to check that those top rows remain visible too.
Change or remove the freeze when needed. Select View > Freeze Panes > Unfreeze Panes to clear the current freeze. Then choose Freeze First Column for column A, or select a new cell and use Freeze Panes for a different boundary. Excel permits one freeze arrangement per worksheet at a time; applying a new one replaces the previous arrangement.
Save the workbook. Save normally after setting the view. If you share the file, tell recipients which column is intended to stay visible, especially if the sheet has several columns frozen. They can change the freeze setting in their own view if they need a different layout.

Important limitation: Freeze Panes always freezes a continuous block starting at the left edge of the worksheet. If you need only column D frozen while columns A through C scroll away, Excel’s built-in Freeze Panes command cannot do that. You can freeze A through D, move the identifying information into a leftmost column, or consider whether hiding earlier columns would suit your layout.

Common Mistakes

Selecting the column instead of the boundary cell. Clicking a column letter and then choosing Freeze Panes does not tell Excel that only that column should stay in place. For a later column, select the cell to its right in row 1. To freeze through column D, select E1.
Expecting Excel to freeze one middle column by itself. The feature locks all columns from A up to the selected boundary. Selecting E1 freezes A through D, not D alone. If you do not want A through C frozen, there is no standard Freeze Panes setting that skips them.
Choosing Freeze First Column for a column other than A. That command always freezes worksheet column A. It does not freeze whichever column you last clicked. Use the custom cell-selection method for a later column.
Selecting a cell below row 1 by accident. Excel will freeze every row above that cell as well as the columns to its left. For example, selecting E2 freezes row 1 and columns A through D. If you only want columns frozen, select a cell in row 1.
Applying a second freeze without clearing the first. If the current boundary is wrong, use Unfreeze Panes first, then set the desired boundary again. Repeatedly selecting menu options without checking the existing freeze can make it harder to see which rows or columns are locked.

Tips

Use Freeze First Column for row labels. In a list where column A contains names, IDs, or product descriptions, freezing A makes it easier to compare values far to the right with the correct record. Keep the column narrow enough that it does not consume too much of the screen.
Choose the smallest useful frozen area. Every frozen column takes up part of the visible worksheet width. If columns A through D are frozen, fewer columns remain available for scrolling into view. Freeze only the columns people need to identify the data they are reviewing.
Use row 1 for a columns-only custom freeze. Selecting a cell in row 1 avoids freezing any worksheet rows. If you also want headings to remain visible, select a cell below the headings and to the right of the columns you want frozen. For example, E2 freezes row 1 and columns A through D.
Use the boundary line as a visual check. A divider next to a frozen column helps distinguish the fixed area from the scrolling area. If it is not where expected, unfreeze and repeat the selection carefully rather than guessing at the menu option.
Keep the worksheet layout in mind. Freeze panes controls what stays visible during scrolling; it does not protect cells, prevent edits, or change the order of columns. For a printed page, use print titles or page layout settings instead of relying on a screen freeze.

Troubleshooting

The wrong columns stay fixed. Choose View > Freeze Panes > Unfreeze Panes, then reselect the correct boundary cell. Remember that selecting E1 freezes A through D. For column A only, use Freeze First Column instead.
The Freeze Panes command is unavailable. Make sure you are not typing in a cell or editing its formula: press Enter to keep the edit or Esc to cancel it, then try again. If the worksheet is in Page Layout or Page Break Preview, select View > Normal and check the menu again. Also confirm that you are working on the intended sheet rather than a different workbook window.
Nothing seems to happen. Look for the divider line and scroll horizontally; the effect is easier to notice after moving away from the left edge. If the worksheet has only a few columns, the frozen area may not be obvious. You can also reopen the Freeze Panes menu: Unfreeze Panes indicates that a freeze is currently active.
A horizontal and vertical area are both frozen. This usually means the selected cell was below row 1 as well as to the right of the columns you wanted fixed. Unfreeze panes, then select a cell in row 1 to freeze columns only. To freeze both headings and columns, select the cell just below the last heading row and just right of the last column to keep fixed.
The instructions look different on your device. Excel for Mac and Excel for the web also provide freeze options from the View tab, but ribbon layout and menu appearance can differ by version. Look for Freeze Panes under View. In the web app, use the same boundary rule: select a cell below and to the right of the area to keep visible, then apply the freeze. If the exact choice is missing, check that the workbook is open in Excel rather than a preview or another spreadsheet app.

Frequently Asked Questions

Can I freeze only column B and let column A scroll?
No. Excel freezes a continuous range of columns starting with column A. Freezing through B keeps both A and B visible. There is no built-in Freeze Panes option to hold B in place while A scrolls independently.

How do I freeze the first column and top row together?
Select cell B2, then choose View > Freeze Panes > Freeze Panes. Excel freezes row 1 and column A because they are above and to the left of B2. If a different number of heading rows or left-side columns is needed, select a cell immediately below and to the right of the area to retain.

What is the difference between Freeze First Column and Freeze Panes?
Freeze First Column is a shortcut that keeps column A visible. Freeze Panes uses your selected cell to set a boundary and can freeze multiple columns, multiple rows, or both. For a later column, select the cell to its right before choosing Freeze Panes.

Can I freeze a column while I scroll down?
Yes. A frozen column remains visible during horizontal scrolling and also stays fixed as you scroll vertically. If you want the column and the top headings fixed together, select the cell below the headings and to the right of the columns to keep, then use Freeze Panes.

Does freezing a column change or lock my data?
No. Freezing changes the worksheet’s on-screen scrolling view only. It does not lock cells, prevent editing, hide data, or affect the values. Use sheet protection if you need to restrict editing, and unfreeze panes if you simply want the normal scrolling view back.

Will Freeze First Column freeze the first column of a table?
It freezes worksheet column A, not the first visible or selected column within a table. If the table starts in column C, Freeze First Column still freezes A. Use Freeze Panes with a carefully chosen cell to freeze the worksheet columns you need.

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.