Excel Freeze Panes Greyed Out? Causes and Fixes Explained

If Excel’s Freeze Panes command is greyed out, first switch to Normal view, finish editing any cell, and make sure you have not grouped multiple worksheets. In Excel for Microsoft 365 on Windows, check the View tab; when the command is available, choose View > Freeze Panes and select the option you need.

Check the quick causes first

A disabled Freeze Panes command usually means Excel is in a state where the window command cannot be applied, rather than that the workbook has lost the feature. Work through these checks before changing workbook settings:

Close any open dialog box and finish editing the current cell. Press Enter to accept the edit or Esc to cancel it.
On the View tab, choose Normal under Workbook Views.
Check the sheet tabs at the bottom of the window. If multiple tabs are selected or highlighted, right-click a selected tab and choose Ungroup Sheets.
Click an ordinary cell in the worksheet, then open View > Freeze Panes again.

These steps address common interface states that can disable commands. Ribbon labels and availability can differ slightly between Excel versions, but the same basic checks apply. If the command becomes active after one step, the change in workbook state identifies the likely cause. If it remains disabled, close and reopen the workbook after saving, and check whether the issue occurs in another workbook.

Switch from Page Layout or Page Break Preview

Freeze Panes is designed for the worksheet’s Normal view. If the sheet is displayed in Page Layout or Page Break Preview, switch back to Normal: on Windows, use View > Workbook Views > Normal. The workbook views control may also appear as buttons near the bottom-right of the Excel window. Once Normal view is active, return to View > Freeze Panes.

These views serve different purposes. Page Layout shows the sheet in relation to printed pages, margins, and headers or footers. Page Break Preview emphasizes print-page boundaries. Normal view is the standard grid for working with cells and scrolling, so it is the appropriate place to set frozen rows or columns.

Changing the view does not delete worksheet data or alter the print layout. It only changes how the sheet is displayed while you work. If you need to review page breaks or print formatting later, you can switch back after setting or using the panes.

Exit cell-editing mode and close dialogs

Excel disables many ribbon commands while you are actively changing a cell. This can happen when the insertion cursor is visible in the formula bar or inside the cell, or when you have started typing a value or formula but have not confirmed it. Press Enter to commit the edit, or Esc to abandon it, then try the Freeze Panes menu again. If the formula bar is active, clicking another ribbon tab may not be enough to finish the edit.

An open dialog or another temporary interface state can also prevent you from using ribbon commands. Complete or close the dialog, return to the worksheet, and click a cell. If the selected cell is being edited, the formula bar can make that state less obvious than the cell itself, so check both before assuming the workbook is damaged.

There is no need to select a special range just to make the command available. A normal cell selection is sufficient. The position of that cell matters only after you choose Freeze Panes, because Excel uses it to decide which rows and columns stay visible.

Ungroup worksheets before freezing panes

Excel can group worksheets so that actions apply to more than one sheet at once. Grouping is useful for entering the same value or applying the same formatting across sheets, but it can restrict commands that depend on a particular sheet’s window and scroll position. When sheets are grouped, more than one sheet tab is highlighted; the active sheet may also show an indication such as [Group] in the title bar.

To ungroup them, right-click one of the selected sheet tabs and choose Ungroup Sheets. Alternatively, click a sheet tab that is not part of the current selection. Then select the worksheet you want to work on and check the Freeze Panes command.

Ungrouping does not erase work already made to the sheets. It stops subsequent sheet-level actions from being applied to the group. Before making broad edits, confirm that only the intended sheet tab is selected; otherwise, changes to cells or formatting may be repeated on multiple sheets.

Choose the right cell and apply the freeze

Once the command is active, the active cell determines the boundary. Excel freezes all rows above the selected cell and all columns to its left. The selected row and column themselves remain part of the scrolling area. For example, select B2 and choose View > Freeze Panes > Freeze Panes to keep row 1 and column A visible while scrolling.

Use this selection logic for other layouts:

To freeze the first row, choose View > Freeze Panes > Freeze Top Row. This is useful when column headings are in row 1.
To freeze the first column, choose View > Freeze Panes > Freeze First Column. This helps keep names or identifiers visible while moving horizontally.
To freeze the first three rows, select A4 and choose Freeze Panes.
To freeze the first two columns and first row, select C2 and choose Freeze Panes.

You cannot use this method to keep an arbitrary row in the middle visible while scrolling both above and below it. Freeze Panes keeps the rows and columns before the selection boundary in view, not a disconnected part of the worksheet.

Unfreeze or change an existing pane

If the worksheet already has frozen panes, the menu normally offers Unfreeze Panes instead of Freeze Panes. Choose View > Freeze Panes > Unfreeze Panes first. Then select a new boundary cell and apply the freeze again. Excel does not let you directly reposition an existing boundary by selecting a different cell while the old freeze is still active.

Frozen areas are separated from the scrollable grid by a line. Depending on the layout and window size, the boundary may be subtle, so check whether a row or column remains fixed when you scroll. If a frozen area is not where you expect, unfreeze it and repeat the selection carefully. Selecting A1 and choosing Freeze Panes, for instance, leaves no rows above or columns to the left to freeze; use Freeze Top Row or Freeze First Column for those specific tasks.

Unfreezing panes changes the sheet’s scrolling behavior, not its cell contents. It is safe to use when you need to reset the arrangement, though it removes all current frozen rows and columns together. You then apply the desired combination again.

Freeze Panes, Split, and print titles are different

Freeze Panes is for keeping leading rows or columns visible in the worksheet while you scroll through the rest of the grid. Split divides the worksheet window into independently scrollable sections. If you want to compare distant parts of one sheet at once, View > Split may be more suitable; it is not simply another name for freezing a header.

Print Titles solve a separate problem. They repeat selected rows or columns on printed pages, but do not hold them on screen while you scroll. To set them in desktop Excel for Windows, use Page Layout > Print Titles and configure the rows to repeat at top or columns to repeat at left. A frozen header does not automatically repeat on paper, and a print title does not automatically freeze the header in the worksheet.

Choosing the right feature avoids troubleshooting the wrong thing. If a header disappears only when scrolling, use Freeze Panes. If separate parts of the sheet need independent scrolling, consider Split. If headings are missing from page two and later when printing, configure Print Titles.

Excel for Mac and Excel for the web

In current desktop Excel for Mac, use the View tab and its Freeze Panes controls; the menu names and choices are broadly similar to Windows, though the ribbon layout can vary by release. If the command is disabled on a Mac, check for cell-editing mode, grouped sheets, and a non-Normal view just as you would on Windows. Excel for the web also provides freeze controls on the View tab, though some interface details can differ from desktop Excel.

If the workbook opens in a browser and the command is missing or unavailable, confirm that you are editing the workbook rather than viewing it without edit access. If needed, open it in the desktop app and check the ribbon there. Do not confuse a narrow browser window or a collapsed ribbon with a disabled feature; expand the ribbon or use the available View controls to see the command.

Frequently Asked Questions

Why is Freeze Panes greyed out in Excel?
Common causes include being in Page Layout or Page Break Preview, editing a cell, or having multiple worksheets grouped. Switch to Normal view, finish the edit, ungroup the sheets, and try again.

Can I freeze panes on a protected worksheet?
Worksheet protection is not the first cause to investigate. Check the view, editing state, and grouped tabs first. If the command remains unavailable, test an unprotected copy or another workbook to determine whether the restriction is specific to that file or sheet.

How do I freeze the top two rows?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps the rows above the selected cell visible, so rows 1 and 2 stay in place.

Why did Freeze Panes change to Unfreeze Panes?
That usually means a freeze is already active. Choose Unfreeze Panes to clear the current boundary, then select the cell for the new boundary and apply Freeze Panes again.

Does freezing a row make it repeat when I print?
No. Freeze Panes affects on-screen scrolling. To repeat headings on printed pages, set them separately with Page Layout > Print Titles in desktop Excel.

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.