Freeze Panes not working in Excel: how to fix it

Quick answer: Open View > Freeze Panes and choose Unfreeze Panes to clear any old setting. Scroll to the top of the sheet, click the cell just below the last row and just right of the last column you want to keep in view, then choose View > Freeze Panes > Freeze Panes again. If the button can’t be clicked, switch to View > Normal (Page Layout view turns the feature off) and press Esc in case a cell is still being edited.

Applies to: Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows, and Excel for the web, which are the versions Microsoft lists for its Freeze Panes article. Menu names can differ slightly on a Mac. If the whole sheet refuses to scroll rather than just the header, the problem may be Scroll Lock instead; see Excel arrow keys not working.

How Freeze Panes decides what to lock

Many Freeze Panes problems come from one rule in Microsoft’s documentation: the command freezes the rows above and the columns to the left of the cell you have selected. It doesn’t freeze the selected cell itself, and it doesn’t look at where your headers are. So the result depends entirely on which cell is active when you click the button.

  • Select B2 and you lock row 1 and column A.
  • Select A2 and you lock row 1 only.
  • Select C1 (or the whole of column C) and you lock columns A and B only.
  • Select A1 and there is nothing above or to the left of it, so nothing useful gets locked.

The same menu also has Freeze Top Row and Freeze First Column. They ignore the selection and appear to lock whatever row or column is at the top or left edge of the window at that moment, so it’s safer to scroll to the top before using them.

Freeze rows and columns the right way

Start clean so an older freeze doesn’t get in the way:

  1. Go to View > Freeze Panes. If the menu shows Unfreeze Panes, select it. A sheet can only have one frozen area, so clearing the old one first makes the result predictable.
  2. Press Ctrl + Home to jump back to the top-left of the sheet, so rows you want to lock aren’t scrolled out of sight.
  3. Click the first cell below the header rows and to the right of the columns you want to keep visible. For a header in row 1 and names in column A, that’s B2.
  4. Go to View > Freeze Panes > Freeze Panes.
  5. Scroll down and right to confirm that the header row and the first column stay in place. A thin line marks the edge of the frozen area.

To lock only columns, Microsoft’s example is to select the column to the right of them: to keep the first two columns, select column C and choose Freeze Panes.

Freeze Panes can’t be selected

When the button is dim and does nothing, Excel is in a state where it won’t change the window layout. Work through these in order.

Switch out of Page Layout view

In a Microsoft Tech Community answer marked as the solution, a community expert notes that in Excel for Windows, Freeze Panes is disabled while the sheet is in Page Layout view. Page Layout view shows the sheet as printed pages with margins and rulers, so it’s easy to land in it by accident from the status bar. Select View > Normal, or the Normal icon at the bottom right of the window, and try again. Page Break Preview may also allow freezing, but Normal is the safest view to use.

Finish editing the current cell

While you are typing in a cell or in the formula bar, Excel holds back many ribbon commands until the edit is done. If the status bar at the bottom left says Edit or Enter, press Enter to keep what you typed or Esc to cancel it, then open the menu again.

Check sheet and workbook protection

Protection can lock more than cell contents. On the Review tab, look at Unprotect Sheet and Protect Workbook. If the sheet or workbook is protected, remove the protection (you will need the password if one was set), freeze the panes, then protect it again. Some older workbooks protect the window layout itself, and that setting may keep Freeze Panes unavailable until the workbook is unprotected. On a shared or company file, ask the owner before you remove protection. If the file opens read-only or is locked by someone else, see Excel file is locked for editing by another user.

Ungroup selected sheets

If the title bar shows [Group], several sheet tabs are selected at once, and Excel can limit some commands in that state. Right-click a sheet tab and choose Ungroup Sheets, then freeze panes on the one sheet you need.

No View tab at all

Microsoft’s page says that if you don’t see the View tab, you may be using Excel Starter, which doesn’t include every feature. In that case Freeze Panes isn’t available, and a full version of Excel is needed.

The wrong rows or columns stay put

If something freezes but it isn’t what you wanted, the selection or the scroll position was off when you clicked the button.

  • Too much is frozen. The active cell was further down or right than you meant, so Excel locked every row above it and every column to its left. Unfreeze, select the correct cell and freeze again.
  • The header row is missing from the frozen area. If the sheet was scrolled down, rows above the visible window can end up hidden behind the frozen line, and you can’t scroll back up to them. Unfreeze, press Ctrl + Home, then freeze.
  • Freeze Top Row locked the wrong row. It can lock whichever row is showing at the top of the window rather than row 1. Scroll to the top first, or use Freeze Panes with a selected cell instead.
  • Only rows freeze, not columns. The selected cell was in column A. Pick a cell in the column to the right of the ones you want to lock.

Other things to check

Split is turned on. Split divides the window into separate scrollable areas, which Microsoft treats as a different feature from Freeze Panes. If you see gray bars that you can drag, or each part of the window scrolls on its own, select View > Split to turn it off, then freeze panes again. Using both at once can give confusing results.

Your data is in an Excel table. When the active cell is inside a table and you scroll down, Excel may show the table’s column names in place of the column letters A, B, C. That keeps headers in view without Freeze Panes, but only while a cell inside the table is selected. If you want the header row locked no matter where you click, freeze the panes as well. For tables whose filters misbehave, see Excel filter not working.

Excel for the web. Microsoft lists Excel for the web among the versions its Freeze Panes article applies to, and the command sits on the View tab there too. The web version can offer fewer view options than the desktop app, so if a freeze set in the browser looks different, open the file in the desktop app and set it there. The frozen area should be saved with the workbook.

The scroll bars are gone or Excel stops responding. Missing scroll bars are a separate option; see Excel scroll bar missing. If the whole window freezes in the other sense, with Excel hanging, see Excel not responding.

Quick troubleshooting table

What you seePossible causeWhat to try
Freeze Panes can’t be clickedThe sheet is in Page Layout viewView > Normal, then freeze again
Most ribbon buttons are dimA cell is still being editedPress Enter or Esc
Freeze Panes stays dim in Normal viewThe sheet or workbook is protected, or several sheets are groupedUnprotect on the Review tab, or ungroup the sheet tabs
Header row isn’t lockedThe wrong cell was selected, or the sheet was scrolled downUnfreeze, press Ctrl + Home, select the cell below the header, freeze
Window scrolls in separate partsSplit is onView > Split to turn it off
No View tabExcel StarterUse a full version of Excel

Sources

How we write our guides: read our editorial policy.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *