Donnie
Record a macro of yourself doing it
ToolsMacrosrecord new macro and save it to your personal workbook and even
assign a shortcut key or button to run it
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"donnie darko" wrote in message
ups.com...
I work with a system which gives me a fixed width dump of data for each
file I request. This must then be imported into Excel, and the columns
have to be lined up with the import wizard every time (about 50
columns)! The columns will always be the same width. How can I save
or automate the column widths to easily import the data after setting
up the columns just once?