On the Mac, the Enter key and the Return key are different keys.

You can start a new line in the same cell in Excel by using: A keyboard shortcut to manually force a line break.

This Tutorial Covers: Start a New Line in Excel Cell Keyboard Shortcut Start a New Line in Excel Cell Using Formula Using TextJoin Formula Using Concatenate Formula Start a New Line in Excel Cell Keyboard Shortcut To start a new line in an Excel cell, you can use the following keyboard shortcut: For Windows ALT Enter.

Here are the steps to start a new line in Excel Cell using the shortcut ALT ENTER: Double click on the cell where you want to insert the line break (or press F2 key to get into the edit mode).

Hold the ALT key and press the Enter key for Windows (for Mac hold the Control and Option keys and hit the Enter key).

But in case you need to combine cells and get a line break while combining these cells, you can use a formula to do this.

Using TextJoin Formula If youre using Excel 2019 or Office 365 (Windows or Mac), you can use the TEXTJOIN function to combine cells and insert a line break in the resulting data.

For example, suppose we have a dataset as shown below and you want to combine these cells to get the name and the address in the same cell (with each part in a separate line): The following formula will do this: TEXTJOIN(CHAR(10),TRUE,A2:E2) At first, you may see the result as one single line that combines all the address parts (as shown below).

To make sure you have all the line breaks in between each part, make sure the wrap text feature is enabled.

To enable Wrap text, select the cells with the results, click on the Home tab, and within the alignment group, click on the Wrap Text option.

Once you click on the Wrap Text option, you will see the resulting data as shown below (with each address element in a new line): Note: If you are using MAC, use CHAR(13) instead of CHAR(10).

Using Concatenate Formula If youre using Excel 2016 or prior versions, you wont have the TEXTJOIN formula available.

So you can use the good old CONCATENATE function (or the ampersand character) to combine cells and get line break in between.

Again, considering you have the dataset as shown below that you want to combine and get a line break in between each cell: For example, if I combine using the text in these cells using an ampersand (), I would get something as shown below: While this combines the text, this is not really the format that I want.

You can try using the text wrap, but that wouldnt work either.

If I am creating a mailing address out of this, I need the text from each cell to be in a new line in the same cell.

To insert a line break in this formula result, we need to use CHAR(10) along with the above formula.

CHAR(10) is a line feed in Windows, which means that it forces anything after it to go to a new line.

So to do this, use the below formula: A2CHAR(10)B2CHAR(10)C2CHAR(10)D2CHAR(10)E2 This formula would enter a line break in the formula result and you would see something as shown below: IMPORTANT: For this to work, you need to wrap text in excel cells.

How to Split Multiple Lines in a Cell into a Separate Cells Columns Combine Cells in Excel CONCATENATE Excel Range with and without a separator MS Help Start a New Line.

Pinterest Facebook Twitter LinkedIn Reddit FREE EXCEL BOOK Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster Name Email YES - SEND ME THE EBOOK gene says: at Shift command for mac.

I want to clear up something about the keyboard shortcut for the Mac in case anyone has seen this blog post, tried it, and then is wondering why it doesnt work.

Excel For Mac Go To Next Non-Blank Cell