Is Automatic Cell Expansion Possible?

S

StacyTheis

I'm currently making a template document that has a section in it with
several merged cells where the user can enter comments about a certain
client. Is there a way for the cells to automatically expand down if
the user adds more comments than the space already provided? Or will
the user have to just add rows manually?
 
G

Gord Dibben

The fact of using the dreaded "merged cells" function means you cannot have
row>autofit functional without using event code

The expansion down can be done in a single cell with wrap text and row>autofit
or column>autofit enabled.

But not to the next cell. That would require manual input.


Gord Dibben MS Excel MVP
 
S

StacyTheis

Thanks so much for your reply. I didn't think there was a way. Thanks
for confirming that!
 
Top