Hello and welcome back to the Excel Tip of the Week! This week we have a short Basic User-level post in which we are going to quickly summarise how line breaks and multi-line formatting works in Excel.
Normally, Excel cells display text that is longer than the cell by overwriting on any blank cells to the right. This continues for as long as necessary:
Of course, the edge of the window can also cut off long text.
If we use the option wrap text from the Home menu, then Excel will break the text up into the relevant number of lines to show it all:
As noted in the image, the Wrap Text button will automatically expand the row height to show all the text; however subsequent changes to the column width or row height don't automatically adjust the cell size to display all the text.
Adding line breaks
Ordinarily, line breaks are inserted by Excel according to the cell size. But we can add them manually with a line break, created by pressing Alt and Enter:
You can also create a line break in a CONCATENATE or other text formula using the CHAR function - CHAR(10) is the line break character.
Previous post - CODE, CHAR, UNICODE, UNICHARTOTW index Next post - MsgBox and InputBox
This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Filtered. There is also an online forum where you can ask questions and share ideas with other community members.