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.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
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.
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.
You maybe interested in this utility:
Insert Page Break Every Row (quickly insert page break in every nth row of the worksheet.)