Excel Freeze Panes Not Working? Fix Common Excel Issues

If Excel won’t freeze panes, first switch to View > Normal, click the cell just below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. If the menu shows Unfreeze Panes, panes are already frozen; unfreeze them and set the selection again.

Check the selection before freezing

Excel freezes rows above the selected cell and columns to its left. The cell you select is not frozen. For example, select B2 to keep row 1 and column A visible. Select D4 to keep rows 1 through 3 and columns A through C visible. This selection rule is the most common reason the result seems wrong: selecting A2 freezes the first row, but no columns; selecting C1 freezes columns A and B, but no rows.

To set a freeze, click a single cell in the worksheet, rather than dragging across a range. Then use the Freeze Panes command. If you want only one edge frozen, the dedicated options can be simpler:

Freeze Top Row keeps row 1 visible while you scroll down.
Freeze First Column keeps column A visible while you scroll sideways.
Freeze Panes uses the selected cell to freeze rows above it and columns to its left.

For instance, a sales table with headings in row 1 and customer names in column A can keep both visible: select B2, then choose Freeze Panes. If the headings occupy rows 1 and 2, select B3 instead.

How to freeze panes in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, open the worksheet and use the View tab on the ribbon. Choose Freeze Panes in the Window group, then select the matching command. The exact steps are:

Click the worksheet tab where you want the setting. Freeze panes apply to the active worksheet, not every sheet in the workbook.
Choose View > Normal if the sheet is in Page Layout or Page Break Preview.
Select the cell below the rows and to the right of the columns to keep visible. Select B2 for the first row and first column; select A2 for just the first row; select B1 for just the first column.
Choose View > Freeze Panes > Freeze Panes, or choose Freeze Top Row or Freeze First Column when that is what you need.
Scroll down or sideways to confirm that the intended rows and columns stay in place.

To remove the setting, choose View > Freeze Panes > Unfreeze Panes. The frozen area is a viewing aid; it does not alter cell values, delete rows, or lock the worksheet from editing.

Why Freeze Panes may be unavailable

If the command is gray, or clicking it has no effect, check the current view and worksheet state before changing the workbook. Freeze Panes is a window-view feature, and some worksheet contexts prevent the command from being applied as expected.

The sheet is not in Normal view. Switch to View > Normal, then try again. Page Layout and Page Break Preview are meant for layout and printing, not the usual scrolling view.
You are editing a cell. If the insertion cursor is inside a cell or the formula bar, press Enter or Esc to finish or cancel the edit, then select a cell and retry.
Several worksheets are grouped. If multiple sheet tabs are selected, click a single worksheet tab before setting the view. When tabs are grouped, Excel displays [Group] in the title bar; right-click a selected tab and choose Ungroup Sheets.
A dialog or another window has focus. Close menus or dialogs and click back in the worksheet grid. A cell must be active for Excel to use its position.
The workbook is open in a different app or view. Confirm you are working in Excel, not a preview or read-only file viewer, and switch to the worksheet’s normal grid view.

Sheet protection is often blamed, but it generally controls which cells or worksheet actions can be changed; it is not the first explanation for a disabled freeze command. Check view mode, editing state, and grouped tabs first. If the workbook is protected or managed by an organization and the command remains unavailable, ask the file owner or administrator about its restrictions rather than removing protection without permission.

Fixing the wrong rows or columns freezing

When Excel freezes a different area than expected, the active cell is usually the clue. Remember that the boundary runs above and left of the selected cell. Selecting B5 freezes rows 1–4 and column A, not just the header row. To correct it, choose Unfreeze Panes, click the right cell, and apply Freeze Panes again.

Also check whether a freeze is already in effect. If the menu offers Unfreeze Panes, a previous setting is active. Excel does not add a second independent freeze area on top of the first. Unfreeze first, then create the new arrangement. The faint horizontal or vertical line in the worksheet indicates the boundary; after scrolling, the frozen section should remain stationary while the rest of the sheet moves.

Hidden rows and columns can make the boundary harder to interpret. If a selected cell is far down or across the sheet, the frozen region may include more rows or columns than you intended. Use the Name Box to jump to a known cell if necessary, but verify the visible boundary before continuing. For a standard header row and label column, B2 is the usual starting point.

Freeze Panes, Freeze Top Row, and Split are different

These commands all affect how a worksheet appears, but they are not interchangeable. Freeze Panes holds chosen upper rows and left-side columns in place as you scroll. Freeze Top Row is a shortcut for keeping row 1 visible, and Freeze First Column keeps column A visible. If the headings begin lower down, use a selected cell and Freeze Panes instead of the top-row shortcut.

Split divides the worksheet window into separate panes. Unlike frozen headers, split sections can scroll independently, which is useful when comparing distant areas of a large sheet. If you see movable divider bars or multiple independently scrolling sections, you may have applied Split rather than Freeze Panes. Use View > Split to turn the split off, then set the freeze you want. A split is not required to freeze rows or columns.

Excel for Mac and Excel for the web

In Excel for Mac, use the View tab and the Freeze Panes menu; the same selection principle applies. Choose Normal view, select the cell below and to the right of the area to retain, and apply Freeze Panes. Menu placement and appearance can vary slightly between Mac releases, but the commands are still in the View controls. Excel’s Windows ribbon shortcuts should not be assumed to work the same way on Mac; use the menu if a keyboard sequence is unfamiliar.

Excel for the web also provides freeze controls from the View tab. If you do not see the command, check that the workbook is open in the editing interface and that you are in a worksheet rather than a preview. Some interface details depend on the browser version and account. If the setting you need is not available in the web app, open the workbook in the desktop version of Excel and apply it there.

When the setting seems to disappear

Freeze panes belong to a worksheet’s view, so another sheet can have a different arrangement. Click each sheet tab and check its own Freeze Panes menu. Likewise, if someone changes the view and saves the workbook, reopening it may show the saved arrangement rather than the one you previously expected. Reapply the freeze on the correct sheet and save the workbook if you want that view retained.

For a shared workbook, remember that a freeze changes how the sheet is displayed, not the underlying data. It does not prevent another person from sorting, editing, or moving through cells. If colleagues need different views, they can use their own viewing options where the app supports them; coordinate before changing a shared file’s saved layout if the displayed view matters to others.

Frequently Asked Questions

Why is Freeze Panes grayed out in Excel?
Switch to View > Normal, finish any cell edit, and make sure only one worksheet is selected. Then click a cell in the grid and check the Freeze Panes menu again.

How do I freeze the top two rows?
Click cell A3, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell, so rows 1 and 2 remain visible.

How do I freeze the first row and first column at the same time?
Unfreeze any existing setting, select B2, and choose Freeze Panes. The selected cell’s position tells Excel to keep row 1 and column A visible.

Why does Excel freeze more rows than I selected?
Freeze Panes uses the active cell as a boundary; it does not freeze a manually highlighted range. Unfreeze, select the cell immediately below the intended rows and to the right of the intended columns, and apply the command again.

Can I freeze panes in Excel for the web?
Yes, the web app has freeze controls under View. If the option is missing in your current interface, use the desktop Excel app to set the worksheet view.

Does freezing panes lock cells?
No. It keeps selected rows or columns visible while scrolling; it does not protect cells or restrict editing. Use worksheet protection separately if you need to limit changes.

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.