Excel Freeze Panes Glitching? Causes and Fixes

If Excel Freeze Panes is glitching, first go to View > Freeze Panes > Unfreeze Panes, then select the correct cell and freeze again. Many apparent glitches come from a freeze boundary set in the wrong place, a different worksheet being active, or a display problem rather than damaged workbook data.

What “glitching” can mean

Freeze Panes keeps selected worksheet rows or columns visible while you scroll through the rest. When it behaves unexpectedly, the symptom often points to the cause. You might see too many rows stay put, a column move when you expect it to remain visible, a boundary in an odd location, or the sheet appear stuck while scrolling. Sometimes the pane is configured correctly but a line, zoom level, or screen refresh makes it look wrong.

It helps to distinguish a view problem from a data problem. Freeze Panes changes how a worksheet is displayed; it does not delete, rearrange, or lock the underlying cell contents. Unfreezing or changing the boundary should not alter the values in the sheet. If cells themselves have moved or disappeared, investigate other possibilities, such as hidden rows or columns, filters, or a changed sort order.

Wrong rows or columns remain visible: the active cell may have been in the wrong position when panes were frozen.
The worksheet seems split into separate scrolling areas: Split may be on instead of Freeze Panes.
A line appears in the wrong place or flickers: check the freeze boundary and then consider a screen-rendering issue.
The command is unavailable: check which worksheet is active and whether Excel is in a mode or state that prevents normal editing.

How Freeze Panes works

Excel freezes rows above the selected cell and columns to its left. For example, to keep rows 1 and 2 and columns A through C visible, select cell D3 before choosing View > Freeze Panes > Freeze Panes. Excel then leaves those two rows and three columns in place as you scroll down or to the right. The selection matters: selecting D3 is not the same as selecting C3 or D2.

The menu also includes simpler presets. Freeze Top Row keeps row 1 visible, and Freeze First Column keeps column A visible. These presets are useful for a single header row or an ID column. If you need both rows and columns, or more than one row, choose the appropriate cell and use the main Freeze Panes command.

Freeze Panes works from the top and left edges of the worksheet. It cannot keep an arbitrary row halfway down the sheet, or a column on the far right, fixed while scrolling. The frozen area is a view boundary, not a permanent division of the worksheet. You can remove it at any time with Unfreeze Panes and set a different boundary.

Reset and set the panes correctly

Resetting is a reliable first step because it removes an old boundary before you create the intended one. On Excel for Microsoft 365 for Windows, use the View tab on the ribbon. Make sure the worksheet you want to fix is active; freeze settings belong to individual worksheets, so changing one tab does not automatically correct another.

Click the worksheet tab that is showing the problem.
Choose View > Freeze Panes > Unfreeze Panes. If the menu offers Freeze Panes instead, there may not be an active freeze to remove.
Click the cell immediately below the last row you want frozen and immediately to the right of the last column you want frozen.
Choose View > Freeze Panes > Freeze Panes.
Scroll down and across to confirm that the intended headers and labels stay visible.

For example, a sales sheet has headings in row 1 and store names in column A. To keep both visible, select B2 and use Freeze Panes. To keep the first two heading rows and the first column visible, select B3. If the goal is only to preserve row 1, use Freeze Top Row; if only column A matters, use Freeze First Column.

Common causes and targeted fixes

The wrong amount is frozen. This usually reflects the cell selected when the command was applied. Unfreeze, then select the cell at the correct boundary. Remember that a selection below row 1 can freeze multiple rows, and a selection to the right of column A can freeze multiple columns.

The sheet scrolls in separate sections. Excel’s Split command divides the worksheet into independently scrollable panes. It is different from Freeze Panes, although the two features can look similar at a glance. On the View tab, check whether Split is active and turn it off if you do not want separate scrolling areas. Then set Freeze Panes again if you still need fixed headers.

The boundary seems to be far from the visible headings. A freeze line can be hard to interpret when the sheet is scrolled away from the top or left edge, or when rows or columns are hidden. Unfreeze, return to the top-left of the worksheet, and inspect hidden rows or columns before recreating the freeze. Hidden content can make the visible boundary appear inconsistent with the row or column numbers.

Only one tab is fixed. That can be normal: each worksheet has its own view settings. Repeat the setup on each tab where you need frozen headers. Also check that you are not simply looking at another sheet with different row heights, hidden columns, or a different layout.

Scrolling feels blocked. Freeze Panes does not prevent scrolling through the unfrozen part of a worksheet. Confirm that the active cell is not being edited and that the pointer is over the worksheet rather than a scroll bar or another pane. If the sheet still will not move normally, save the workbook, close and reopen it, and compare with another workbook to see whether the issue is specific to one file.

When it may be a display or workbook issue

If the frozen area is correct but its dividing line flickers, is missing, or redraws oddly, the problem may be visual. Save your work, close other resource-heavy applications, and restart Excel. Check whether the issue occurs in a new blank workbook and whether it changes when you resize the Excel window or use a different display. If it appears only in one workbook, try opening a copy of that file; if it appears across workbooks, updating Microsoft 365 and your computer’s display driver may help.

Zoom can change how much of the sheet fits on screen, but it does not change which rows and columns are frozen. A low zoom level may make the frozen region look unusually large relative to the rest of the worksheet; a high zoom level may make its boundary less obvious. Adjust the zoom control as a visual check, not as a substitute for resetting the panes.

Excel’s display can also be affected by window size, multiple monitors, or a remote desktop session. Compare the workbook at a different window size or on another display before concluding that the freeze setting itself is broken. Avoid changing unrelated workbook data or deleting rows to fix a view boundary; those actions do not repair Freeze Panes and can create new problems.

Excel for the web and Mac differences

In Excel for the web, look for the Freeze Panes controls on the View tab. The available commands and their placement can differ slightly from the Windows desktop ribbon, but the same basic rule applies: unfreeze first, select the cell at the intended boundary, and freeze again. If the web version does not show the command you need, open the workbook in the desktop app and set the panes there.

In Excel for Mac, use the View tab and its Freeze Panes controls; the ribbon layout may look different from Windows. Windows keyboard sequences should not be assumed to work on Mac, because ribbon KeyTips and shortcuts differ. Menu labels can also vary by version, so use the visible View controls rather than relying on a Windows-only key sequence.

When a workbook behaves differently between desktop and web, check whether both versions are displaying the same worksheet and the same saved file. Refresh the browser tab or close and reopen the workbook after saving changes. If a display symptom occurs in only one version, that comparison can help separate a client-specific rendering issue from a freeze setting saved with the sheet.

Freeze Panes, Split, and alternatives

Freeze Panes is usually the right choice when readers need column labels or row identifiers to remain visible during ordinary scrolling. Split is better when someone needs to view or compare two distant parts of the same worksheet at once, because each section can scroll independently. It is not a replacement for a simple fixed header, and accidentally leaving Split on is a common reason the sheet appears to scroll strangely.

For a large list, another option is to format the data as an Excel table using Home > Format as Table. Tables provide built-in filtering and can display column names in the header area as you move through table data. They do not keep arbitrary worksheet rows or columns frozen, so they solve a related navigation problem rather than replacing Freeze Panes in every case.

Choose based on how the workbook will be used:

Use Freeze Top Row for one header row that should stay visible while moving down.
Use Freeze First Column for row labels or identifiers that should stay visible while moving sideways.
Use Freeze Panes for a combination of top rows and left columns.
Use Split when independently scrolling sections are genuinely useful.
Use an Excel table when filtering and structured column headings matter more than holding a custom worksheet region in place.

Frequently Asked Questions

Why are the wrong rows frozen in Excel?
Freeze Panes uses the active cell as its boundary. Unfreeze the panes, select the cell directly below the rows and to the right of the columns you want to keep visible, and freeze again.

How do I remove Freeze Panes without changing my data?
Choose View > Freeze Panes > Unfreeze Panes. This changes the worksheet view, not the cell contents.

Why can I scroll only part of my Excel sheet?
You may have Split enabled, which creates separately scrollable sections. Check View > Split and turn it off if you want one continuous worksheet view.

Can I freeze the top two rows and the first column?
Yes. Unfreeze any existing panes, select cell B3, and choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 and column A should remain visible.

Does Freeze Panes work in Excel for the web?
Yes. Use the Freeze Panes controls on the View tab. If the command or layout differs in your browser version, open the workbook in the desktop app to set the view.

Will freezing panes change what prints?
Freeze Panes is a screen-view feature; it does not by itself repeat rows or columns on printed pages. For print headers, use the separate page-layout print-title settings.

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.