Office Settings & Configuration

Fix Excel Freeze Panes Moving After Filtering or Reopening

Amos GikundaAmos Gikunda Nov 20, 2026 869 views

Question details

Keep Freeze Panes at the intended position when filtering or reopening a shared Excel workbook.

Fix Excel Freeze Panes Moving After Filtering or Reopening
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user filters a shared workbook and wants it to reopen with rows and columns frozen at a specific cell.
Observed behavior
The workbook may reopen with Freeze Panes positioned at the last filtered row rather than the intended cell.
Before you start

Open the workbook in desktop Excel and identify the cell below the rows and to the right of the columns you want to keep visible. Check whether filters are active and whether other people are currently editing the file.

Solution 1Recommended

Clear Filters and Reapply Freeze Panes in Excel

Use this method to reset the freeze boundary and save it at the intended cell.

1
Clear active filters

On the Data tab, select Clear in the Sort & Filter group to show the filtered rows.

2
Remove the current freeze

On the View tab, select Freeze Panes, then select Unfreeze Panes.

3
Set the intended boundary

Select the cell below the rows and to the right of the columns you want to freeze. For example, select G3 to freeze rows 1–2 and columns A–F.

4
Freeze and save

Select View > Freeze Panes > Freeze Panes, then select File > Save. Close and reopen the workbook to check the position.

Clear Filters and Reapply Freeze Panes in Excel
If the position moves again: Repeat the reset after clearing filters. If the workbook uses legacy sharing, consider testing modern co-authoring in a copy.
Free Microsoft Office alternative

Work With Frozen Rows and Columns in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheets and use its Freeze Panes tools when working with large tables. WPS does not repair Excel's own freeze or co-authoring behavior.

Freeze rows and columns while reviewing spreadsheet dataCompatible with Microsoft Excel formats including .xlsxFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

What does selecting G3 before freezing panes do?

Selecting G3 and choosing View > Freeze Panes > Freeze Panes keeps rows 1–2 and columns A–F visible while you scroll.

Should I clear filters before resetting Freeze Panes?

Yes. Select Data > Clear to show the filtered rows, then unfreeze and reapply Freeze Panes at the intended cell before saving.

How can I collaborate without legacy sharing?

Save a supported workbook format such as .xlsx to OneDrive using File > Save As, then select Share to invite others to the OneDrive copy. Make sure collaborators use Excel versions that support co-authoring.

What if my workbook is too large for Excel for the web?

Open the workbook in the desktop Excel app and test it there. Large files may work better in desktop Excel than in the web version.