Forum Discussion

Jamie1963's avatar
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's avatar
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

  • Pat_Walsh's avatar
    Pat_Walsh
    Copper Contributor
    May 07, 2020

    tauqeeracma 

    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?

  • Jamie1963's avatar
    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?! 

    • Riny_van_Eekelen's avatar
      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's avatar
        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! 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 30, 2019

    tauqeeracma 

    Ooops.... you beat me to it. Hadn't refreshed the feed before I pressed "POST".

    • tauqeeracma's avatar
      tauqeeracma
      Iron Contributor
      Oct 30, 2019

      Riny_van_Eekelen 

       

      Never mind my friend, some other day you will beat me. But the beauty of this community that I am really learning.

       

      Cheers

      Tauqeer

       

       

Resources