Forum Discussion

Jamie1963

Copper Contributor

Oct 30, 2019

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...

excel

tauqeeracma

Iron Contributor

Oct 30, 2019

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

Jamie1963

Copper Contributor

Oct 31, 2019

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

Row height test.xlsx11 KB

Riny_van_Eekelen
Platinum Contributor
Oct 31, 2019
Jamie1963
Looks good on my end. Just opened your workbook. Did nothing with it. See screenshot attached.
- Jamie1963
  Copper Contributor
  Oct 31, 2019
  Thanks Riny_van_Eekelen. Must be something wrong with my Excel, because that's not what it does for me!