Wrap text

Copper Contributor

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

@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)