How to force or auto line break within an Excel cell?
In some cases, the texts are so long to place in a cell that the trailing parts are out of the cell, which will look untidy and not beautiful, in this case, we need to insert a line break for displaying the whole string within the cell in Excel as below screenshot shown.
Force a line break within a cell
Force a line break within a cell
To force a line break within a cell as you want, you can use the shortcuts.
Place the cursor at the location within the cell you want to force a line break, and press Alt + Enter keys together. Now a line break is inserted at once.
Then you can insert the line break one by one.
Auto line break within a cell
If you want to automatically insert the line breaks in a cell, you can apply the Wrap Text utility.
Select the cells you want to automatically add line breaks, and click Home > Wrap Text to enable the Wrap Text function. See screenshot:
Now all selected cells have been auto line break based on the column width.
Best Office Productivity Tools
Supports Office/Excel 2007-2021 and 365 | Available in 44 Languages | Easy to Uninstall Completely
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...
Supercharge Your Excel Skills: Experience Efficiency Like Never Before with Kutools for Excel (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! (Full-Featured 30-Day Free Trial)
