Automatically autofit row height

[Searay]

Good afternoon,

I have a worksheet that populate the remaining of the worksheet automatically when selecting from a list of validation. Works beautifully! However, the row height do not adjust automatically when you change your selection or when the content is bigger than the cell. (The cell is already set at "Wrap") Is there a way to do it without using macros or VBA (not allow in my organization) and without having the user to use "Format" - "Autofit" or using the cursor and double click on the row? I am attempting to make the worksheet as user friendly as possible (Executive will use it) and if I don't find a solution it can be a deal breaker. Is there anyone that would have a solution to my problem?.

P.S. I am open to using formulas.

Thank you for your help.

Michelle

 

[Hermanito]

Wrap should normally do the trick, unless you use it in merged cells... unfortunately even Autofit or doubleclicking the rowsize handle won't work in those cases.
So, get rid of all merged cells, or live with the fact the rowheights are not gonna be automatically adjusted...