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.
