Excel Freeze Panes: Why the Option Is Unavailable

If Excel will not let you freeze panes, first press Esc to exit cell-editing mode, then click a cell on the worksheet and choose View > Freeze Panes > Freeze Panes. If the command is still unavailable, check that you are working in a worksheet rather than a chart or another view; the selected cell also determines exactly which rows and columns will stay visible.

What Freeze Panes does

Freeze Panes keeps chosen rows at the top of the worksheet and chosen columns at the left while you scroll through the rest of the sheet. It is useful when a long list has headings or identifiers that you need to keep in view. For example, a sales sheet might have column headings in row 1 and customer names in column A. Freezing both lets you scroll down to later customers and across to distant sales columns without losing either reference.

The feature works from the active cell’s position, not from a selection of rows or columns. Excel freezes the rows above the active cell and the columns to its left. The cell itself, and the rows below and columns to its right, remain in the scrolling area. This boundary rule is the most common reason a freeze appears to have selected the wrong rows.

Freeze Panes affects the current worksheet view. It does not hide data, change the worksheet’s layout, or lock cells against editing. You can still edit frozen cells; freezing only controls what stays visible as you move around the sheet.

Check the selected cell before freezing

To freeze both headings and identifier columns, select the cell just below and to the right of the area you want to keep visible. Suppose row 1 contains headings and column A contains names. Select B2, then use View > Freeze Panes > Freeze Panes. Row 1 stays at the top, column A stays on the left, and the rest of the sheet scrolls.

Other examples make the boundary easier to see:

Select A2 to freeze only row 1.
Select B1 to freeze only column A.
Select C5 to freeze rows 1 through 4 and columns A and B.

If you select A1, there are no rows above or columns to the left to freeze, so the result may look as if nothing happened. Likewise, selecting A5 freezes the four rows above it, not row 5 itself. If the wrong area is fixed, choose View > Freeze Panes > Unfreeze Panes, click the correct boundary cell, and apply the command again.

Try these steps when the command is greyed out

Work through these checks in order. They help distinguish a temporary interface state from a selection or view issue:

Finish editing the cell. If a text cursor is visible in the formula bar or inside a cell, press Esc to cancel the current edit, or press Enter to commit it. Then click a worksheet cell. Excel disables many view commands while you are editing a cell.
Activate a worksheet. Click a sheet tab and select a cell in its grid. Freeze Panes is a worksheet display feature, so it is not available in the same way when the active window is a chart sheet or another non-worksheet area.
Switch to Normal view. On the View tab, choose Normal if the workbook is in a page-oriented view. Then check the Freeze Panes menu again. Normal is the standard view for working with worksheet cells and scrolling.
Check whether you selected an object. If a chart, picture, shape, or other object is selected, click an ordinary cell instead. The command applies to the worksheet grid, not to the selected object.
Look at the menu options. If Freeze Panes is available but its result is not what you expected, use Unfreeze Panes first. A previous freeze may already be active, and Excel presents Unfreeze Panes in place of the initial command.
Reopen the workbook if the interface seems stuck. Save your changes, close and reopen the file, then test the command in a worksheet cell. This is a sensible check after confirming the selection and view, but it will not correct an incorrectly chosen boundary cell.

Sheet protection is not the same as freezing panes: protection controls which cells or actions can be changed, while freezing controls what remains visible during scrolling. If a protected sheet seems to be involved, first check whether you can select a worksheet cell and whether the view command is available. Do not remove protection unless you have permission and understand why it was applied.

Freeze rows or columns using the preset options

Excel offers convenient presets as well as the custom Freeze Panes command. On Excel for Microsoft 365 for Windows, open the View tab and use the Freeze Panes menu. The first options are Freeze Top Row and Freeze First Column. Choose one when you need just that single boundary; Excel applies the preset to the active worksheet.

Freeze Top Row keeps row 1 visible as you scroll down. It does not freeze whichever row happens to be selected.
Freeze First Column keeps column A visible as you scroll horizontally. It does not freeze the selected column if that column is farther to the right.
Freeze Panes uses the active cell to freeze all rows above it and columns to its left, so it can keep both headings and identifiers visible.

These presets are often the fastest choice for a simple table with one header row or one label column. Use the custom option when your sheet needs more than the first row or first column. You cannot use one freeze to keep separate, nonadjacent rows or columns visible: the frozen area is a continuous block starting at the top and left edges of the sheet.

Remove or change an existing freeze

To clear a freeze, go to View > Freeze Panes > Unfreeze Panes. Excel then allows the worksheet to scroll normally. To replace the frozen boundary, unfreeze first, select a new cell, and choose Freeze Panes again. Selecting a different cell while an existing freeze is active does not simply move the old boundary.

After applying a freeze, test it by scrolling down and across. A horizontal line marks the boundary between frozen rows and the scrolling area, and a vertical line marks the boundary between frozen columns and the scrolling area. If a line is not where you expected, unfreeze and repeat the operation from the cell that matches your intended boundary.

Freezing is a view setting rather than a data change, so it does not rearrange or delete worksheet contents. Still, if you are preparing a shared workbook, check the result at a typical zoom level and window size. A large frozen block can leave little room to view the scrolling area, especially on a small display.

Excel for the web and Mac differences

In Excel for Microsoft 365 on Windows, the usual route is View > Freeze Panes. Excel for the web also provides Freeze Panes from the View tab, although the exact menu presentation can differ from the desktop app. The same basic idea applies: choose a cell below and to the right of the rows and columns you want to keep visible, then apply the freeze. If an option is missing in the browser, check that you are in the worksheet grid and not editing a cell.

In Excel for Mac, use the View menu or View tab and choose Freeze Panes; the available choices and wording can vary slightly by version and window layout. The cell-boundary rule is the same. Mac keyboard shortcuts differ from Windows shortcuts, but freezing panes is readily available through the View controls, so use the menu rather than relying on a shortcut if you are unsure which key sequence applies to your Excel version.

Excel on phones and tablets has a more compact interface, and controls can differ by device and app version. If you cannot find the command on a small screen, open the workbook in Excel for the web or the desktop app and set the freeze there. Always verify the view in the version your team uses, especially if the worksheet will be opened on different devices.

Freeze Panes versus Split

Freeze Panes and Split both divide what you see on screen, but they solve different problems. Freeze Panes keeps selected top rows and left columns fixed while the rest of the sheet scrolls. Split divides the worksheet window into separate panes that can be scrolled independently. If your goal is to keep a header row visible while reading a long table, Freeze Panes is usually the simpler choice.

For example, a split can let you compare distant parts of a worksheet at the same time, but it creates multiple scrolling areas and may be less intuitive when you only need headings to remain visible. If the screen shows an unexpected movable divider or separate scroll areas, check the View tab for Split and turn it off if that is not what you intended. Then set Freeze Panes from the correct cell.

Common misconceptions and useful checks

A frequent misconception is that selecting a row tells Excel to freeze that row. It does not: Excel freezes the rows above the active cell. Another is that Freeze Top Row follows the table’s header wherever it appears. That preset freezes worksheet row 1; if your headings are in row 4, select A5 to freeze rows 1 through 4, or use the appropriate cell to freeze the rows and columns you need.

Freezing also does not make headers repeat on printed pages. If you need headings on each printed page, use the separate print-title settings rather than Freeze Panes. Similarly, freezing a row does not protect its contents from edits. Use worksheet protection when the goal is to restrict changes, and use Freeze Panes when the goal is to keep reference information on screen.

Finally, the frozen area can be larger than you need. Freezing five rows and three columns may leave a small scrolling region on a laptop display. If the sheet feels cramped, unfreeze it and use a smaller boundary, or freeze only the most useful headings and identifiers.

Frequently Asked Questions

Why is Freeze Panes greyed out in Excel?
Exit cell-editing mode with Esc or Enter, click a worksheet cell instead of an object, and switch to Normal view if needed. If the command is enabled but an existing freeze is active, the menu may show Unfreeze Panes instead.

How do I freeze the top two rows?
Select A3, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the active cell, so rows 1 and 2 remain visible. If you also want to freeze columns, select a cell farther right, such as B3.

Why is the wrong row staying visible?
The active cell sets the boundary, and Excel freezes rows above it rather than the selected row. Choose Unfreeze Panes, select the cell immediately below the last row you want fixed, and apply Freeze Panes again.

Can I freeze a row and a column at the same time?
Yes. Select the cell below the rows and to the right of the columns you want to keep visible. For row 1 and column A, select B2, then choose Freeze Panes.

How do I unfreeze panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the frozen boundaries from the current worksheet view; it does not change or delete the worksheet data.

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.