How to put multiple lines of text in one cell in Excel?
This article will show you methods of putting multiple lines of text in one cell, as well as removing multiple lines in one cell at once in Excel.
Put multiple lines of text in one cell with formatting cell as wrap text
Put multiple lines of text in one cell with pressing Alt + Enter keys
Easily remove all multiple lines from selected cells with Kutools for Excel
For cell with long texts beyond your cell, you can auto adjust the texts into multiple lines for fitting the cell width with formatting the cell as wrap text.
1. Right click the cell you want to put multiple lines, then click Format Cells. See screenshot:
2. In the Format Cells dialog box, check the Wrap text box under the Alignment tab, and then click the OK button.
Note: You can also just click Home > Wrap Text to put the overwriting text string to multiple lines.
Easily remove all line breaks from selected cells in Excel:
If you want to remove all line breaks from specific cells, the Remove Characters utility of Kutools for Excel can do you a favor. See the below demo.
Download the full feature 30-day free trail of Kutools for Excel now!
You can put multiple lines in a cell with pressing Alt + Enter keys simultaneously while entering texts.
Pressing the Alt + Enter keys simultaneously helps you separate texts with different lines in one cell. With this shortcut key, you can split the cell contents into multiple lines at any position as you need.
If you want to remove all multi lines from cells, you can try the Remove Characters utility of Kutools for Excel.
Before applying Kutools for Excel, please download and install it firstly.
1. Select the cells you want to remove multi lines from, and click Kutools > Text > Remove Characters. See screenshot:
2. In the Remove Characters dialog box, only check the Non-printing box, and then click the OK button.
Now all multi lines in selected cells are removed immediately.