Importing a csv file and need to format the column width

[Cory]

I've created a csv text file that I'm opening directly into excel. The data is opened into the correct cells and everything looks fine, but for the column width. All of the columns come up in there standard width and I would like them to adjust so all of the text is visible. I'm not that familiar with importing into excel beyond basic formats. Any help is greatly appreciated!!

 

[Barrie Davidson]

On 2002-07-09 10:51, Cory wrote:
I've created a csv text file that I'm opening directly into excel. The data is opened into the correct cells and everything looks fine, but for the column width. All of the columns come up in there standard width and I would like them to adjust so all of the text is visible. I'm not that familiar with importing into excel beyond basic formats. Any help is greatly appreciated!!

Select all the cells in the file (the grey box beside column A and above row 1), and Format|Column|AutoFitSelection.

Hope this helps

 

[texasalynn]

I'm sure there is a fancier way but what I do is click on the area between column A and row 1 (the little gray box). This highlights the whole worksheet then put your mouse between one of the columns (say between column A & B) and when the mouse pointer turnes to a double arrow double click the mouse. This formats each column to the widest width required for each column.

Hopes this helps!

texasalynn

 

[Cory]

Thanks for the information. I should have been more informative on my description of the problem. I was hoping to include sometype of formatting record in the text csv file so the users wouldn't have to do any of the formatting manually. When they open the csv file I want it to automatically display correctly. Again, any help is greatly appreciated!

 

[Barrie Davidson]

On 2002-07-09 13:47, Cory wrote:
Thanks for the information. I should have been more informative on my description of the problem. I was hoping to include sometype of formatting record in the text csv file so the users wouldn't have to do any of the formatting manually. When they open the csv file I want it to automatically display correctly. Again, any help is greatly appreciated!

Sorry , can't be done within the CSV file. You could accomplish this via a macro, but you'd have to invoke the macro each time you open the file (instead of simply opening the file).