- Insert New Worksheet In Excel
- Merge And Center The Selected Cells
- How To Wrap Text In 2013 Excel
- Disable Wrap Text In Excel
Active3 years, 11 months ago
If the text in a cell goes past the right border, you can also insert a line break to manually make the text wrap. Double-click on the cell to edit the text or press F2. Click the mouse at the point in the text where you want to insert a line break. Watch video Become a more productive, efficient Excel user with this collection of tips and tricks—just for Mac. Curt Frye kicks off with his top 10 power shortcuts, and introduces techniques for controlling and customizing the user interface, managing workbooks and worksheets, and organizing, entering, and formatting data.
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.
nwinklernwinkler5,7332121 gold badges4141 silver badges6565 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 https://panelrenew898.weebly.com/blog/powerpoint-for-mac-text-box-animation. 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♦
Insert New Worksheet In Excel
![Text Text](/uploads/1/3/3/2/133272430/982184369.jpg)
5,7332121 gold badges4141 silver badges6565 bronze badges
The ⌥ alt key is also the ⌥ option key on a Mac keyboard.
Hence, ⌃ control+option ⌥+↩ return works too.
grg♦Hence, ⌃ control+option ⌥+↩ return works too.
145k2525 gold badges229229 silver badges340340 bronze badges
Mark BergmanMark Bergman
Jawa2,26755 gold badges1717 silver badges2525 bronze badges
eshamesham
dwightkMerge And Center The Selected Cells
6,2611212 gold badges3737 silver badges6060 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
jherran10.6k99 gold badges4040 silver badges6363 bronze badges
JaredJared
fn + ⌃ + ⌥ + ↩.
The fn causes the option key to become the alt key.
jherran10.6k99 gold badges4040 silver badges6363 bronze badges
Martin ErbMartin Erb
How To Wrap Text In 2013 Excel
In Microsoft Excel for Mac (Preview)
ctrl ^ + U
or
![Wrap Text In Excel For Mac Wrap Text In Excel For Mac](/uploads/1/3/3/2/133272430/560810020.png)
Disable Wrap Text In Excel
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♦57.1k1414 gold badges120120 silver badges168168 bronze badges
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?