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...
tauqeeracma
Oct 30, 2019Iron Contributor
Hi Jamie1963
Try 'Text Wrapping' option, hope it will help:
Excel does not wrap text in a cell. Instead, it allows the entry to overflow into the surrounding cells (if those cells are empty), or it hides the part that won’t fit if the cells contain content. To make the entire entry visible, you can allow the cell entry to wrap to multiple lines.
Wrapping text increases the height of the cell. Increasing the height of one cell increases the height of the entire row.
Thanks
Tauqeer
Riny_van_Eekelen
Oct 30, 2019Platinum Contributor
Ooops.... you beat me to it. Hadn't refreshed the feed before I pressed "POST".
- tauqeeracmaOct 30, 2019Iron Contributor
Never mind my friend, some other day you will beat me. But the beauty of this community that I am really learning.
Cheers
Tauqeer