How Do You Filter By Text In Excel For Mac

Active3 years, 11 months ago
  1. Wrap Text In Excel
  2. How Do You Filter By Text In Excel For Macro

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.

nwinklernwinkler

Open your workbook, select the sheet that you'll enter MAC addresses into. Right-click on the name tab and choose View Code from the list. Copy the code below and paste into the module presented to you.

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)

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
57.1k14 gold badges120 silver badges168 bronze badges
olivierolivier

You must log in to answer this question.

protected by CommunitySep 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 .

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.

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.

For

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
dwightkText
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)

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
57.1k14 gold badges120 silver badges168 bronze badges

Wrap Text In Excel

olivierolivier

You must log in to answer this question.

protected by CommunitySep 24 '15 at 4:11

How Do You Filter By Text In Excel For Macro

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 .