Increasing cell size (vertically)

[murali]

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]

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