How to permanently fix column width

nzingha417 

If you are using Office 2019 and working with a CSV file, the column width settings cannot be directly saved within the CSV file itself. However, you can use a workaround by following these steps:

1. Open the CSV file in Excel.
2. Adjust the column widths as desired by dragging the column dividers or using the AutoFit feature to fit the content.
3. Select all the cells in the worksheet by clicking the "Select All" button at the top left corner of the worksheet (or pressing Ctrl+A).
4. Right-click on any of the selected cells and choose "Copy" from the context menu.
5. Create a new Excel workbook by clicking "File" > "New Workbook" or pressing Ctrl+N.
6. In the new workbook, right-click on cell A1 and choose "Paste" > "Keep Source Formatting" or press Ctrl+Alt+V. This will paste the content, including the adjusted column widths, from the CSV file into the new workbook.
7. Finally, save the new workbook as an Excel file (.xlsx) by clicking "File" > "Save As" and choosing a location on your computer.

By following these steps, you will have a new Excel file with the adjusted column widths saved. Whenever you open this file, the columns should remain the same width as you set them.

Please note that this workaround involves copying the content from the CSV file into a new Excel file. Any formulas, formatting, or data validation rules that were present in the original CSV file may not be preserved in the new Excel file.