To keep an Excel column visible while you scroll horizontally, choose View > Freeze Panes > Freeze First Column. To hold a different column or several columns in place, select the cell immediately to their right, then choose View > Freeze Panes > Freeze Panes.
What freezing a column does
Freeze Panes keeps selected worksheet rows or columns on screen while you move through the rest of the sheet. It is especially useful when a wide table extends beyond the screen: the first column might contain employee names, product IDs, dates, or account numbers, while the columns to the right contain details you need to compare. Keeping the identifying information visible makes it easier to tell which record you are reading.
A frozen column does not stop the worksheet from scrolling, and it does not prevent anyone from editing its cells. It stays displayed at the left edge of the worksheet area while unfrozen columns move underneath or out of view. The feature affects the current worksheet, not every sheet in the workbook, so apply it separately wherever it is useful.
Freeze the first column in Excel for Windows
In Microsoft Excel for Microsoft 365 on Windows, open the worksheet and use the View tab on the ribbon. Then:
- Select View > Freeze Panes.
- Choose Freeze First Column.
- Scroll horizontally to check that column A remains visible while the other columns move.
You do not need to select column A first. The command freezes the worksheet’s first column, which is column A, regardless of which cell is active. A thin vertical line beside the frozen area indicates the boundary. If you do not see it clearly, scroll sideways or look closely near the right edge of column A.
Freeze First Column is the simplest choice when the labels you need are in column A. If your table starts in column C, or the important identifier is in another position, use the custom Freeze Panes method instead. The first-column command is not a general command to freeze whichever column happens to be selected.
Keep multiple or later columns visible
To freeze more than column A, select the cell immediately to the right of the last column you want to keep visible. Excel freezes all columns to the left of that cell. For example, to keep columns A and B visible, select a cell in column C, such as C1, and choose View > Freeze Panes > Freeze Panes. To keep columns A through D visible, select a cell in column E.
The selected cell’s row matters too. Freeze Panes uses the active cell as a boundary: it freezes columns to the left and rows above. So selecting C1 freezes columns A and B without freezing any worksheet rows. Selecting C4 freezes columns A and B plus rows 1 through 3. This rule lets you create a useful combination, but it also explains why Excel may appear to freeze more than you intended.
For a later column rather than a continuous block from A, Excel’s Freeze Panes command is not a way to pin just that one isolated column while allowing earlier columns to scroll. It freezes a continuous region starting at the top and left of the sheet. If the identifier is in column D, for instance, keeping A through D visible may be the practical option; otherwise, consider rearranging the worksheet or using a separate summary view.
Freeze a header row and columns together
You can hold a heading row and one or more columns in place at the same time. Select the cell one row below the rows to keep and one column to the right of the columns to keep. For example, if row 1 contains headings and column A contains names, select B2, then choose View > Freeze Panes > Freeze Panes. Row 1 and column A will remain visible as you scroll down and across.
For two heading rows and the first two columns, select C3 before using Freeze Panes. The two rows above the selection and the two columns to its left are frozen. Think of the active cell as the upper-left corner of the area that should move: the cells above and left of it stay fixed. If your selection is in the wrong place, unfreeze and repeat rather than trying to drag the boundary.
Unfreeze or change the frozen area
Excel allows one frozen-pane arrangement per worksheet at a time. To replace it, first choose View > Freeze Panes > Unfreeze Panes. Then select the correct boundary cell and apply the desired Freeze Panes command. If the worksheet currently has only the first column frozen, the Freeze Panes menu may show Unfreeze Panes in place of the first-column option.
Unfreezing does not delete data, change column widths, or remove formatting. It simply returns the worksheet to ordinary scrolling. You can then freeze a different area, for example changing from the first column alone to the top row plus the first two columns. If you are unsure which region is fixed, inspect the visible divider lines or choose Unfreeze Panes and set the arrangement again.
Freeze Panes compared with Split and protection
These Excel features sound similar but solve different problems:
- Freeze Panes keeps selected top rows and left columns visible while the rest of the worksheet scrolls. It is usually the right answer when a column seems to move away from its data.
- Split divides a worksheet window into independently scrollable panes. It is useful when you want to compare distant areas, but it does not simply anchor the left column as a permanent label in the same way. Use View > Split to toggle the split.
- Protect Sheet can restrict certain edits, depending on the protection settings. It does not keep a column on screen. Cell locking and worksheet protection are about editing permissions, not scrolling.
Another frequent misunderstanding is that a frozen column is “locked” in the security sense. Freeze Panes is a display setting, not a password or access control. Someone with permission to edit the workbook can still change the values in a frozen column unless separate protection or sharing controls apply.
Common problems and fixes
If the wrong rows or columns stay visible, the active cell was probably positioned incorrectly when Freeze Panes was chosen. Unfreeze, identify the exact area you want to remain fixed, and select the boundary cell just below and to the right of that area. Remember that selecting C4 freezes both columns A:B and rows 1:3, not just columns A:B.
If the command appears unavailable or behaves unexpectedly, check whether you are editing a cell. Press Enter or Esc to finish or cancel the edit, then try the View menu again. Also confirm that you are in the worksheet you intend to change: frozen panes are sheet-specific, and switching tabs can make it seem as though the setting has disappeared.
If you cannot see the divider, the frozen region may be narrow, the worksheet may not need to scroll in that direction yet, or the window may be zoomed in. Try scrolling horizontally or vertically, widening the worksheet window, or reducing the zoom. The boundary marks the edge of the frozen area; it is not a thick border around the cells.
If a column still moves, make sure you chose Freeze First Column or Freeze Panes rather than Split, and verify that the sheet has not been unfrozen. Also check whether you are looking at a different workbook window or sheet. Freeze Panes is not a workbook-wide setting, so repeating the command on another worksheet may be necessary.
Excel on Mac and Excel for the web
In Excel for Microsoft 365 on Mac, use the View tab and its Freeze Panes controls; the relevant choices are generally Freeze First Column, Freeze Panes, and Unfreeze Panes. The exact ribbon layout can differ from Windows, but the selection rule is the same: choose a cell below and to the right of the rows and columns to retain, then apply Freeze Panes. Mac keyboard shortcuts can also differ, so the ribbon menu is the clearest route when following these steps.
Excel for the web also provides freeze controls on the View tab, though the menu layout can vary as Microsoft updates the web app. Look for Freeze Panes and the first-column option. If a command is missing in your current view, open the workbook in the desktop app and set the panes there. A frozen layout is a worksheet view setting; check the workbook after saving if you need to confirm that the arrangement is available to other people opening it.
Choose a useful layout before freezing
Freezing works best when the worksheet’s structure supports the way people read it. Keep the most important identifier at the left, use a clear heading row, and avoid freezing a large block that leaves too little room for the data you want to inspect. On a small laptop display, freezing four columns can make the scrolling area cramped even if those columns are useful on a wide monitor.
For example, in a sales list with customer names in A, regions in B, and monthly results in C onward, freezing columns A and B can preserve context while you compare later months. If column A contains an ID and column B contains a long description, freezing both may consume too much screen space. You might instead keep only the ID visible, shorten or wrap the description, or reorganize the table so identifiers are together at the left.
Freeze Panes is most useful for on-screen navigation, not for changing how a worksheet prints. If you need a heading to repeat on every printed page, use the print-title settings rather than assuming a frozen row will repeat in print. Likewise, filters and tables can help manage large lists, but they do not replace frozen labels when you scroll across many columns.
Frequently Asked Questions
How do I lock a column in Excel when scrolling?
Choose View > Freeze Panes > Freeze First Column to keep column A visible. For other or multiple columns, select the cell immediately to their right and choose Freeze Panes.
Can I freeze column B without freezing column A?
Not with the standard Freeze Panes command. It freezes a continuous block of columns from the left edge, so freezing through B also keeps A visible. Consider rearranging the data if only an isolated later column needs to remain in view.
How do I freeze the top row and first column?
Select cell B2, then choose View > Freeze Panes > Freeze Panes. Excel keeps row 1 and column A visible while the rest of the sheet scrolls.
Why is Freeze Panes greyed out?
Finish or cancel cell editing and return to the worksheet view, then try again. If the command is still unavailable, check that you are using a worksheet rather than another workbook view or dialog.
Does freezing a column protect it from editing?
No. Freeze Panes only changes what remains visible during scrolling. Use worksheet protection or other access controls if you need to restrict editing; those controls are separate from frozen panes.
Related
- Power Query Union Tables: How to Append Queries
- Data Validation: Definition, Rules, and Examples
- Excel Data Validation Date Picker: Setup and Options
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel File Not Opening? Fix Corruption and Recover DataIf an Excel file will not open and Excel reports corruption, make a copy first, then try File…
- Excel MAX Ignore #N/A: Two Reliable FormulasTo make Excel’s MAX ignore errors such as #N/A, use AGGREGATE with function number 4 and option 6.…
- Excel Consolidate: Fix Overlapping Source ReferencesYes. In Excel for Microsoft 365 on Windows, Data > Consolidate can reject a source reference if it…
- Excel Date: How to Change, Format, and Fix Date ValuesTo change a date in Excel, select the cell and type the correct date; to change only how…
- Excel Cell Keeps Changing My Number? Here’s the FixIf Excel keeps changing a number, first check whether it changed the stored value or only how the…
- INDIRECT Excel Not Working? Fix the ReferenceIf INDIRECT is not working, check that its text builds a valid cell reference, that the referenced sheet…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.