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.
Most users won't ever need to enter a line break in an Excel spreadsheet cell - but if you do - it's not as easy as you might think! Simply hitting the enter key makes Excel jump to the next cell. So how is it done? Using Shift-Enter doesn't work, but fortunately there is another key combination that does work: Ctrl-Alt-Enter (or Ctrl-Option-Enter). I'm using Excel within Office 2008 for Mac. In a large spreadsheet, I need to replace all line breaks within a cell with a space. I understand that to CREATE a line break, I would use Ctrl+Alt+Enter, but the Find box does not accept that. It also does not accept a pasted line break. I've tried everything I can think of.
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 –
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.
Following keyboard shortcut is used to start a new line in the same cell –
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 Shortcut
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
How To Enter A Line Break In Excel For Mac Pro
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). Download apc by schneider electric driver.
You might also like reading these Excel Tutorials:
