Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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.

share|improve this question

8 Answers 8

up vote 66 down vote accepted

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 (Preview - 15.9).

share|improve this answer

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

share|improve this answer

Control+option+enter

or

Command+option+enter

share|improve this answer

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

share|improve this answer
    
Doesn't work for me. –  nwinkler May 6 at 11:31

ctrl ⌃ + command ⌘ + return ↩ at the same time.

share|improve this answer
    
I tried this in Excel for Mac 2011, and it works. –  nwinkler Aug 29 '14 at 6:19
1  
There is already an accepted answer. –  sameetandpotatoes Aug 29 '14 at 22:19

fn + + + .

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

share|improve this answer
1  
there is already a accepted answer here, so what is it you are trying to do ? –  Buscar웃SD Apr 2 '14 at 17:04
1  
FN does not cause option to become alt — option and alt is the same thing. –  grgarside Apr 2 '14 at 18:12
    
You do need the FN key. –  Chords Jun 4 '14 at 18:42

In Microsoft Excel for Mac (Preview)

ctrl ^ + U

or

fn + F2

share|improve this answer
    
These don't add a line break in a call, they switch to edit mode in the cell, allowing to type text in the cell. –  nwinkler May 6 at 11:33

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.