Though excel is a spreadsheet software, however we often enter text in it. But what if the text is too long? How you going to make a link break or enter a new line within a cell? Today, in this tutorial, I am going to tell you how you can start a new line in excel cell.
There are two ways to start new line within a cell in excel –
- A shortcut to enter line break in the same cell.
- A formula which automatically enters a line break and create a new line within the same cell.
Method 1 – Keyboard shortcut to start a new line in excel cell
Following keyboard shortcut is used to start a new line in the same cell –
- If you use Office:Mac Excel, you may from time to time need to capture multiple lines of information into a cell. If you come from the Windows world, you will quickly come to realize that Alt+Enter doesn’t work. If you want to insert a new line in Excel for the Mac, select the cell, type your first line and press Alt+Cmd+Enter.
- As with everything Microsoft do, there are two ways to achieve page breaks in Excel. The first is by setting print areas (Les Black answer explains it perfectly). The second is the using Page Breaks!
How To Put A Line Break In Excel Mac
To insert a line break between text we need to use CHAR function. And in today’s post, I’m going to show you exactly 3 different formulas which you can use to have a line break while combining values from different cells. And the best part is all these 3 formulas are simple to use. The answer is to use Control+Option+Enter, which will create a line break in the cell. As an alternative, Control + Command + Enter can also be used to achieve the same. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015.
Windows OS – ALT+Enter
MAC OS – Control+Option+Enter
Easy steps to do line break in excel cell –
- Double click the cell where you want to insert a line break.
- Move your cursor to the place where you want to insert a line break.
- Now hold the ALT and Enter key together and create multiple lines within a single cell in excel.
Method 2 – Add line break in same excel cell using Formula
Suppose we have a data set as shown below –
Now, combine text in A1, B1 and C1 Cell with Concatenate function.
Texts are combined in cell D1.
How To Enter A Line Break In Excel For Mac Os
In order to enter the line break, we have to use CHAR(10)along with the CONCATENATE function.
Use the below given formula to add multiple lines in excel cell
A1&CHAR(10)&B1&CHAR(10)&C1
This formula will create a line break that you can see in the below picture. However, make sure that your ‘wrap text’ is active while you are applying this formula otherwise the formula won’t work in the other case.
Note: If you are a Mac user, use CHAR(13).
You might also like reading these Excel Tutorials: