Forum Discussion
Solved
Permanently Fixing Column Width?
Hello community, I'm very new to using Excel files and know basically nothing about them, but can someone please advise me how to permanently fix column widths in csv and xlsx files so that after I c...
A .csv file is a plain text file; it does not store any formatting information whatsoever. So there is no way to save column widths in a .csv file. You'll have to fix them each time you open the .csv file in Excel.
On the other hand, Excel stores the column widths in a workbook (.xlsx. .xlsb, .xlsm or .xls), so when you save, close and open a workbook, the column widths should be as when you saved the workbook.
HansVogelaar wouldn't it be nicer if Excel had an option for the user to be able to set so that optionally Excel will resize column widths to fit the data lengths upon CSV file opening!
You can submit a request from within Excel: Help > Feedback > Make a suggestion.