How to Disable Freeze Panes in Excel on a Worksheet

How-to basics · Updated November 20, 2026

To disable frozen rows or columns in Excel for Microsoft 365 on Windows, open the worksheet, select the View tab, choose Freeze Panes, then select Unfreeze Panes. This removes the freeze setting from the active worksheet so its rows and columns can scroll normally. You do not need to select a particular cell first.

What You’ll Need

  • An Excel workbook with the worksheet where panes are frozen.
  • Permission to make changes to the workbook. If it is read-only, save or download an editable copy first.
  • A supported version of Excel. The steps below are for Microsoft 365 on Windows; Mac and Excel for the web have similar commands, with notes below.

You do not need to know which row or column was frozen, and there is no special add-in or formula involved. Freeze panes is a worksheet view setting, so you can remove it without deleting, moving, or changing the cell contents.

Step-by-Step

  1. Open the worksheet with the frozen area. Open the workbook and click the sheet tab where scrolling is behaving unexpectedly. Freeze settings are applied to individual worksheets, so make sure you are on the sheet you want to change. If the workbook has several sheets with frozen rows or columns, plan to repeat these steps on each one.
  2. Open the View tab. On the Excel ribbon, select View. Find the Freeze Panes command, usually in the Window group. If the ribbon is minimized, click or tap the View tab to expand it. In a narrow Excel window, the command may be inside a condensed group or overflow menu; widen the window if you cannot see it.
  3. Open the Freeze Panes menu. Select the arrow or dropdown beside Freeze Panes. The menu includes commands for freezing panes, the top row, or the first column, as well as an option to undo an existing freeze. Do not choose another freeze command: those options replace or set a freeze rather than remove it.
  4. Select Unfreeze Panes. Click Unfreeze Panes in the dropdown. Excel removes the frozen boundary from the active sheet. The command may be unavailable or replaced by another label when no panes are frozen, so check the sheet by scrolling and inspect the menu again if needed.
  5. Check that the sheet scrolls as expected. Scroll down and across the worksheet. Rows that were held at the top and columns that were held at the left should now move with the rest of the sheet. If only one kind of area appears to remain fixed, check whether a split window is active, as described in Troubleshooting.
  6. Repeat on other worksheets if necessary. Click another sheet tab and look for its own frozen rows or columns. Choose View > Freeze Panes > Unfreeze Panes on each sheet that needs it. Removing the freeze on one sheet does not automatically remove freezes from the rest of the workbook.
  7. Save the workbook. Press Ctrl+S on Windows or choose File > Save. This preserves the updated view setting in the workbook. If Excel asks you to save a copy because the file is read-only or stored in a protected location, choose a location where you have permission to save.

On Mac: Select View on the ribbon, open Freeze Panes, and choose Unfreeze Panes. The wording and ribbon layout can vary slightly by Excel version, but look for the same command in the View tab. The Windows shortcut Ctrl+S is Command+S on Mac for saving; there is no need for a keyboard shortcut to unfreeze panes.

In Excel for the web: Open the sheet, select View, then open Freeze Panes and choose Unfreeze Panes if it is available. The browser ribbon can place the menu differently from desktop Excel. If you do not see the command, open the workbook in the desktop app and use the Windows or Mac steps above.

Common Mistakes

Choosing Freeze Top Row or Freeze First Column instead. These menu options create a new freeze; they do not clear one. To remove the current setting, choose the explicit Unfreeze Panes command. If you accidentally freeze a different area, reopen the menu and select Unfreeze Panes before trying anything else.

Expecting one action to change every sheet. A workbook can have different view settings on different worksheets. Unfreezing one tab leaves other tabs unchanged. Check the sheets individually, especially in workbooks with separate dashboards, data tables, or print-preparation sheets.

Confusing a freeze boundary with gridlines or cell borders. Freeze panes controls which rows or columns stay visible while you scroll; it does not remove worksheet gridlines, cell borders, or table formatting. Those lines may remain after a successful unfreeze. Confirm the result by scrolling rather than judging only by the appearance of a line on the screen.

Clicking a cell and expecting that to undo the freeze. The selected cell does not switch the feature off. The active selection matters when creating a new freeze, but removing a freeze is done through the View tab menu. No cell selection or range deletion is required.

Closing without saving. If you close the workbook without saving changes, the unfreeze action may not be retained in the file. Save after changing the view, and check that you are saving the correct workbook if multiple copies are open.

Tips

Before changing the view, note what was staying fixed: the top row, the first column, or both. This helps you verify the change afterward and distinguish a frozen area from a split window. If the workbook is shared with coworkers, consider telling them that the worksheet view will no longer keep its headings visible while scrolling.

Unfreezing panes does not delete content or change the order of rows and columns. It only changes how the sheet behaves during scrolling. If you later decide that headings should remain visible, select the cell just below and to the right of the area you want to keep fixed, then use View > Freeze Panes > Freeze Panes. For a simple heading row, use Freeze Top Row; for a simple leading column, use Freeze First Column.

When reviewing a large workbook, check the view setting on each relevant sheet instead of assuming they match. Also consider whether removing the freeze will make the sheet harder to navigate: a long data list may be easier to read when its header row remains visible. If you only need a temporary view change, you can still unfreeze and later set the freeze again.

Use the desktop app when the browser interface does not show the expected command or when the workbook opens in a limited editing mode. For files stored online, check that your changes have finished saving before closing the browser tab. In desktop Excel, look for a save indicator or use Ctrl+S on Windows and Command+S on Mac.

Troubleshooting

Unfreeze Panes is missing or unavailable. First confirm that you opened the Freeze Panes dropdown on the correct worksheet. If the menu offers only freeze options, there may not be a freeze active on that sheet. Scroll the sheet to test it, and check other worksheet tabs. In a compact ribbon, widen the Excel window or open the relevant overflow menu.

A line or divider remains after unfreezing. The remaining divider may be a split pane rather than a freeze boundary. In desktop Excel, select View > Split to turn off an active split. A split creates separate scrollable sections, while freezing keeps part of the sheet stationary. If the line is a cell border or gridline, it is formatting or a display option, not a frozen pane.

Rows still seem fixed when you scroll. Check that you used the vertical scrollbar or mouse wheel and that you are not looking at a different worksheet. If the sheet has a split, turn it off as above. If the command was applied but the workbook was not saved, save it and reopen the workbook to confirm the setting persisted.

You cannot make or save the change. If the workbook is read-only, opened as an email attachment, or stored somewhere you cannot edit, use File > Save As to create an editable copy, if permitted. If Excel displays a protected-view or access message, follow the organization or file owner’s instructions rather than trying to bypass security controls.

The web version does not show the same menu. Excel for the web can arrange ribbon commands differently, and some workbooks open with limited permissions. Check the View tab and its dropdowns. If Unfreeze Panes is not available, select Open in Desktop App when offered, then use the desktop steps. Your organization may restrict editing, so confirm access if the command remains unavailable.

Frequently Asked Questions

Does unfreezing panes delete or change worksheet data?
No. It changes the scrolling view only. Values, formulas, formatting, and the positions of cells remain as they were.

Can I unfreeze only the top row but keep the first column frozen?
The Unfreeze Panes command clears the existing freeze arrangement on that worksheet. To keep one area fixed, unfreeze first, then apply the freeze setup you want. For example, use Freeze First Column to keep just the first column visible.

Why are the headings no longer visible after I unfreeze?
That is expected: unfreezing lets all rows scroll. To restore a fixed heading, select Freeze Top Row from View > Freeze Panes, or create a custom freeze using the appropriate cell selection.

Do I need to repeat the steps for every sheet?
Yes, if multiple worksheets have frozen areas. The command changes the active worksheet, so visit each affected sheet and unfreeze it separately.

Will the unfreeze setting remain after I close Excel?
It should remain when you save the workbook after making the change. If you do not save, the workbook may reopen with its previously saved view. Shared or read-only files may require saving an editable copy.

Is there a keyboard shortcut to unfreeze panes?
There is no standard single keyboard shortcut for Unfreeze Panes in Excel for Windows. Use the View tab menu. You can use Ctrl+S to save on Windows or Command+S on Mac after changing the setting.

Related

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.