wrapping and auto row height

[Guest]

I am wrapping text in a cell, not huge amounts, but a few lines, and when I double click to get the row automatically height adjusted, it doesn't expand to the height of the multiple rows, but only to one row of text. Is there a better way to do this?

 

[Gord Dibben]

Jessica

Is the "cell" a merged cell?

Wrap text works on merged cells. Autoheight does not. Perhaps this is what
you are experiencing. You can resize manually or via Macro. Jim Rech has
written code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

Gord Dibben XL2002