File Format & Compatibility

Fix Excel Column Widths Changing After Reopening XLS Files

Maira MehtabMaira Mehtab Nov 20, 2026 869 views

Question details

The user needs Excel column widths to remain consistent after saving and reopening a legacy XLS workbook.

Fix Excel Column Widths Changing After Reopening XLS Files
Product
Microsoft Excel
Device & OS
not provided
Scenario
A legacy XLS workbook is saved and reopened in Excel.
Observed behavior
Some columns reopen narrower even though their widths were not intentionally changed.
Before you start

Check the Excel version using File > Account > About Excel, if available, and test in the latest supported version. Note which columns change and whether the issue occurs in one workbook or several.

Solution 1Recommended

Test the workbook in XLSX format

Use this test to see whether the legacy XLS format contributes to the width changes.

1
Save a test copy

Open the affected workbook in Excel, select File > Save As, and save a copy as Excel Workbook (*.xlsx).

2
Set the column widths

Select the affected columns, then use Home > Format > Column Width to enter the desired widths. Save the copy.

3
Reopen and compare

Close and reopen the XLSX copy in Excel. Check whether the same columns retain their widths, then compare the result with the original XLS file.

Test the workbook in XLSX format
Check workbook features: XLSX does not retain VBA macros. If the workbook contains macros, use Excel Macro-Enabled Workbook (*.xlsm) for the test and verify that its features still work.
Free Microsoft Office alternative

Work with XLS and XLSX files in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move between applications. It does not repair the underlying Excel issue.

Open and edit Microsoft Excel XLS and XLSX filesAdjust spreadsheet column widths in a familiar interfaceMove existing spreadsheets into a lightweight Office suiteUse core spreadsheet tools for free
microsoft office alternative - wps office

Frequently Asked Questions

Why do my XLS columns reopen narrower?

Legacy format compatibility, workbook damage, or differences in how an application renders the file may affect column widths. Save a test copy as XLSX and reopen it to check whether the format makes a difference.

How can I set an exact column width in Excel?

Select the columns, then choose Home > Format > Column Width and enter a value. Save, close, and reopen the workbook to see whether the setting persists.

Will saving an XLS file as XLSX keep its macros?

No. XLSX does not retain VBA macros. Use File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm) if the workbook contains macros, then check that they work.

What should I send support if the issue continues?

Provide a sample workbook through a private support channel, the steps needed to reproduce the issue, and the Excel version shown under File > Account > About Excel, if available.