Forum Discussion
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 height of the row with the dependent text automatically adjusts to be high enough to show the very long text but does not show lots of white space for the short text?
8 Replies
Select the entire column where your text will be displayed and format it to "wrap text". This will automatically adjust the row height when the text becomes wider than the column width.
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
I have this Text-Wrapping selected, but it quit doing it at row 100. I that a default in Excel? Somewhere else to get text-wrapping to continue beyond row 100?
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?!
Looks good on my end. Just opened your workbook. Did nothing with it. See screenshot attached.
Ooops.... you beat me to it. Hadn't refreshed the feed before I pressed "POST".
Never mind my friend, some other day you will beat me. But the beauty of this community that I am really learning.
Cheers
Tauqeer
