Forum Discussion
Automatic row heights
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
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_EekelenOct 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!