Formatting Issues

Fix Excel Not Retaining Column Width After Reopening

John Wilson Sep 25, 2026 871 views

Question details

The user needs to ensure that specific column widths in an Excel spreadsheet remain fixed and do not reset to default narrow widths after the file is saved and reopened.

How to Fix Excel Not Retaining Column Widths After Reopening

Product: Excel
Device & OS: not provided
Scenario: Customizing and saving a workbook layout with specific column dimensions for better data readability.
Observed behavior: Column widths revert to a narrower size after closing and reopening the file, even if AutoFit was previously applied to reveal the content.

Before you start

Ensure your workbook is not being saved in a plain text format like CSV, as this file type strips away all visual formatting, including customized column widths.

Solution 1Recommended

Set and Save Fixed Column Widths Manually

Applying a specific numerical column width rather than relying entirely on dynamic features like AutoFit ensures the exact dimensions are written into the file's formatting data.

While AutoFit is convenient for quickly viewing data, it sometimes fails to persist as a permanent column setting when reopening a workbook. Defining an explicit numerical width forces the software to remember the exact size.

Select the Target Columns

Click and drag across the column headers (e.g., A through C) to highlight the specific columns you want to adjust.

Access the Format Menu

Navigate to the 'Home' tab on the top ribbon and locate the 'Cells' group. Click on the 'Format' dropdown button.

Enter the Desired Width

Select 'Column Width' from the dropdown menu. A dialog box will appear. Enter your desired numerical value (for example, type 10, 20, or 30 depending on your needs) and click 'OK'.

Save and Verify

Press Ctrl + S to save the workbook immediately. Close the Excel application entirely, and then reopen the file to confirm that your custom widths have been successfully retained.

Set and Save Fixed Column Widths Manually

Best Practice: Always save your workbook as an .xlsx file format after adjusting formatting. Older formats (.xls) or text formats (.csv) are prone to dropping formatting adjustments.

Seamless Spreadsheet Formatting

Format and Save Spreadsheets Reliably with WPS Office

WPS Spreadsheet offers precise, stable control over cell formatting. Whether you are using AutoFit or setting manual dimensions, WPS ensures your row heights and column widths are perfectly retained every time you save and reopen your files.

1. Open Your File: Launch WPS Office and open your spreadsheet document.
2. Select Columns: Highlight the columns you wish to resize by clicking on the lettered column headers.
3. Set Fixed Width: Right-click the highlighted headers, select 'Column Width', and enter your specific measurement.
4. Save Safely: Click the Save icon or press Ctrl + S. WPS Office will flawlessly preserve your precise formatting for the next time you open it.

100% compatible with Microsoft Excel (.xlsx, .xls) formatsReliably retains custom column widths and advanced cell formattingFree, lightweight, and fast to load on any operating systemFamiliar interface makes migrating from Excel effortless

microsoft office alternative - wps office

Frequently Asked Questions

Why does AutoFit not always save my column widths permanently?

AutoFit adjusts the column width dynamically based on the current cell contents. If the data is refreshed, filtered, or if the software glitches during rendering, it might revert to default dimensions rather than remembering the AutoFit state. Setting a manual width prevents this.

Does saving the file as a CSV cause column widths to reset?

Yes, CSV (Comma Separated Values) is a plain text format. It completely strips all visual formatting, including column widths, cell colors, and font styles. You must save the file as an .xlsx document to preserve any layout changes.

Can I set a default column width for the entire workbook at once?

Yes. In most spreadsheet software, you can set a default width for all empty columns by navigating to Home > Format > Default Width, and then entering your preferred measurement. This applies uniformly to all unformatted columns.

Document & File Issues