Menu
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.
How to open Microsoft Excel spreadsheets in Apple Numbers on a Mac By Roman Loyola. Senior Editor. If you use Microsoft Excel on your Mac, you can save the spreadsheets you create and open them.
nwinklernwinkler
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
The ⌥ alt key is also the ⌥ option key on a Mac keyboard.
Hence, ⌃ control+option ⌥+↩ return works too.
Hence, ⌃ control+option ⌥+↩ return works too.
grg♦
Mark BergmanMark Bergman
eshamesham
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
JaredJared
fn + ⌃ + ⌥ + ↩.
The fn causes the option key to become the alt key.
Martin ErbMartin Erb
In Microsoft Excel for Mac (Preview)
ctrl ^ + U
or
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
nohillside♦
olivierolivier
You must log in to answer this question.
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?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged keyboardms-office .
Where is a Save As Button in Excel (or Word) on OS X to save as a New File Name in a specific folder?
bmike♦
Linda B Thats MeLinda B Thats Me
1 Answer
File menu > Save As... or Cmd ⌘ Shift ⇧ S
If you specifically want a button in the button bar, then View > Toolbars > Customise Toolbars & Menus > Commands, then Find it in the File section & drag to where you want it in the toolbar. [Note, Save as doesn't have an icon, so it will appear there in words.]
TetsujinTetsujin