View Single Post
  #1   Report Post  
Senator
 
Posts: n/a
Default Automatic column width adjustment

I am importing .cvs records into Excel that I will save as an .xls file.
There are about 25 columns of information and each column has data of a
different character length. However, all the column widths are the same,
8.43. This presents a very laborious process of having to manually adjust
all the column widths. Is there a way to have Excel automatically adjust the
column widths to fit the longest string of characters in each of the columns?
Thanks