Hi, Senator. You can record a macro to do this:
http://www.officearticles.com/excel/...soft_excel.htm
Here's the steps you want to take after you start recording:
Edit--Select all
Format--Column Autofit
Ctrl+Home
(stop recording)
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Senator" wrote in message
...
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