Freeze Panes in Excel: Lock the First Column and Header Row

To keep column A visible while you scroll in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze First Column. To keep both column A and the top row visible, select cell B2 first, then choose View > Freeze Panes > Freeze Panes.

What freezing the first column does

Freezing a pane keeps part of a worksheet in view while you move through the rest of it. The Freeze First Column command pins column A at the left edge of the worksheet window. When you scroll horizontally to later columns, column A remains visible so you can still identify the row labels or names beside the data. It also stays in place while you scroll down through rows.

This is useful when a worksheet is wider or longer than the screen. For example, a sales sheet might put product names in column A and monthly figures in columns B through M. Without a frozen column, scrolling to the later months can separate the figures from the product names. Freezing column A keeps those labels alongside the numbers.

Freezing affects how the sheet is displayed; it does not rearrange, copy, or protect cells. The underlying data and formulas remain in their original locations. It is a view setting, not a way to make a column permanent in a printed report or to prevent someone from editing it.

How to freeze column A

In Excel for Microsoft 365 on Windows, use the View tab on the ribbon. The command is simple, but first check that the worksheet is positioned as you want: Freeze First Column always targets column A, not whichever column happens to be the first one visible after horizontal scrolling.

Open the worksheet and select the View tab.
Open the Freeze Panes menu in the Window group.
Choose Freeze First Column.
Scroll horizontally to confirm that column A stays visible while the other columns move.

A vertical line just to the right of the frozen area marks the boundary. The line is a visual indicator, not a cell border or a change to the worksheet formatting. If you do not see it immediately, scroll sideways or look near the right edge of column A.

To remove the setting, open View > Freeze Panes again and choose Unfreeze Panes. Excel applies one freeze arrangement at a time: choosing a different freeze command replaces the current arrangement rather than adding an independent frozen area.

Freeze the first column and the header row together

The Freeze First Column and Freeze Top Row commands are quick presets. Choosing one after the other does not combine the two presets; the second choice replaces the first. To keep both a row and a column fixed, use the general Freeze Panes command, which uses the selected cell to determine what stays visible.

For a sheet with headings in row 1 and row labels in column A, select B2, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selection and the columns to its left. In this example, that means row 1 and column A. You can scroll down and right while keeping the heading row and labels on screen.

The selection rule is useful for other layouts too. Select C4 and choose Freeze Panes to keep rows 1 through 3 and columns A and B visible. The selected cell itself is not frozen as a special object; the boundary is placed above it and to its left. If you select A1, there are no rows above or columns to the left to freeze, so choose a cell that sits below and to the right of the areas you want retained.

Choose the right freeze option for the worksheet

Use the preset that matches the part of the sheet you need to keep in view. Freezing extra rows or columns can leave less room for scrolling data, particularly on a small display.

Freeze First Column: Keeps column A visible. Choose it when row names or identifiers are in the first column and you do not need to pin a header row.
Freeze Top Row: Keeps row 1 visible while scrolling down. This is useful for column headings when the sheet has no left-side identifier column to retain.
Freeze Panes: Keeps all rows above and columns left of the selected cell visible. Use it for a custom combination, such as the top two rows and first column: select B3, then choose Freeze Panes.

Before freezing, consider whether the labels really are in column A. A report may have a title or blank spacer column there, with useful identifiers in column B. The Freeze First Column preset will still pin A. If you want to retain a different set of columns, use the general command and select the cell immediately to the right of the columns to keep, and below any rows to keep. For example, to retain columns A and B but no rows, select C1 and choose Freeze Panes.

What happens when you scroll

Freezing is most noticeable during horizontal scrolling: the frozen column remains anchored while the unfrozen columns shift across the screen. On a worksheet with many rows, it also remains visible as you move down the page. The rest of the sheet still scrolls normally within the available worksheet area.

Frozen columns do not expand to show every column. If column A is very wide, it can take up much of the worksheet window and leave little room for the moving area. Adjust its width if appropriate by dragging the boundary between the A and B column headings, or use Home > Format > Column Width to enter a width. Changing the width changes the layout, not the freeze setting.

Freeze panes are saved with the workbook’s view. If you close and reopen the file, the frozen area is generally retained for that worksheet. A freeze setting belongs to a worksheet, so another sheet in the same workbook can have a different arrangement. It does not mean that the same column will be pinned on every sheet.

Common problems and fixes

The wrong column is frozen: Freeze First Column pins column A, even if you have scrolled so another column appears at the left of the window. Scroll back to the worksheet’s left edge, or use Freeze Panes with a suitable selection if you need a custom boundary.
The header row disappeared: Freeze First Column does not also freeze row 1. Unfreeze the current setting, select B2, and choose Freeze Panes to retain both the first row and first column.
The command is unavailable or behaves unexpectedly: Check whether the worksheet is in a view or mode that limits window commands, and make sure you are working in the worksheet rather than a chart sheet. If you are unsure which arrangement is active, choose Unfreeze Panes and apply the desired setting again.
A line looks like an unwanted border: The divider at the edge of a frozen area is part of the worksheet window display. It is not cell formatting and will not print as a cell border simply because the pane is frozen.
You cannot edit the frozen cells: Freezing does not lock cells. If editing is restricted, check worksheet protection or other workbook permissions; those are separate from the freeze setting.

One frequent misunderstanding is that freezing a column will keep it visible in a printed copy. It only controls the on-screen worksheet view. For printed pages, use the print options for repeating rows or columns, such as the Print Titles controls on the Page Layout tab, and check Print Preview. Those settings address page layout rather than scrolling on screen.

Freeze panes compared with alternatives

Freeze Panes is a good fit when a label or heading should stay visible as you navigate a large range. It is different from splitting a worksheet. A split creates separate scrollable panes so you can view different parts of the same sheet at once; it does not simply pin the first column as a reference area. If the purpose is to compare distant sections simultaneously, a split may suit the task better. If the purpose is to keep labels next to changing data, freezing is usually more direct.

Hiding a column is not a substitute for freezing it: hidden columns are removed from view instead of remaining available as a reference. Converting a range to an Excel table can help with structured data, and table headers may appear in place of the column letters when you scroll down through the table. That behavior does not pin column A during horizontal scrolling, so it does not replace freezing a left-side identifier column.

Excel for Mac and Excel for the web

In Excel for Mac, the corresponding commands are on the View tab, under Freeze Panes. Choose Freeze First Column for column A, or use the general Freeze Panes command after selecting the cell that defines the boundary. Menu presentation can vary slightly by release, but the selection logic is the same.

In Excel for the web, open the View tab and use Freeze Panes; the available options can depend on the current web interface and workbook. If a particular preset is not shown, use the general freeze command if available, selecting the cell below and to the right of the areas to retain. A workbook opened in a different Excel version may display ribbon controls differently, but freezing panes remains a worksheet view feature.

Frequently Asked Questions

Can I freeze the first column and top row at the same time?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. The rows above and columns to the left of B2 stay visible, which means row 1 and column A.

Why does Freeze First Column keep column A instead of column B?
The preset is defined to freeze the worksheet’s first column, A. It does not use the first column currently visible after scrolling. To freeze a different number of leading columns, use the general Freeze Panes command and select the cell immediately to their right.

How do I unfreeze a column in Excel?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current freeze arrangement for the active worksheet. You can then apply another preset or create a custom arrangement.

Can I freeze two columns instead of one?
Yes. To freeze columns A and B, select C1 and choose View > Freeze Panes > Freeze Panes. Excel freezes the columns to the left of the selected cell; the selected row determines whether any rows are frozen too.

Does freezing a column affect printing or protect its cells?
No. Freezing controls what stays in view while navigating the worksheet. Use print-title settings to repeat labels on printed pages, and worksheet protection if you need to restrict editing; both are separate features.

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.