Excel Freeze Panes Wrong Selection? How to Fix It

If Excel freezes the wrong rows or columns, first choose View > Freeze Panes > Unfreeze Panes, then select the cell one row below and one column to the right of the area you want fixed and choose View > Freeze Panes > Freeze Panes. For example, select C4 to keep rows 1–3 and columns A–B visible while you scroll.

How Excel decides what to freeze

Freeze Panes uses the active cell as a boundary. Excel freezes the rows above that cell and the columns to its left. The selected cell itself, along with the rows below it and columns to its right, remains in the scrolling area. The feature does not freeze the selected row or column automatically; it freezes the area before the selected cell.

This rule applies to both directions at once. If you select C4, Excel fixes the top three rows and the first two columns. If you select A4, it fixes the top three rows but no columns. If you select C1, it fixes columns A and B but no rows. Selecting A1 gives Excel no rows or columns to hold still, so it does not create a useful freeze.

The frozen area always begins at the worksheet’s top and left edges. You cannot use Freeze Panes to hold a middle block in place while letting the rows or columns before it scroll independently. That sort of independent division is closer to what the Split command is for.

Choose the right cell before freezing

Work backward from the boundary you want. Count how many complete rows should stay visible, then select the first row that should scroll. Do the same for columns: select the first column that should move. The intersection of those two positions is the cell to select.

Keep row 1 visible: select A2, then choose Freeze Panes. You can also use the dedicated Freeze Top Row command.
Keep rows 1 and 2 visible: select A3, then choose Freeze Panes.
Keep column A visible: select B1, then choose Freeze Panes. Freeze First Column is another direct option.
Keep columns A and B visible: select C1, then choose Freeze Panes.
Keep rows 1–3 and columns A–B visible: select C4, then choose Freeze Panes.

For a practical example, imagine a sales sheet with a three-row title and header area, followed by monthly records, and with customer names in column A and regions in column B. Selecting C4 keeps the titles, headings, customer names, and regions on screen while you move through later rows and columns. If you select B4 instead, the first two columns stay fixed, which may be one column more than intended.

Reset a freeze that is already wrong

Excel generally allows one freeze configuration for a worksheet view at a time. Choosing a new boundary while panes are already frozen can be confusing, so clear the existing setting first. In Excel for Microsoft 365 on Windows, click anywhere in the affected worksheet and use View > Freeze Panes > Unfreeze Panes. Then click the intended boundary cell and apply Freeze Panes again.

Open the correct worksheet and select View > Freeze Panes > Unfreeze Panes.
Check which rows and columns should remain visible, and identify the first row and column that should scroll.
Click their intersection cell. For example, choose C4 to hold rows 1–3 and columns A–B.
Choose View > Freeze Panes > Freeze Panes, not Freeze Top Row or Freeze First Column unless one of those preset choices is exactly what you need.
Scroll down and right to verify the boundary. If it is still wrong, unfreeze and repeat with the corrected cell.

Unfreezing does not delete worksheet data, change formulas, or remove formatting. It changes the scrolling view. The freeze setting is also separate for each worksheet, so check the sheet tab before changing it if a workbook has several similar tabs.

Why the result can look different than expected

A frequent mistake is selecting the header row itself rather than the row immediately below it. To keep rows 1–3 fixed, select a cell in row 4. Selecting a cell in row 3 keeps only rows 1 and 2 fixed. The same off-by-one rule applies to columns: to keep A and B, select a cell in column C.

Another common issue is selecting a cell that is not at the intersection of the desired boundaries. Selecting C1 freezes columns A and B, but it does not freeze any rows. Selecting A4 freezes the first three rows, but it does not freeze columns. It is easy to overlook this when the goal is to hold both a header and an identifying column in view.

The active cell matters, not merely the highlighted region. If you select a range, Excel uses the active cell within that selection, which may not be the corner you had in mind. For a predictable result, click one individual cell at the correct boundary before applying the command. The Name Box to the left of the formula bar can help: enter a reference such as C4 and press Enter to go directly to that cell.

Also inspect hidden rows or columns. A freeze line can appear to sit in an unexpected place if a row or column between the worksheet edge and your selection is hidden. Unhide the relevant rows or columns temporarily if needed, confirm the boundary, and then restore the layout. Zoom level and unusually tall rows can affect how much of the sheet is visible, but they do not change which rows or columns the freeze command targets.

Freeze Panes, Freeze Top Row, and Split are different

The Freeze Panes menu includes separate choices because they solve related but distinct problems. Freeze Top Row holds the first worksheet row in place, regardless of which cell is selected. Freeze First Column holds column A. Use these presets when you only need that single row or column; they are not a way to freeze any arbitrary row or column.

Freeze Panes is the flexible choice when you need multiple top rows, multiple left columns, or both. It uses the active cell to define the boundary. If a preset is active and you need a different arrangement, unfreeze first, select the right boundary cell, and apply Freeze Panes.

Split divides the worksheet window into separate panes that can scroll independently. It is useful when you want to compare distant parts of a sheet, such as the top and bottom of a long list, but it is not the same as locking headings in place. If you see movable divider bars or multiple independently scrolling sections, you may have used Split rather than Freeze Panes. Turn off the split from the View tab, then set the freeze you actually want.

Excel for Mac and Excel for the web

In Excel for Mac, the Freeze Panes commands are on the View tab, with the same basic selection rule: rows above and columns to the left of the active cell are held in place. Menu wording or placement can vary slightly between releases, so look for Freeze Panes on the View ribbon or View menu. Clear the current freeze before setting a new boundary if the result is unexpected.

Excel for the web also provides freeze controls on the View tab, though the available commands and ribbon layout can differ from the Windows desktop app. If the web version does not offer the precise arrangement you need, open the workbook in the desktop app and use the boundary-cell method there. In every version, verify the result by scrolling; the boundary should stay visible while the rest of the sheet moves.

Plan a useful freeze for large worksheets

Freezing too much can make a sheet harder to use. Several fixed rows and columns reduce the area available for scrolling data, especially on a small screen. A good setup usually keeps only the labels needed to interpret the visible records: perhaps one or two header rows and a name or ID column.

Before freezing, consider whether the worksheet has title rows above its actual column headings. If the headings are in row 4, freezing only the top row will not keep those headings visible as you scroll. Select A5 to retain rows 1–4, or select a later column as well if left-side identifiers should remain fixed. If the title rows take up too much screen space, consider whether the sheet layout can be simplified rather than freezing a large area.

Freeze Panes affects how a person navigates the worksheet; it does not lock cells against editing, protect formulas, or control what prints. Use worksheet protection for edit restrictions, and use print titles or page setup options when the goal is to repeat headings on printed pages. These features address different tasks.

Frequently Asked Questions

Why does Excel freeze the row above the one I selected?
That is the intended rule: Excel freezes every row above the active cell. To keep rows 1–3 visible, select a cell in row 4. The selected row is the first row in the scrolling area, not an extra frozen row.

How do I freeze the top two rows and the first column?
First unfreeze any existing panes. Then select B3, which is below row 2 and to the right of column A, and choose View > Freeze Panes > Freeze Panes.

Can I freeze a row that is not at the top?
Not by itself with Freeze Panes. The command fixes a continuous area from the top of the sheet through the rows above the selected cell. To keep row 10 visible, for example, Excel would also keep rows 1–9 fixed.

Why is Freeze Panes greyed out?
Check that you are in a normal worksheet view and that you have selected a worksheet cell rather than an object or chart. Also check whether the workbook or sheet has restrictions that limit editing or view commands. If the control remains unavailable, save your work and reopen the workbook in the desktop Excel app to check whether the current view or file state is limiting the command.

Does freezing panes change printing or protect data?
No. It changes the on-screen scrolling view only. Set print titles separately to repeat headings on printed pages, and use sheet protection if you need to limit which cells people can edit.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.