To freeze columns in Excel, select the column immediately to the right of the ones you want locked, open View > Freeze Panes, and click Freeze Panes. The split falls on the left edge of whatever cell is active. If you highlight column D and freeze, columns A through C stay put while D scrolls. The catch: Excel has no setting that freezes columns only, so the same action always pins rows above the selection too.

That row side effect is the mistake most people hit first. Freeze the wrong cell and you lock a header row you didn't want, or you pin nothing at all because the active cell sat in row 1. This guide covers the exact click paths for Microsoft 365, Excel 2021, 2019, and Excel for the web, then the cases where freezing quietly breaks things β€” merged cells, shared workbooks, and lookups that still fail.

Where the Freeze Panes Command Actually Lives

Every Windows and Mac build puts the command in the same place: the View tab, in the Window group, roughly a third of the way across the ribbon. Clicking Freeze Panes opens a three-item dropdown β€” Freeze Panes, Freeze Top Row, Freeze First Column. Only the first item does columns; the other two are one-click shortcuts that pin row 1 or column A and nothing else.

On the Mac, the path is View > Window > Freeze Panes, and the dropdown shows the same three options. Keyboard users skip the ribbon entirely: Alt+W, then F, then F on Windows freezes at the active cell. On a Mac, press Control+Option+Command+F or use the ribbon accelerator sequence. Microsoft's own keyboard shortcut reference lists these combos, and they work in every desktop release from 2016 forward.

The button is a toggle. Once anything is frozen, the top item changes to Unfreeze Panes, and clicking it clears everything at once. There's no partial unfreeze in the interface β€” if you froze three columns and one row, one click releases all four. Excel doesn't remember a menu of separate panes; it stores a single split point.

One quietly useful detail: the Freeze Panes option greys out entirely while the worksheet sits in Page Layout view or Page Break Preview. Switch back to Normal view on the View tab and it becomes clickable again. If a colleague swears the button is missing, that's almost always why.

The Select-Below-and-Right Rule That Decides What Locks

The rule is positional, not directional: everything above and to the left of the active cell freezes. That means picking the cell at the intersection of the first row and first column you want to keep visible. Want item names in column A and totals in column B locked? Select C2 β€” column C is the first column you want to scroll, row 2 the first row you want to scroll.

What you want pinned Select this cell After freezing
Column A only B1 Column A stays, all rows scroll
Columns A and B C1 A–B stay, all rows scroll
Row 1 only A2 Row 1 stays frozen, all columns scroll
Row 1 and column A B2 Row 1 and column A stay
Rows 1–3 and columns A–B C4 Rows 1–3 and columns A–B stay
Rows 1–2 only A3 Rows 1–2 stay frozen

Row 1 is the exception worth memorizing. If your active cell is B1, the freeze grabs column A and nothing else β€” there's no row above row 1 to pin. The same logic runs the other way: an active cell in A5 freezes rows 1 through 4, no columns.

Working in R1C1 reference style? The selection rule doesn't change. Excel still anchors on the active cell's position, and the Name Box in the top-left corner tells you exactly which cell that is before you commit.

Step-by-Step: Freezing Columns in Microsoft 365 and Excel 2021

1: Click any cell in the worksheet so the window is active. 2: Press Ctrl+Home to jump to A1, then use the arrow keys to reach the cell just below and right of your intended freeze point. 3: Confirm the address in the Name Box reads the cell you expect. 4: Go to View > Freeze Panes > Freeze Panes. 5: Scroll right with the horizontal scrollbar. A thin grey line marks the boundary; panes left of it stay put.

Skip step 2 and the freeze lands wherever you last clicked β€” a stray double-click on a far-off cell is the usual cause of "it froze the wrong thing." If the grey line doesn't appear after step 5, check the View tab again: the label should now read Unfreeze Panes. If it still reads Freeze Panes, the click didn't register, often because a cell was in edit mode.

Excel 2021 behaves identically to Microsoft 365 for this feature; Microsoft lists Freeze Panes as available in every release back to Excel 2007. The one difference is Dark Mode, introduced in 365 and absent from 2021 β€” the frozen boundary line is light grey in both, but it reads more clearly against 365's dark canvas.

Freezing Columns in Excel 2019, 2016, and Excel for the Web

Excel 2019 and 2016 use the same View > Freeze Panes route, and the same three-item dropdown. The only quirk in 2016 is the older Tell Me box: typing "freeze" into it surfaces the command directly, which saves hunting the ribbon. Excel 2019's Tell Me box behaves the same way.

Excel for the web keeps the feature but trims the interface. Open View > Freeze Panes and you get the same three choices; the grey boundary line appears once you scroll. What you lose is the keyboard accelerator chain β€” Alt+W, F, F does nothing in the browser, so ribbon clicks are the only path. The web version also resets any freeze you set when you close the tab, though the setting survives a refresh.

Version limits worth knowing: Excel 2007 dropped the old Window > Freeze Panes dialog that earlier releases used, so any guide referencing that menu predates 2007 and won't match what you see. Excel for iPad and iPhone has no freeze command at all as of the 2026 builds β€” the mobile app lets you scroll and edit but not pin panes.

How to Unfreeze a Single Column Without Losing the Rest

Excel offers one unfreeze control, and it clears everything. To release a single column while keeping others pinned, you have to unfreeze all, then re-freeze at a new split point. There is no per-column lock toggle in the interface.

The reliable procedure: View > Freeze Panes > Unfreeze Panes, confirm the grey line disappears, click the new boundary cell, then Freeze Panes again. Budget about ten seconds per adjustment β€” trivial once, annoying if you're reshuffling a wide report repeatedly.

A workbook-level trick helps when several sheets share the same layout. Right-click a sheet tab, choose Select All Sheets, set the freeze on the active sheet, and Excel applies the same split to every selected sheet at once. This is the closest thing to batch freezing the program offers. Third-party add-ins can script per-sheet changes, but nothing in the stock ribbon does.

Why Freezing Broke on Merged Cells and Shared Workbooks

The command greys out in two situations that catch people off guard. Merged cells that straddle the freeze boundary will make Excel refuse the action outright β€” a title merged across A1:F1 is the classic offender. Unmerge first, or move the merge outside the boundary, and the button returns.

The second case is co-authoring. In a workbook shared through SharePoint or OneDrive with live co-authoring active, Freeze Panes can be unavailable or behave inconsistently for some participants, because each person's view is rendered separately. Microsoft's support documentation for co-authoring notes that some view settings don't sync across sessions. The workaround is to exit co-authoring mode, set the freeze, and re-share.

A third failure shows up in files saved from Google Sheets. Sheets stores frozen rows and columns as metadata Excel doesn't always map cleanly, so a converted file may open with the freeze missing or applied to the wrong pane. Reapply it manually in Excel; there's nothing to repair.

Freeze Panes vs Split vs the Camera Tool: Picking the Right Lock

Freeze Panes isn't the only way to hold columns in view, and for some jobs it's the wrong tool. Three approaches cover most needs, and the choice turns on whether you want to scroll two regions independently or just anchor one.

Method What it holds Setup path Best for Drawback
Freeze Panes Rows above and columns left of active cell View > Freeze Panes Wide tables where you read across Can't freeze columns alone
Split Resizes two independently scrolling panes View > Split Comparing two distant parts of one sheet Panes drift if you insert rows
Camera tool A live picture of a range, placed anywhere Quick Access Toolbar > Camera Dashboard snapshots of key columns Picture doesn't scroll; manual refresh
New Window A second view of the same sheet View > New Window Side-by-side comparison on two monitors Doubles window count, not a lock

The verdict splits cleanly: use Freeze Panes when you scroll a big table and need the label column visible, use Split when you're comparing row 400 against row 12, and reach for New Window when you have two screens and want two independent scroll positions of the same data. The Camera tool is for reporting, not navigation.

Checking the Freeze Programmatically and Printing It

Excel has no built-in formula that reports whether panes are frozen, so a quick visual check is the horizontal scrollbar β€” if the grey boundary line is visible at the left edge, something is locked. For anyone auditing a template, pressing Alt+F11 opens the VBA editor, and the ActiveWindow.FreezePanes property returns True or False. That's read-only diagnosis, not a setting change.

The freeze also carries into printouts in one specific way: Excel prints the frozen columns on every page when you set Print Titles under Page Layout > Print Titles, with the Columns to repeat at left field holding the range like $A:$C. This is separate from Freeze Panes and survives independently; freezing panes doesn't create print titles, and print titles don't freeze on screen.

A last accessibility note: frozen panes are announced by screen readers such as NVDA and JAWS as the reader moves across the boundary. Microsoft's accessibility documentation for Excel confirms pane boundaries appear in the navigation tree. Test a template with a screen reader before shipping it to a team that relies on one.

Freeze Panes and the Lookup That Still Fails

Freezing makes a lookup easier to build but doesn't make it correct, and that gap produces real errors. A VLOOKUP pointed at a frozen label column can still return #N/A when the lookup value sits in a cell formatted as text while the table holds numbers β€” a mismatch freezing never touches.

The failure case worth memorizing: two columns look identical, one holds "1001" as text and the other holds 1001 as a number. VLOOKUP with exact match treats them as different values and returns #N/A even though the frozen column is perfectly visible. The fix is to coerce both sides β€” wrap the lookup value in VALUE() or multiply by 1 β€” or switch to XLOOKUP with a wildcard tolerance. Microsoft's VLOOKUP documentation flags the text-versus-number trap explicitly.

Freezing also changes how you should build relative references. When you copy a formula down a column that starts left of the freeze boundary, Excel's relative references still shift. A formula in column D referencing C2 continues to shift correctly; freezing simply keeps C visible on screen and has no effect on the math.

The broader lesson: the boundary is a viewing aid, not a data structure. Anyone who treats the frozen column as a guaranteed anchored reference in a formula will be surprised when a sort rearranges the rows behind it.

FAQ

How do I freeze only column A in Excel?

Select cell B1 and click View > Freeze Panes > Freeze Panes. The A column locks and all rows scroll, because row 1 has nothing above it to pin. Confirm by checking that the grey boundary line appears at B1's left edge. If the boundary is missing, the click didn't register β€” try again.

Does freezing panes work in Excel for the web?

Yes, the feature is present, but the keyboard accelerator doesn't fire in the browser. Use View > Freeze Panes > Freeze Panes with the mouse. Freezes are remembered for a session but reset when the tab closes, so a shared link won't preserve someone else's freeze setting.

Why is the Freeze Panes button greyed out?

Three causes dominate: the worksheet sits in Page Layout or Page Break Preview view, merged cells straddle the intended boundary, or the file is in live co-authoring. Switch to Normal view first, then unmerge offending cells, then exit co-authoring. The button returns immediately once the blocker is cleared.

Can I freeze columns without locking row 1?

Not with Freeze Panes, which always pins whatever rows sit above the active cell. To lock only a column, select a cell in row 1 β€” a B1 selection gives you column A alone. The trade-off is that row 1 never freezes when the active cell is in it.

How much does a per-column freeze add-in cost?

Most enterprise-grade Excel add-ins for pane management sit in the paid tier, and pricing changes, so confirm on the vendor's site before budgeting. For most users the ten-second unfreeze-and-refreeze routine beats any add-in. Freeze Panes itself ships with every paid Microsoft 365 plan at no extra charge.

What's the difference between Freeze Panes and Split?

Freeze Panes locks one boundary; Split creates two independently scrolling regions you size by dragging. Split is better for comparing distant rows in the same sheet. Freeze Panes is better for reading a wide table. Split loses its reliability if you later insert rows above the split line.

Can the frozen part be hidden from a colleague viewing the same file?

No. Freezing is a view setting stored with the workbook, and anyone who opens it sees the same split unless they unfreeze it themselves. For privacy, hide columns (right-click the header > Hide) instead β€” that's a separate, persistent state that travels with the file.

Why did my freeze disappear after I saved and reopened?

The most common cause is a file originally saved in Google Sheets format and converted β€” Sheets stores pane settings differently and Excel doesn't always read them. Reapply the freeze and save as .xlsx. If it recurs, check whether a macro or add-in is resetting the ActiveWindow on open.

Excel's freeze settings are view-only and don't change calculations, formulas, or data. For finance, compliance, or audit work, confirm frozen panes and print titles against your organization's spreadsheet standards, and have qualified reviewers sign off on any workbook used for reporting or regulatory submission. Nothing here is a financial, legal, or accounting opinion.