Forum Discussion
Permanently Fixing Column Width?
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.
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.
- Thank you Hans, I appreciate the reply!
