View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT

Double click the separator between the column and the one to the right
or
Select all the columns and use Format | Columns | AutoAdjust

I know of no way to make Excel automatically widen a column to hold any
amount of test entered into it.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DebC" wrote in message
...
I use Microsoft Office 2003. Is there a way to get columns to automatically
adjust to fit the content of the cell?