select the columns and do Format=Columns=Auto Fit Selection

or after selection double click on the border in the header (when your mouse
icon is a two headed arrow with a verticle bar in the center -- you must be
over the headers)

--
Regards,
Tom Ogilvy


"Wibs" wrote in message
...

Hi,

It is a litle wearisome when copying data from a web table or word
table via the clipboard into Excel to then have to resize every column
to make the data fit the cells.

Is there a way to force Excel to resize columns to the width of the
widest data?

TIA

Wibs


--
Wibs
------------------------------------------------------------------------
Wibs's Profile:
http://www.excelforum.com/member.php...o&userid=28922
View this thread: http://www.excelforum.com/showthread...hreadid=490607