I tried it and it adjusted the column width to what is already on the
worksheet, but did not adjust as I entered in new information.

"Gord Dibben" wrote:

FormatColumnAutofit Selection for width.

FormatRowAutofit for height.

Note you can also turn on wordwrap.

Entire rows and entire columns will adjust.

You cannot adjust individual cells.


Gord Dibben MS Excel MVP

On Thu, 1 Jan 2009 15:41:00 -0800, KB wrote:

I need cells to automatically adjust to fit text entered.
This text will be entered by others after I complete the workbook.

Thanks for your help!