Forum Discussion

nitheshck's avatar
nitheshck
Copper Contributor
Feb 12, 2022

Wrap text

Hello,

 

I need help in wrapping an Excel cell by length of the word

 

glastronix supplier trend chart

 

Column width should be automatically adjusted to the word length.  When I use wraptext, sometimes one word is getting split and coming in two lines.

 

can anyone help in this

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    nitheshck 

    Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break.

    Wrap text in a cell

     

    or...

     

    Write in a line below each other

    How can I write one column below the other in Excel?

    image result Write permanently in Excel cells below each other Open Excel

    and press the [Ctrl] + [1] keys at the same time.

    Then switch to the "Alignment" tab in the "Format Cells" window.

    Under the "Text Control" you will now find the "Wrap Words" option.

     

    Hope I was able to help you with this info.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources