Active3 years, 11 months ago

What key combination do I have to press to create a line break in a cell in Excel for Mac 2011? The Windows combination of Alt+Enter does not work on the Mac.

Use Text to Columns (Data tab, Data Tools group) However, it should be CHAR(13) not CHAR(10), that's where I had trouble. Not sure if this is a difference between Windows and Mac, but once I made the change, I was able to get it done. I am experiencing the following issue in Microsoft Excel for Mac 2016. When using the From Text data import function and clicking through the first two steps (selecting 'Delimited' and defining del. Excel 2013 automatically displays lengthy text entries over adjacent cells, assuming no other data exists in these cells. However, this behavior could extend the text outside the visible area of the worksheet and any adjacent data added to the spreadsheet could truncate the paragraph. Excel Tutorial - Cleaning Up Data with TRIM, PROPER, and Text to Columns - Duration: 13:50. Mergers & Inquisitions / Breaking Into Wall Street 52,750 views. Split multiline cell contents into separate rows or columns with Kutools for Excel If you want to split the multiline cell contents to multiple rows, the Text To Column feature may not help you. But, the Split Cells utility of Kutools for Excel can help you quickly split multiline cell contents into separate rows or columns.

nwinklernwinkler

5,73321 gold badges41 silver badges65 bronze badges

10 Answers

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.

Community♦

nwinklernwinkler

5,73321 gold badges41 silver badges65 bronze badges

The ⌥ alt key is also the ⌥ option key on a Mac keyboard.
Hence, ⌃ control+option ⌥+↩ return works too.

grg♦

145k25 gold badges229 silver badges340 bronze badges

Mark BergmanMark Bergman

Jawa

2,2675 gold badges17 silver badges25 bronze badges

eshamesham

dwightk

6,26112 gold badges37 silver badges60 bronze badges

user72377user72377

None of these seems to work. Have tried all. I am using a keyboard to interface to the Mac. I am using Office 365.

EDIT: Weirdly if I used fn+f2 to get the curser in the cell, fn+alt+cmd+return then worked...

SuzySuzy

All was wrong. Fn + Shift + Enter is the right combination .

user123786user123786

jherran

10.6k9 gold badges40 silver badges63 bronze badges

JaredJared

fn + ⌃ + ⌥ + ↩.

The fn causes the option key to become the alt key.

jherran

10.6k9 gold badges40 silver badges63 bronze badges

Martin ErbMartin Erb

In Microsoft Excel for Mac (Preview)

Text To Columns For Multiple Columns

ctrl ^ + U

fn + F2

Nika MamulashviliNika Mamulashvili

http://giffconstable.com/2013/10/mac-excel-keyboard-shortcuts/ helped me figure it out -> it turns out to be ctrl-i worked on my macbook

Text To Columns For First Space

nohillside♦

57.1k14 gold badges120 silver badges168 bronze badges

olivierolivier

You must log in to answer this question.

Excel Text To Columns For Paragraph On Mac

protected by Community♦Sep 24 '15 at 4:11

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged keyboardms-office .

Multiple paragraphs of text in an Excel cell sound good, they look good but how the heck do you create them? If you press the Enter key you enter the current text into the cell and move away from it – obviously, pressing the Enter key isn’t the answer.

The solution is to press Alt + Enter to create a new line of text in the current cell. Do this as often as you need to. You might have to make the row taller to fit the text if Excel doesn’t make the adjustment for you.

For more tips and tricks and helpful Office columns, visit Projectwoman.com

Excel Text To Columns For Paragraph On Mac