Forum Discussion
Jamie1963
Oct 30, 2019Copper Contributor
Automatic row heights
I have a worksheet where, depending on whether the user selects "yes" or "no" in one cell, an @if brings in text of different lengths to the adjacent cell. How can I set up the worksheet so that the...
Jamie1963
Oct 31, 2019Copper Contributor
tThanks tauqeeracma and others. That seems to make sense, but for some reason I still can't get it to work how I want. See attached. When you change no to yes, the row height doesn't adjust, but when you switch back to no, it expands! I must be doing something wrong that's really obvious?!
Riny_van_Eekelen
Oct 31, 2019Platinum Contributor
Looks good on my end. Just opened your workbook. Did nothing with it. See screenshot attached.
- Jamie1963Oct 31, 2019Copper Contributor
Thanks Riny_van_Eekelen. Must be something wrong with my Excel, because that's not what it does for me!