record a macro while doing it. You may need to clean it up a bit afterwards.

--
Don Guillett
SalesAid Software

"Paul-K" wrote in message
...
I am using Zoomerange to do customer surveys.

There results are downloadable in a excel sheet, but the column widths are
too wide as the answers are a rating of 1-5, comments (text) are not
wrapped
so the cell extends too wide, and I want to deletete a couple columns.

I download the survey results every week and want to know if there is a
way
to automate the process of formating the work sheet.