Fix Excel Freeze Panes Moving After Filtering or Reopening
Question details
Keep Freeze Panes at the intended position when filtering or reopening a shared Excel workbook.

- 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.
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.
Clear Filters and Reapply Freeze Panes in Excel
Use this method to reset the freeze boundary and save it at the intended cell.
On the Data tab, select Clear in the Sort & Filter group to show the filtered rows.
On the View tab, select Freeze Panes, then select Unfreeze Panes.
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.
Select View > Freeze Panes > Freeze Panes, then select File > Save. Close and reopen the workbook to check the position.

Use OneDrive and Excel Co-Authoring for Collaboration
Consider modern co-authoring when legacy sharing or a large workbook makes collaboration difficult.
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.

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.




