How to Unfreeze Panes in Excel? 5 Best Fixes That Stop Frozen Row Errors

Learning how to unfreeze panes in excel takes less than ten seconds once you know the right menu. A frozen pane locks rows or columns in place while the rest of the sheet scrolls, and unfreezing it sets the whole sheet free again. This guide gives you five fixes and stops the greyed-out errors that block the menu.

Microsoft Excel is the spreadsheet app from Microsoft, and it is part of Microsoft 365.

To unfreeze panes in Excel, click the View tab, click Freeze Panes, and choose Unfreeze Panes. The frozen rows and columns start scrolling again at once, and the whole sheet moves as one unit. If the option is greyed out, nothing is frozen on that sheet, or the sheet is protected, or you are in Page Layout view.

ANSWER BOX 1

To unfreeze panes in Excel, open the workbook and click the sheet with the frozen rows. Click the View tab at the top, then click Freeze Panes in the Window group. Choose Unfreeze Panes from the menu, and the freeze clears at once.

ANSWER BOX 2

Unfreezing panes in Excel removes the lock from every frozen row and column on that sheet at the same time. There is no way to unfreeze only the top row, so you clear all of it and then freeze again. That two-step reset is the fastest fix when the wrong rows are locked.

KEY TAKEAWAYS

  • Start on the View tab, under Freeze Panes, then Unfreeze Panes.
  • Unfreezing clears every frozen row and column in one move.
  • A greyed-out button usually means nothing is frozen, or the sheet is protected.
  • On Windows, press Alt, then W, then F, then U, one key after the other.
  • After you unfreeze, re-freeze only the part you want.

Contents

  • What does unfreezing panes in Excel do?
  • How to tell which panes are frozen in Excel
  • How to unfreeze panes in Excel in 5 best fixes
  • How to unfreeze panes in Excel on Mac
  • How to unfreeze panes in Excel for the web
  • Unfreeze Panes greyed out: 5 frozen row errors and how to stop them
  • How to re-freeze only the part you want after unfreezing
  • FAQ

What Does Unfreezing Panes in Excel Do?

Unfreezing panes in Excel removes the lock that holds rows or columns still while you scroll. When panes are frozen, the rows above a line and the columns to the left of a line stay on screen. When you unfreeze, that line goes away, and the whole sheet scrolls as one plain grid again. Nothing in your data changes, because it only changes the view.

A frozen pane is a view setting, not a part of your data. It does not hide rows, it does not lock cells, and it does not stop anyone from editing the sheet. An Excel worksheet holds up to 1,048,576 rows by 16,384 columns, so long sheets are common. Microsoft Excel was first released for the Macintosh in 1985, and the Windows version followed in 1987.

How to Tell Which Panes Are Frozen in Excel

Before you unfreeze anything, check which rows and columns are actually frozen. The fastest sign is the freeze line itself, which is a thin dark line across the sheet. Scroll down slowly and watch the rows at the top, because the rows that never move are the frozen ones. Then scroll right and watch the columns on the left.

The menu gives you a second check that never lies. Click the View tab, then click Freeze Panes, and read the first item in the menu. If it says Unfreeze Panes, then something on this sheet is frozen right now. If it says Freeze Panes instead, then nothing is frozen, and you are on the wrong sheet tab. A split window can look like a freeze, so check the Split button first.

The Excel View tab ribbon used in how to unfreeze panes in Excel

How to Unfreeze Panes in Excel in 5 Best Fixes

These five fixes cover every common case, from a single sheet to a whole workbook. Start with Fix 1, because it works in nearly every case.

Fix 1: Use the View tab menu. Click the sheet with the frozen rows, then click the View tab at the top of the Excel window. Find the Freeze Panes button in the Window group and click its small arrow. Choose Unfreeze Panes from the menu that opens, and the freeze clears at once.

Fix 2: Use the keyboard shortcut on Windows. Press Alt, then W, then F, then U, one key after the other, and do not hold them down together. Alt opens the ribbon keys, W opens the View tab, F opens the menu, and U picks Unfreeze Panes. The freeze clears the moment you press U.

Fix 3: Add Unfreeze Panes to the Quick Access Toolbar. Click the small arrow at the end of the Quick Access Toolbar and choose More Commands. Find Unfreeze Panes in the list on the left, click Add, and then click OK. The button now sits at the top of the window, and one click clears the freeze.

Fix 4: Use VBA to unfreeze every sheet in the workbook. This fix is the best one when a workbook has many sheets and each one is frozen. Press Alt plus F11 to open the Visual Basic Editor, then click Insert and choose Module. Paste this short macro into the module, press F5 to run it, and close the editor. The macro sets FreezePanes to False on every sheet, so save the workbook after you run it.

Sub UnfreezeAllSheets()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
        ws.Activate
        ActiveWindow.FreezePanes = False
    Next ws
End Sub

Fix 5: Unfreeze, then re-freeze the right area. This fix is for the case where the wrong rows are frozen, which is the most common frozen row error of all. First unfreeze everything with Fix 1, so the sheet is fully free and the old boundary is gone. Then click the cell just below the last row you want to keep and just to the right of the last column you want to keep. Open the View tab, click Freeze Panes, and choose Freeze Panes to lock the new boundary. Scroll to test it, and read our guide on how to freeze top row in excel for the simplest case.

How to Unfreeze Panes in Excel on Mac

The Mac path is nearly the same as the Windows path. Click the sheet with the frozen rows, then click the View tab at the top of the Excel window. Look for the Freeze Panes button in the ribbon, click it, and choose Unfreeze Panes. The freeze clears at once, and the sheet scrolls freely again.

There is no built-in Mac shortcut for Unfreeze Panes, because the Alt key shortcuts from Windows do not work there. Use the View tab menu, or add the button to the Quick Access Toolbar. Freeze commands only work in Normal view on a Mac, so click the View tab, then click Normal, and try the menu again.

How to Unfreeze Panes in Excel for the Web

Excel for the web is the free browser version in Microsoft 365, and its menu is slightly different. Open the workbook in your browser and click the sheet with the frozen rows. Click the View tab at the top, then click Freeze Panes, and choose Unfreeze Panes. The freeze clears at once, and the change saves to OneDrive on its own.

The web menu offers Freeze at selection instead of the full Freeze Panes choice in some cases. Pick the cell below and to the right of the area you want to keep, then use Freeze at selection. Wait for the sheet to finish loading, then try the menu again.

Unfreeze Panes Greyed Out: 5 Frozen Row Errors and How to Stop Them

A greyed-out Unfreeze Panes button is the most common error in this whole topic. Work through the five errors below in order, because the first one explains most cases.

ErrorWhat you seeCauseFix
Nothing is frozenMenu item missingNo freeze on this sheetCheck the menu and the sheet tab
Page Layout viewFreeze Panes greyed outWrong view modeClick View, then Normal
Cell being editedMost buttons greyed outCursor inside a cellPress Enter or Esc
Protected sheetFreeze Panes greyed outSheet is protectedReview, then Unprotect Sheet
Protected ViewWhole ribbon lockedFile from email or webClick Enable Editing

Error 1: Nothing is actually frozen. This is the most common cause, and it is not a fault at all. The Unfreeze Panes item only appears when a freeze is active, so a greyed-out button means the sheet is already free. Check you are on the right sheet tab.

Error 2: You are in Page Layout view. Freeze Panes only works in Normal view, so Page Layout view and Page Break Preview both grey out the command. Click the View tab, then click Normal, and the button should turn active again. Our guide on freeze panes in excel not working covers this error in full.

Error 3: You are still editing a cell. When the cursor blinks inside a cell or in the formula bar, Excel locks most ribbon commands. Press Enter to confirm the entry, or press Esc to cancel it, and then open the View tab again.

Error 4: The sheet is protected. A protected sheet can block changes to the window layout. Click the Review tab, and click Unprotect Sheet when it shows there. Type the password when you have it, then try the menu again.

Error 5: The file opened in Protected View. Files from email or download often open in Protected View, with a yellow bar that says Enable Editing. Click Enable Editing on the yellow bar, then try the View tab menu again.

How to Re-Freeze Only the Part You Want After Unfreezing

Unfreezing is only half the job when you still need a header row or a label column to stay visible. The trick is to pick the right cell before you freeze again, because Excel freezes everything above and to the left of the cell you pick. Pick the wrong cell and the wrong rows freeze.

A laptop spreadsheet and notepad while learning how to unfreeze panes in Excel

Follow this checklist after every unfreeze. First, scroll to the top and look at the headers you need. Second, click the cell just below the last header row and just to the right of the last label column. Third, open the View tab and pick the freeze choice that matches your need. Fourth, scroll to test the result. Fifth, save the file.

Freeze Top Row locks row 1 only, and it suits a plain list with one header row. Freeze First Column locks column A only, and it suits a wide table with row labels. Freeze Panes locks everything above and to the left of your picked cell, for both at once. Our guide on how to freeze first column in excel walks through the column case step by step.

How to Unfreeze Panes in Excel FAQ

How do I unfreeze panes in Excel on Windows?

Click the View tab, then click Freeze Panes, then choose Unfreeze Panes. The freeze clears at once.

How do I unfreeze panes in Excel on a Mac?

Click the View tab, then click Freeze Panes, then choose Unfreeze Panes. Make sure you are in Normal view first.

Why is Unfreeze Panes greyed out in Excel?

It is usually greyed out because nothing is frozen on that sheet, or because you are in Page Layout view. It can also mean you are still editing a cell, or the sheet is protected.

How do I unfreeze only the top row in Excel?

You cannot unfreeze only the top row, because Unfreeze Panes clears every frozen row and column at once. Unfreeze everything first, then freeze again with the part you want.

How do I unfreeze panes in Excel with a keyboard shortcut?

On Windows, press Alt, then W, then F, then U, one key after the other. The freeze clears the moment you press U.

How do I unfreeze panes in Excel for the web?

Open the workbook in your browser, click the View tab, then click Freeze Panes and choose Unfreeze Panes. The change saves to OneDrive on its own.

How do I unfreeze panes in all sheets at once?

Use the VBA macro in Fix 4 for all sheets at once. Press Alt plus F11, paste it into a module, and press F5 to run it.

How do I know which panes are frozen in Excel?

Scroll down and watch which rows stay still, then scroll right and watch which columns stay still.

Does unfreezing panes delete my data in Excel?

No, unfreezing panes never deletes data, because it only changes the view of the sheet.

Why do my panes freeze again after I unfreeze them?

A freeze setting is saved with the workbook, so it comes back when you reopen a file that was saved while frozen. Unfreeze the panes and then save the file.

What is the difference between Freeze Panes and Split in Excel?

Freeze Panes locks rows or columns in place while the rest scrolls, and Split divides the window into parts that scroll on their own.

How do I stop Excel from freezing panes when I open a file?

Unfreeze the panes and then save the file, because the freeze setting travels with the workbook. If the file comes from someone else, unfreeze it once and save your own copy.

Final Word

Learning how to unfreeze panes in excel is a ten-second skill, and it fixes one of the most annoying views in Excel. Click the View tab, open Freeze Panes, and choose Unfreeze Panes, and the whole sheet scrolls freely again. When the button is greyed out, check the view, the cell, and the protection. Microsoft reported 80.8 million Microsoft 365 Consumer subscribers in early 2024, so this small skill helps a huge crowd.

Unfreeze first, then freeze again with the right cell picked, and the same frozen row error will not come back. Our pillar guide on how to freeze panes in excel shows you how to lock only the rows and columns you truly need.

Read more about Microsoft Excel on Wikipedia: https://en.wikipedia.org/wiki/Microsoft_Excel

Leave a Reply