To keep column A visible while you scroll across an Excel worksheet, open the sheet, select View > Freeze Panes > Freeze First Column. The command pins the leftmost worksheet column in place; the other columns can move horizontally underneath it. You do not need to select a cell first. The steps below are for Microsoft Excel for Microsoft 365 on Windows, with notes for Mac and Excel for the web.
What You’ll Need
- An Excel workbook with the worksheet you want to work on. Freezing is set for the active worksheet, so repeat the steps on other sheets where you need it.
- A version of Excel with the Freeze Panes command, such as Microsoft 365 for Windows, Excel for Mac, or Excel for the web.
- A worksheet where column A contains useful labels or identifiers. Excel freezes the first worksheet column, not whichever column happens to be visible on the left after you scroll.
You do not need to change cell formatting, convert the data to a table, or select a range before freezing the column. If the worksheet already has a freeze setting, you may need to remove that setting first.
Step-by-Step
- Open the correct worksheet. Open the workbook and click the sheet tab containing the data. Freeze settings apply to a worksheet, so confirm you are on the sheet where you want the column to stay visible. If the workbook has several similar tabs, check the column headings or sheet name before changing the view.
- Check that column A is the column you want to keep on screen. The Freeze First Column command always freezes column A. If your row labels are in column B or another column, this command will not pin those labels in place. You can move the identifying information into column A, or use a custom Freeze Panes setting to freeze more than one column, as explained below.
- Open the View tab. On the Windows ribbon, click View. Find the Freeze Panes control in the Window group. Depending on ribbon width or window size, the group may appear compact, but the command remains on the View tab. If you do not see it, expand the Excel window or look for a collapsed group or dropdown on that tab.
- Choose Freeze First Column. Click Freeze Panes to open its menu, then click Freeze First Column. Excel adds a boundary after column A to indicate that the first column is fixed. Do not choose Freeze Top Row unless you also want the top row to remain visible, and do not choose the general Freeze Panes option without checking what cell is selected.
- Scroll horizontally to check the result. Move the horizontal scrollbar at the bottom of the worksheet to the right. You can also use the keyboard or a mouse with horizontal scrolling support. Column A should remain visible while columns B, C, and later columns move across the screen. Vertical scrolling is unaffected: rows still move up and down normally.
- Save the workbook if you want to keep your changes. Use File > Save or press Ctrl+S on Windows. Saving preserves workbook changes, including the worksheet view. The freeze setting does not alter the underlying cell values or formulas, so it is safe to turn it off later.
On Excel for Mac, select the worksheet, then use View > Freeze Panes > Freeze First Column. The ribbon labels are similar, though their location and appearance can differ by window size. The Mac save shortcut is Command+S, rather than Ctrl+S. In Excel for the web, open the worksheet and use View > Freeze Panes > Freeze First Column if the command is available in your current layout. The web app saves changes to the workbook automatically, but still check the column by scrolling sideways.
Common Mistakes
- Freezing the wrong column by assuming Excel means the first visible one. Freeze First Column means column A, even if you have scrolled until column D or H is at the left edge. If the labels you need are in another column, use a custom freeze instead of expecting this command to follow the screen.
- Selecting a cell and then choosing Freeze First Column. The dedicated command does not use the active cell to decide what to freeze. This is different from the general Freeze Panes command, where the selected cell matters. If you need a custom freeze, select the correct cell before using that general command.
- Leaving an old freeze setting in place. A worksheet may already have panes frozen, perhaps both a row and a column. Applying another freeze command can be unavailable or appear not to produce the arrangement you intended. Choose View > Freeze Panes > Unfreeze Panes first, then apply the desired setting.
- Expecting a row to stay visible as well. Freeze First Column pins column A, not the top row. If you need both the heading row and the first column, set up a custom freeze at the appropriate cell rather than using only Freeze First Column.
- Confusing a frozen pane with a split window. A split divides the worksheet into independently scrollable sections. It is a different view feature and can make the sheet behave in a way that resembles freezing. If the screen has movable divider bars, remove the split and apply the freeze setting you need.
- Looking for a visible change without scrolling. Column A normally looks like it is in its usual place immediately after freezing. The effect is easiest to confirm by moving horizontally across the sheet; simply scrolling down will not demonstrate that the column is fixed.
Tips
- Use the first column for identifiers. Names, product codes, account IDs, or other row labels are good candidates for column A. Keeping them visible makes it easier to tell which record you are reading when the data extends across many columns.
- Freeze more than one column when necessary. To keep columns A and B visible, first unfreeze any current panes. Then select cell C1 and choose View > Freeze Panes > Freeze Panes. Excel freezes the columns to the left of the selected cell, so A and B stay in place. Selecting C1 also places no rows above it to freeze, so the top row remains unfrozen.
- Freeze a header row and the first column together. After unfreezing existing panes, select cell B2 and choose View > Freeze Panes > Freeze Panes. Excel freezes the row above and the column to the left of the selection: row 1 and column A. If you need multiple top rows and multiple left columns, select the cell just below and to the right of the rows and columns you want to keep visible.
- Choose a sensible width for column A. A frozen column takes up screen space while you scroll. If it is very wide, fewer data columns will fit beside it. Adjust the column width so its identifiers remain readable without crowding the rest of the worksheet.
- Remember that each sheet can need its own setup. Freezing column A on one sheet does not automatically freeze it on every other worksheet in the workbook. Check each relevant sheet, especially if users rely on the workbook for reports or data entry.
- Use Unfreeze Panes to change your mind. To remove the fixed column, choose View > Freeze Panes > Unfreeze Panes. You can then freeze a different arrangement. Unfreezing changes only the way the sheet is displayed; it does not delete or move worksheet data.
Troubleshooting
The menu option is greyed out or does not seem to work. Check whether panes are already frozen. Choose View > Freeze Panes > Unfreeze Panes, then choose Freeze First Column again. If you are editing a cell, finish the edit first by pressing Enter or Esc. In Excel for the web, make sure the workbook is open in an editing mode that permits view changes, rather than a read-only or restricted state.
Column A moves when you scroll sideways. Confirm that you used Freeze First Column, rather than just selecting a cell or using Split. Then test horizontal scrolling, not vertical scrolling. If the command still appears ineffective, unfreeze the panes and apply it again. If column A is hidden, use the column headers to unhide it; a frozen but hidden column cannot serve as a visible label.
A different column stays fixed, or more than one area is frozen. The sheet likely has a custom freeze arrangement from an earlier setup. Select Unfreeze Panes to clear it, then choose Freeze First Column for only A. If you want a different number of columns or want both rows and columns fixed, use the general Freeze Panes command with the correct active cell.
The freeze line is difficult to see. Look for a thin boundary immediately to the right of column A. The line can be subtle at some zoom levels or with certain display settings. Scroll horizontally to verify the behavior; the fact that the divider is hard to spot does not necessarily mean the setting failed.
The result changes when you reopen or share the workbook. Save the file, close and reopen it, and check the same worksheet. If a colleague sees a different view, confirm they opened the same saved workbook and sheet. Excel views can also be affected by separate workbook windows or by someone changing the worksheet view after the file was saved.
You need a label column that is not A. Freeze First Column cannot pin an arbitrary column. If, for example, your labels are in C and you want columns A through C to remain visible, unfreeze the sheet, select D1, and choose View > Freeze Panes > Freeze Panes. This keeps all columns to the left of D fixed. Check that this is practical, because every frozen column uses part of the available screen width.
Frequently Asked Questions
Can I freeze the first column and the top row at the same time?
Yes. First choose View > Freeze Panes > Unfreeze Panes if the sheet already has a freeze. Select cell B2, then choose View > Freeze Panes > Freeze Panes. Excel keeps row 1 and column A visible. Confirm by scrolling both down and to the right.
Can I freeze column B instead of column A?
Not with the Freeze First Column command, which always freezes A. To keep columns A and B fixed, select C1 and choose the general Freeze Panes command. To keep only B visible while allowing A to move is not the same standard freeze arrangement; rearranging the sheet or using a different layout may be more suitable.
Does freezing a column change my data or formulas?
No. Freezing changes the worksheet view only. It does not alter cell contents, formulas, sorting, or the position of data. Use Unfreeze Panes whenever you want to return to a regular scrolling view.
Why can I not see a difference after I freeze the column?
The effect is not obvious while the sheet is still at its left edge. Scroll horizontally so later columns move into view. If A stays on screen, the freeze worked. Scrolling vertically alone will not show the effect because the command fixes a column, not a row.
Does the setting apply to every worksheet in my workbook?
No. Set the freeze separately on each worksheet where you need it. When you move to another sheet, check its view and apply the command there if necessary.
Can I freeze a column in Excel for the web or on a Mac?
Yes. In current Excel for the web and Excel for Mac, look for View > Freeze Panes > Freeze First Column. Ribbon layouts can vary, so if the option is not visible, expand the window or check the View tab’s menus. If you are using a limited or read-only view, open the workbook with editing access.
Related
- F Statistic in Excel: How to Find It
- Find Duplicates in Google Sheets: A Step-by-Step Guide
- Excel Edit History: How to View Changes and Versions
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Print Area: Where to Find, Set, and Clear ItIn Excel for Microsoft 365 on Windows, find Print Area on the Page Layout tab: choose Page Layout…
- Google Sheets Date Field: Entry, Format & FixesA Google Sheets date field is a cell or column used to store dates; it is not a…
- How to Get Rid of Double Spacing in Microsoft WordTo get rid of double spacing in Word, select the affected text, then choose Home > Line and…
- Excel Heatmap Guide: Create, Customize, and Read OneTo make a heatmap in Excel for Microsoft 365, select the numeric cells, then choose Home > Conditional…
- How to Delete a Page in Word Without Losing Text SafelyTo delete an unwanted page in Word, show formatting marks if it is blank, remove the extra text,…
- Create Water Bottle Labels in Word: A Practical GuideTo create water bottle labels in Microsoft Word, choose a label size, set up the page or label…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.