Forum Discussion
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 close and reopen them the columns will always still be the same width for a given file? I know how to adjust them to the amount of text in the column but they always return to their default upon reopening the file and that's very inefficient for my use of the files in my business. Thanks in advance for any knowledgeable help.
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.
- Thank you Hans, I appreciate the reply!
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.
