To keep an Excel column visible while you scroll, select View > Freeze Panes > Freeze First Column. For more control, select the cell immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. This fixes the columns on screen; it does not lock their position in the worksheet or prevent someone from moving them.
What a fixed column means in Excel
People use “fixed column” to mean several different things in Excel. Most often, they want a column such as names, dates, or product IDs to remain visible while they scroll through a wide worksheet. Excel calls this feature Freeze Panes. The frozen area stays on screen as the rest of the sheet moves, making it easier to match distant values with their row labels.
For example, imagine a sales sheet with customer names in column A and monthly figures in columns B through M. Once column A is frozen, you can scroll to the later months and still see which customer each row describes. The column has not been copied or moved; Excel has simply divided the worksheet view into a stationary area and a scrolling area.
“Fixed” can also mean preventing a column from being moved, keeping a reference constant in a formula, or repeating a column on printed pages. Those are separate tasks. Freeze Panes addresses what stays visible while scrolling, not worksheet editing permissions, formula references, or print layout.
Freeze the first column
In Excel for Microsoft 365 on Windows, use View > Freeze Panes > Freeze First Column. The command freezes column A at the left edge of the worksheet. You can then scroll horizontally, and column A remains visible while columns to its right move.
- Open the worksheet and select any cell. The selection does not determine which column is frozen when you use Freeze First Column.
- Choose View on the ribbon.
- Open Freeze Panes and select Freeze First Column.
- Scroll horizontally to confirm that column A stays in view.
The frozen column is a viewing aid rather than a permanent change to the workbook’s data. It does not alter values, formulas, sorting, or the actual order of the worksheet columns. Other people opening the workbook may see the saved frozen-pane setting, but they can change it in their own view or unfreeze it.
Freeze more than one column or combine rows and columns
To freeze multiple columns, select a cell just to the right of the last column you want to keep stationary. Then choose View > Freeze Panes > Freeze Panes. Excel freezes all columns to the left of the selected cell, along with any rows above it. The cell itself and the rows or columns beyond it remain in the scrolling section.
For example, to freeze columns A and B but not any rows, select C1 before choosing Freeze Panes. To freeze the top row as well as columns A and B, select C2. The selection matters: choosing Freeze Panes while A1 is active will not produce the same result as selecting C2.
Use this general rule to plan a custom freeze:
- Choose the first cell that should remain scrollable in both directions.
- Everything above that cell is frozen as rows.
- Everything to its left is frozen as columns.
This means Freeze Panes freezes a continuous block along the top and left edges. It cannot freeze column D by itself while allowing columns A through C to scroll away. If the identifier you need is in a middle column, consider moving it to the left side of the data, or use another view or layout that makes the identifier easier to compare.
What happens when you scroll
Freezing a column affects the active worksheet view, not the underlying grid. A vertical divider marks the boundary between the frozen columns and the scrolling columns. When you move the horizontal scrollbar, the scrolling section changes position, while the frozen section stays put. If you freeze both rows and columns, the worksheet has a stationary top-left area as well as separate scrolling areas.
Freeze Panes is especially useful when a worksheet is wider or taller than the visible window. Keeping labels visible helps prevent mistakes when comparing values far across a sheet, such as quarterly results, inventory counts, or survey responses. It does not make a column wider, stop its contents from changing, or keep it visible in a separate workbook window after the freeze setting is removed.
Frozen panes apply to a worksheet, so different sheets in the same workbook can have different settings. If you switch to another sheet and do not see the same column fixed, check that sheet’s own View settings. Zooming or resizing the Excel window changes how much of the worksheet is visible, but it does not change which rows and columns are frozen.
Unfreeze or change the frozen area
Excel does not provide a direct command to replace one frozen arrangement with another in a single step. First remove the existing freeze, then set up the desired arrangement. In Excel for Microsoft 365 on Windows, select View > Freeze Panes > Unfreeze Panes. Afterward, select the appropriate cell and choose Freeze Panes again, or use Freeze First Column or Freeze Top Row for a standard layout.
If the command menu offers Unfreeze Panes, a freeze is currently active on that worksheet. If it offers Freeze Panes instead, no panes are frozen. Unfreezing changes only the view; it does not delete rows or columns or change their contents. If you are unsure which arrangement is active, unfreeze and recreate it using the selection rule above.
Freeze Panes is not the same as locking a column
A frozen column remains visible during scrolling, but users can still edit its cells, change its width, or move the column, depending on worksheet protection and the rest of the workbook’s settings. If your aim is to prevent edits, use worksheet protection rather than Freeze Panes. In Excel for Windows, protection settings are available from Review > Protect Sheet. Review the available options before protecting the sheet, because permissions determine which actions remain allowed.
Protecting a sheet and freezing panes solve different problems and can be used together. Protection controls permitted edits; freezing controls what stays in view. Neither should be mistaken for a guarantee that the data cannot be changed under every circumstance: protection is intended to restrict editing in a workbook, not to provide strong file security or encryption.
There is also a formula-related meaning of “fixed column.” In a formula, dollar signs can make a cell or range reference absolute when the formula is copied. That does not keep a worksheet column visible or stop it being moved. If your question is about a formula that should continue referring to a particular column, use an absolute reference; if it is about scrolling, use Freeze Panes.
Common problems and useful checks
If the wrong columns stay visible, the most likely cause is selecting the wrong cell before using Freeze Panes. Unfreeze first, then select the cell immediately to the right of the final column to freeze. To freeze both columns and rows, also make sure the selected cell is directly below the final row you want to keep visible.
If you cannot see the frozen column after scrolling, check whether you used Freeze First Column on the intended worksheet and whether the horizontal scrollbar has moved. A very narrow Excel window or a large frozen area can leave little room for the scrolling section. Freezing too many columns can therefore make the sheet awkward to use, even though the setting is working as designed.
If a column seems to move while you scroll, confirm that the pane boundary is where you expect and that you are scrolling the worksheet rather than switching sheets. Also check whether the workbook has multiple windows open, since each window can display a different view. When the layout is confusing, Unfreeze Panes and set it again from a clearly chosen cell.
Excel for Mac and Excel for the web
In Excel for Mac, the same basic feature is available from the View tab’s Freeze Panes menu; choose the first-column option or select a cell and use Freeze Panes for a custom arrangement. The exact ribbon appearance can differ from Windows, but the selection rule is the same: Excel freezes rows above and columns to the left of the active cell. On a Mac, use the menu rather than relying on the Windows ribbon keyboard sequence.
Excel for the web also includes Freeze Panes controls on the View tab. The available choices and interface details can vary as Microsoft updates the web app, but the purpose is the same. If a command is unavailable or the worksheet view behaves differently, open the workbook in the desktop app and check the worksheet’s freeze setting there. Avoid assuming that a frozen view is a data-protection feature in any version.
Frequently Asked Questions
How do I keep column A visible in Excel?
Choose View > Freeze Panes > Freeze First Column. Column A will remain visible as you scroll horizontally on that worksheet.
How do I freeze columns A and B?
Select C1, then choose View > Freeze Panes > Freeze Panes. Excel freezes the columns to the left of the selected cell, so A and B stay visible.
Can I freeze a column that is not the first column?
Not by itself using Freeze Panes. Excel freezes a continuous block of columns from the left edge through the column immediately before the selected cell. You can move the desired identifier column to the left, or use a different worksheet layout.
Can I freeze a 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. For two columns and the top row, select C2 instead.
How do I remove a fixed column?
Choose View > Freeze Panes > Unfreeze Panes. This removes frozen rows and columns from the current worksheet view without deleting any worksheet data.
Does freezing a column stop people from editing it?
No. Freeze Panes only keeps the column visible while scrolling. To restrict editing, use worksheet protection and set the permissions appropriate to the workbook.
Related
- Excel Data Validation for Dates: Rules and Examples
- Data Validation Checks in Excel: Rules and Examples
- Data Validation Checklist for Excel: What to Check
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Zero Conditional Formatting: Highlight Zero ValuesTo highlight zero values in Excel, select the cells, then choose Home > Conditional Formatting > Highlight Cells…
- Google Sheets Formula to Highlight Duplicates in a ColumnTo highlight repeated values in Google Sheets, select the cells to check, open Format > Conditional formatting, choose…
- Google Sheets IFS Function: Syntax, Examples, and TipsGoogle Sheets’ IFS function checks conditions in order and returns the value paired with the first condition that…
- Google Sheets: Conditional Formatting for Tick BoxesYes. In Google Sheets, you can use conditional formatting to change a checkbox’s appearance or highlight other cells…
- Excel Box and Whisker Plot on a Log Scale?Yes—Excel for Microsoft 365 on Windows can display a Box & Whisker chart with a logarithmic vertical value…
- How to Insert a Checkbox in Microsoft Word: Two WaysTo insert a checkbox in Microsoft Word, use Developer > Check Box Content Control for a box readers…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.