File Format & Compatibility

Fix Excel Column Widths Changing After Saving an XLSX File

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 869 views

Question details

The user needs Excel to retain exact column widths when an older workbook is saved and reopened.

Fix Excel Column Widths Changing After Saving an XLSX File
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.
Before you start

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.

Solution 1Recommended

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.

1
Record the width

Select an affected column, then choose Home > Format > Column Width and note the displayed value.

2
Save and reopen

Choose File > Save, close the workbook, and reopen it. Select the same column and check Home > Format > Column Width again.

3
Check for updates

Go to File > Account > Update Options > Update Now if that option is available, then repeat the save-and-reopen test.

Check the column widths and test after an Excel update
Check the workbook font: Column widths are related to the workbook's default font. If the numeric width is unchanged but the layout looks different, check whether the workbook's fonts are available on the computer.
Free Microsoft Office alternative

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.

Adjust spreadsheet column widths in a familiar interfaceOpen and save Microsoft Excel XLS and XLSX formatsUse a free, lightweight office suiteMove existing spreadsheet content into an easy-to-use workspace
microsoft office alternative - wps office

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.