Fix Excel Column Widths Changing After Saving an XLSX File
Question details
The user needs Excel to retain exact column widths when an older workbook is saved and reopened.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- An older workbook with layout-sensitive column dimensions is saved and reopened in Excel.
- Observed behavior
- Some column widths become smaller after the workbook is reopened.
Check the workbook's file extension and note the width of an affected column before saving. In Excel, select the column and choose Home > Format > Column Width to see its current value.
Check the column widths and test after an Excel update
Use this check to confirm the width change and rule out an outdated Excel installation.
Select an affected column, then choose Home > Format > Column Width and note the displayed value.
Choose File > Save, close the workbook, and reopen it. Select the same column and check Home > Format > Column Width again.
Go to File > Account > Update Options > Update Now if that option is available, then repeat the save-and-reopen test.

Convert an older XLS workbook to XLSX
Use this option if the source workbook is still in the older XLS format; conversion may prevent format-related width changes.
Test the content in a new Excel workbook
Use a new workbook to check whether the behavior is specific to the original file.
Open and edit spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks and review their layouts as you move between office suites. It does not fix Excel itself, so verify important column widths after saving and reopening.

Frequently Asked Questions
How can I check whether a column width actually changed?
Select the column and choose Home > Format > Column Width. Record the value before saving, then compare it with the value after reopening the workbook.
Will saving an XLSX file as XLSX again fix the problem?
Not necessarily. The XLS-to-XLSX conversion applies to older XLS files. If your file is already XLSX, try updating Excel and testing the content in a new workbook.
Why does the column look narrower when its width value is unchanged?
Column width is related to the workbook's default font, so a missing or substituted font can affect the apparent layout. Check that the fonts used by the workbook are available on the computer.
What does a new workbook test tell me?
If the copied content retains its widths after you save and reopen a new blank workbook, the behavior may be specific to the original file. Check the new workbook's formulas and other features before relying on it.




