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
Put multiple lines of text in one cell with formatting cell as wrap text
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!
Put multiple lines of text in one cell with pressing Alt + Enter keys
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.
Easily remove all multiple lines from selected cells with Kutools for Excel
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.
If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.
Best Office Productivity Tools
Supercharge Your Spreadsheets： Experience Efficiency Like Never Before with Kutools for Excel
Kutools for Excel boasts over 300 features, ensuring that what you need is just a click away...
Supports Office/Excel 2007-2021 & newer, including 365 | Available in 44 languages | Enjoy a full-featured 30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
