[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?

[Gord Dibben]

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

The expansion down can be done in a single cell with wrap text and rowautofit
or columnautofit enabled.

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


Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 16:04:18 +0100, StacyTheis
wrote:


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?

[StacyTheis]

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

Originally Posted by 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?