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.
Source: [WayBack] keyboard – How to add a line break in a cell in Excel for Mac – Ask Different
The answer depends on the Excel for Mac OS X version you are using.
Excel 2015 is simple (thanks esham): use Option
+Enter
.
In older Excel <= 2011 (thanks nwinkler), use Command
+Option
+Enter
or Control
+Option
+Enter
.
Some users report the also need the Fn
key in addition to the above modifiers.
–jeroen
PS: Later I found out that [WayBack] Beckism.com: Use a linebreak in Excel on Mac also shows the Excel <= 2011 solution Control+Option+Return
(note that Return
is the same key as Enter
).
Like this:
Like Loading...