Buzz
Master the Skill of Inserting Line Breaks in Excel
Guide to Adding Line Breaks in Excel
1. Adding Line Breaks in Excel Using the Traditional Method.
The traditional method involves using keyboard shortcuts to add line breaks in Excel. This method only applies to text segments without formulas, as including formulas would have no effect or could accidentally corrupt the formula code.
Let's say we have the text segment Mytour says hi
To add a line break in Excel in this case, click in the middle of the text segment and then press the Alt + Enter key combination to execute the Line Break.
Note: Only the left Alt key is effective; the right Alt key serves no purpose in this scenario.
2. Adding Line Breaks in Excel with Formulas
If it involves a function or simply if you want to arrange the returned values row-wise, what should you do in a case like the one below?
Step 1: If done conventionally, we would have = B4&C4 with B and C representing the respective values.
Step 2: However, the resulting output looks like this, to add a line break in Excel, add the following small function.
Step 3: Specifically, instead of B4&C4, we'll change it to B4&CHAR(10)&C4 then press Enter to execute the Line Break.
The result after adding a line break in Excel will be as follows. Please note that in Windows it's Char(10) but if you're using Excel on a Macbook it'll be Char(13) .
Here are the ways to add line breaks in Excel, they seem simple, don't they? This is just one of the many things you need to learn when using Excel, even at a basic level. Because what we need to use most in Excel isn't just adding line breaks in Excel, but Excel functions. But that doesn't mean we don't need it; besides adding line breaks in Excel, try checking out some basic Excel functions compiled by Mytour. This is something all Excel beginners need to know.
