sodcalculator

10 Tech How-To

Freeze Panes Not Working in Excel? 5 Fixes

Guide 10-44991 · Updated · Step by step

If Excel’s Freeze Panes option is grayed out or just doesn’t seem to lock the rows and columns you want, the cause is almost always one of five things: the sheet is in Page Layout view, you’re in cell editing mode, the sheet is protected, the workbook is shared, or you’ve selected the wrong cell. Here are the five direct fixes for each, followed by the background you need to prevent it from happening again.

Fix 1: Switch Out of Page Layout View

Freeze Panes only works in Normal view. If your worksheet is displayed in Page Layout or Page Break Preview, the Freeze Panes button on the View tab is grayed out and completely unclickable.

  1. Go to the View tab on the ribbon.
  2. In the Workbook Views group, click Normal.
  3. Return to the View tab and click Freeze Panes again.

This is the most common reason the feature appears “broken,” and it takes less than two seconds to fix. Page Layout view is useful for checking margins and headers, but it disables freezing by design, so you need to switch back to Normal before the option becomes available.

Fix 2: Exit Cell Editing Mode

If you are actively typing in a cell, or if the formula bar has a blinking cursor, Excel temporarily disables many ribbon commands, including Freeze Panes. The button may appear grayed out, or clicking it may do nothing.

  1. Press Enter to confirm what you typed, or press Escape to cancel.
  2. Click on any single cell to deselect the editing state.
  3. Try Freeze Panes again.

This is a subtle one because the cell you’re editing might not look any different if you haven’t typed anything yet. If you clicked into the formula bar and then immediately tried to freeze, that’s exactly the situation. Always press Enter or Escape first.

Fix 3: Unprotect the Worksheet

If the sheet is protected, the Freeze Panes command is disabled. Excel treats freezing as a structural change, and protected sheets don’t allow structural changes unless the protection explicitly permits it.

  1. Go to the Review tab.
  2. Click Unprotect Sheet. If a password was set, you’ll be prompted for it.
  3. Once unprotected, return to the View tab and apply Freeze Panes.
  4. If you need protection back, re-enable it after freezing.

Note that if the workbook is shared (legacy sharing mode), protection is often forced on, which leads to the next fix.

Fix 4: Turn Off Workbook Sharing

Excel’s legacy “Share Workbook” feature (found under Review > Share Workbook) disables Freeze Panes entirely. When a workbook is marked as shared, many features—including freezing panes, merging cells, and inserting pictures—are unavailable.

  1. Go to the Review tab.
  2. Click Share Workbook (in the Changes group).
  3. On the Editing tab, uncheck “Allow changes by more than one user at the same time.”
  4. Click OK. Excel may ask you to save the file.
  5. Apply Freeze Panes now.

Be aware that turning off sharing removes the change history and can affect co-authoring. If you’re using the modern co-authoring feature (the one that shows avatars in the top right), that doesn’t disable Freeze Panes—only the old shared workbook mode does. If you need multi-user editing, consider using Excel’s cloud co-authoring instead of the legacy share feature.

Fix 5: Select the Correct Cell Before Freezing

Sometimes Freeze Panes works, but it freezes the wrong rows or columns because the active cell is in the wrong place. The rule is simple: the frozen area is everything above and to the left of the active cell.

  • To freeze the top row only: select cell A2 (or any cell in row 2), then click Freeze Panes > Freeze Top Row.
  • To freeze the first column only: select cell B1 (or any cell in column B), then click Freeze Panes > Freeze First Column.
  • To freeze rows 1-3 and columns A-B: select cell C4, then click Freeze Panes > Freeze Panes.

The most common mistake is selecting A1 and then clicking Freeze Panes—that freezes nothing because there’s nothing above or to the left of A1. Another is selecting an entire row or column, which can cause Excel to freeze based on the whole selection rather than the active cell. Always click a single cell first.

How Freeze Panes Actually Works

Freeze Panes is a view-only feature. It doesn’t change your data, sort order, or formulas. It simply keeps certain rows and columns visible while you scroll through the rest of the sheet. The frozen area is defined by the intersection of the row above and the column to the left of your selected cell.

For example, if you select C4, Excel freezes everything from row 1 to row 3 (above C4) and everything from column A to column B (left of C4). Rows 1-3 and columns A-B stay fixed on screen while you scroll down or right. The scroll bars still work normally; the frozen region just doesn’t move.

Freeze Top Row and Freeze First Column are shortcuts that do exactly what they say, regardless of the active cell. If you use those shortcuts, you don’t need to worry about cell selection. But if you want to freeze multiple rows or columns, you must use the general Freeze Panes command with the correct active cell.

Why It Stops Working After Saving or Reopening

A common complaint is that Freeze Panes works fine during a session, but after saving and reopening the file, the frozen rows are gone or the button is grayed out. This usually happens for one of two reasons:

  • The file was saved in a format that doesn’t support freeze panes fully. For example, if you save an Excel file as a CSV or an older .xls format with compatibility issues, the freeze setting may be lost. Always save as .xlsx for full feature retention.
  • The sheet was protected or the workbook was shared after freezing. If you freeze first and then protect the sheet, the freeze stays, but if you unprotect later, it may reset. Reapplying after protection is the safest order.

If you reopen and the freeze is gone, simply reapply it. There’s no hidden setting that permanently disables it—the feature is always available unless one of the five conditions above is true.

Frequently Asked Questions

Why is Freeze Panes grayed out in Excel?

The most common reasons are Page Layout view, cell editing mode, sheet protection, or workbook sharing. Check those four in order, and you’ll almost always find the culprit.

Can I freeze both rows and columns at the same time?

Yes. Select the cell that is one row below and one column to the right of where you want the split. For example, to freeze rows 1-2 and column A, select B3, then click Freeze Panes > Freeze Panes.

Does Freeze Panes work in Excel Online or Google Sheets?

Excel Online supports Freeze Panes under View > Freeze Panes, but it only offers Freeze Top Row and Freeze First Column in the free version—custom freezing requires the desktop app. Google Sheets has a similar feature under View > Freeze, with options for rows and columns.

Why does my freeze panes reset when I filter data?

Filtering doesn’t reset freeze panes, but it can make it look like the frozen rows are gone because the row numbers change. The freeze is still active; you just need to scroll to see it. If you’re filtering and the frozen header row disappears, you may have accidentally selected a cell inside the filter range before freezing.

Can I freeze panes in the middle of a sheet, not just at the top?

No. Freeze Panes only works from the top-left corner of the sheet. You can’t freeze a section in the middle without hiding the rows above it. If you need that, consider using split panes (View > Split) instead, which allows independent scrolling of four quadrants.

Does freezing panes affect printing?

No. Freeze Panes only affects on-screen scrolling. To repeat header rows on every printed page, use Page Layout > Print Titles > Rows to repeat at top. That’s a separate setting.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →