How to Permanently Save Excel Column Widths in WPS Spreadsheets
Question details
Users need to save adjusted column widths so they remain visible after reopening a spreadsheet, and to avoid losing formatting when working with CSV files.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is setting column widths in a spreadsheet and wants the layout to persist when the file is closed and reopened, especially when moving data from CSV to a workbook.
- Observed behavior
- CSV files save only plain text data and do not preserve column widths or other worksheet formatting; .xlsx workbooks can retain column widths when saved in Excel format.
Open the file in WPS Spreadsheets and check whether it is saved as a .xlsx workbook or a .csv text file. If the file is a CSV, plan to save it as an Excel workbook after adjusting column widths.
Set a Fixed Column Width and Save as an Excel Workbook
Use this method when you want a specific column width to remain every time you open the workbook.
WPS Spreadsheets stores column widths as part of .xlsx workbook formatting. Saving as an Excel workbook rather than CSV keeps the column layout intact.
Open the workbook in WPS Spreadsheets, click the first column letter, and drag across the column headers to select all columns you want to resize.
Right-click a selected column header and choose Column Width from the context menu.
Type a numeric width value in the Column Width dialog box and click OK. The selected columns update immediately.
Click Menu > Save or Save As, choose Excel Workbook (*.xlsx) as the file type, name the file, and save it. Reopen the file to confirm the width remains.
Convert CSV Data into a New Workbook to Preserve Column Widths
Use this method when your data is in a CSV file, because CSV files cannot store column width formatting.
Use AutoFit to Size Columns to Content and Save the Layout
Use this method when you want columns to automatically adjust to the longest entry instead of entering a fixed width.
Save Column Widths Permanently in WPS Spreadsheets
Set fixed or AutoFit column widths in WPS Spreadsheets and save as an .xlsx workbook. WPS Spreadsheets keeps the formatting so the column layout is unchanged when you reopen the file.
- 1. Install WPS Office: Download WPS Office from the official WPS website, install it, and open WPS Spreadsheets from the WPS Office home screen.
- 2. Open the spreadsheet: Click Menu > Open, then select the .xlsx workbook or CSV file you want to work with.
- 3. Set column widths: Select the columns, right-click the column header, choose Column Width, and enter a value. You can also use Home > Format > AutoFit Column Width.
- 4. Save in Excel format: Click Menu > Save As, choose Excel Workbook (*.xlsx), and save the file. The column widths will be stored in the workbook.
Frequently Asked Questions
Why do my column widths disappear after saving a CSV file?
CSV files store only plain text data and do not save column width or other formatting. Save your spreadsheet as an Excel Workbook (*.xlsx) in WPS Spreadsheets to keep the column layout.
How do I set a specific column width in WPS Spreadsheets?
Select the columns you want to resize, right-click the selected column headers, choose Column Width, type the desired value, and click OK.
Can WPS Spreadsheets save Excel column widths for .xlsx files?
Yes. WPS Spreadsheets is compatible with Microsoft Excel .xlsx files and stores column widths as part of the workbook formatting, so they remain after reopening.
How can I make columns fit their content permanently without entering a number?
Select the columns, go to Home > Format > AutoFit Column Width, then save the file as an Excel Workbook (*.xlsx).
Do I need Microsoft Excel to fix column width formatting in a CSV file?
No. You can open the CSV in WPS Spreadsheets, copy the data to a new workbook, adjust the column widths, and save as .xlsx to preserve the formatting.
