Fix Excel Column Widths Changing After Reopening XLS Files
Question details
The user needs Excel column widths to remain consistent after saving and reopening a legacy XLS workbook.

- 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.
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.
Test the workbook in XLSX format
Use this test to see whether the legacy XLS format contributes to the width changes.
Open the affected workbook in Excel, select File > Save As, and save a copy as Excel Workbook (*.xlsx).
Select the affected columns, then use Home > Format > Column Width to enter the desired widths. Save the copy.
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.

Check the workbook for formatting or file damage
Use these checks if column widths still change or the problem appears specific to one workbook.
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.

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.




