Since Excel 97 column widths expand automatically for numerical entries
unless they have been manually set to some width. Format, Column, AutoFit
Selection sets the autofit property back on for columns that have been
manually adjusted. Column widths do not expand for text entries.

--
Jim Rech
Excel MVP
"oranskeer" wrote in message
...
| How do I make a column automatically resize to grow as large as the data
| input in a cell automatically (not having to use the autofit column format
| option)?