Auto Text Wrap in a Cell

[Guest]

I know how to set automatic text wrap in a cell ... but how can I
automatically wrap text in a cell ... and have the cell resize larger
automatically as I add more text? Thanks.

 

[Dave Peterson]

If you autofit the rowheight, then excel will change that rowheight if you
change the value manually.

If the cell changes because of a formula, you'll have to autofit the rowheight
again--or have a macro do it.

Note that if you've set the rowheight manually (not by autofitting), excel will
remember that and won't change anything. Just autofit the rowheight and you'll
be all set.)