Hi,
I have large chunks of text going to excel cells. I don't want to
increase the cell width. So I opted for wrap text under cell formatting
options. This is working fine when I manually stretche the cell size
vertically.
Now my question is, Is there a way to increase the cell size
(vertically) automatically ... as and when I enter the large amount of
text?
Gord Dibben - 01 Dec 2006 16:39 GMT
Format>Row>Autofit
Note: this won't work if you have merged cells in the row.
For that you will need event code.
Have a look here if that is your problem.
http://snipurl.com/13sz7
Gord Dibben MS Excel MVP
>Hi,
>
[quoted text clipped - 6 lines]
>(vertically) automatically ... as and when I enter the large amount of
>text?