• For Windows – ALT + Enter. For Mac – Control + Option + 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). Place the cursor where you want to insert the line break.
• 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. As pointed out by Shameer in this answer, Alt+Enter now seems to work as well in the new Excel for Mac 2015.
• Double-click the cell in which you want to insert a line break Click the location where you want to break the line. Press ALT+ENTER to insert the line break.
• Looks like a dupe to me. That question asks 'how do i insert a line break like i do a space'. It isn't asking how to use%20 as a newline. The only substantial difference I see is this is asking about the body, whereas that question asks about the subject. Its the same answer in either case, though. – Amy Jun 2 '17 at 15:54.

While entering or editing data in Excel it is possible to add line breaks in the cell using Alt + Enter. This can be a convenient way to display data in Excel, but is often not great for any type of data analysis.

Insert line breaks manually with Alt + Enter Inserting a line break in Excel is quite easy: Just press Alt + Enter to add a line break inside a cell. This keyboard shortcut works the same way on Windows and the Office 2016 for Mac.

For example, it might be more convenient for the reader to display an address in a cell like this:

Rather than like this:

In this post I’ll show you how to separate the data in your cells based on the in-cell line breaks. This can be useful when doing any sort of data analysis on the data. In this example, we have address data which includes a person’s name, address, city and country. The data is in one cell for each person but the name, address, city and country are on different lines.

Select your data and open the Text to Columns wizard.

1. Select all the data containing multiple in-cell lines which you want to convert into single line cells.
2. Go to the Data tab in the ribbon.
3. Select Text to Columns in the Data Tools section.

Text to Columns wizard step 1.

1. Select Delimited option under Original data type.
2. Press the Next button.

Text to Columns wizard step 2.

1. Select Other from the Delimiters options and deselect all the rest of the options. In the input box to the right of Other press Ctrl + J to insert a line break as your delimiter.
2. You should see dividers appear in the Data preview pane where there are line breaks in your data.
3. Press the Next button.

Text to Columns wizard step 3.

How To Put A Line Break In Excel Mac

1. Use the range selector icon to choose a destination for the divided data. Select a cell outside of the original data range to keep a copy of the original data.
2. Check the Data preview to make sure the text to column is correct.
3. Press the Finish button.

How To Enter A Line Break In Excel For Mac Shortcut

Now each line from the original data is in its own column allowing for easier analysis of the different data fields using pivot tables, formulas or other tools!