Fix Excel 365 Column Widths and Filters After Reopening
Question details
The user needs Excel 365 to retain column widths and filters after saving and reopening a workbook.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- A workbook is formatted and filtered, then saved, closed, and reopened.
- Observed behavior
- Column widths change and filters disappear from several columns, while the data remains intact.
Check whether the filter dropdowns disappear or only the selected filter criteria are cleared. Note the workbook's file type and location, and test whether another formatting change is retained after reopening.
Test a local copy and start Excel in Safe Mode
Use these tests to check whether the issue is related to the file location or an Excel add-in.
In Excel, choose File > Save As and save a copy to a local folder in Excel Workbook (.xlsx) format. Restore the column widths and filters using the column boundaries and Data > Filter, then save, close, and reopen the copy.
Change a cell's fill color from the Home tab, save the workbook, and reopen it. Check whether the fill color, column widths, and filters are retained.
Close Excel, press Windows+R, enter excel /safe, and select OK. Open the local copy, restore the widths and filters, then save, close, and reopen it to test again.
In normal Excel on Windows, go to File > Options > Add-ins. Select COM Add-ins in the Manage box and click Go, then disable add-ins one at a time and repeat the save-and-reopen test.
Move the affected sheets or data to a new workbook
Use a new workbook to test whether the original file is causing the issue.
Repair the workbook or gather details for further investigation
Use this option if the problem appears limited to the original workbook or persists after testing.
Work with column widths and filters in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to work with column widths and filters while keeping your existing files accessible for migration.

Frequently Asked Questions
How can I tell whether the issue affects only one workbook?
Create a blank workbook with File > New, enter sample data, adjust a column width, and apply Data > Filter. Save, close, and reopen it to see whether those settings remain.
How do I start Excel in Safe Mode?
On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Open the workbook and repeat the save-and-reopen test.
What should I check about the missing filters?
After reopening, check whether the filter dropdown arrows are gone or whether the arrows remain but the selected criteria have cleared. Use Data > Filter to reapply the filter before testing again.
Where can I find my Excel version for troubleshooting?
In Excel, open File > Account and look under Product Information for the Office product and version details.




