Formatting Issues

Fix Excel 365 Column Widths and Filters After Reopening

Khadija KhanKhadija Khan Nov 20, 2026 869 views

Question details

The user needs Excel 365 to retain column widths and filters after saving and reopening a workbook.

Fix Excel 365 Column Widths and Filters After Reopening
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.
Before you start

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.

Solution 1Recommended

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.

1
Save a local copy

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.

2
Test another formatting change

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.

3
Start Safe Mode on Windows

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.

4
Check add-ins if Safe Mode helps

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.

Safe Mode availability: The excel /safe command is for Excel on Windows. If you use another operating system, start with the local-copy and new-workbook tests instead.
Free Microsoft Office alternative

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.

Adjust column widths and filter spreadsheet dataOpen and save compatible Microsoft Excel .xlsx filesUse a familiar interface for everyday spreadsheet tasksGet a free, lightweight Office alternative
microsoft office alternative - wps office

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.