Just select whatever cells you want and make sure Text Wrap is selected. Also make sure your cells are big enough to display the information. I have not discovered a convenient way to jump down a space within the same cell so you could enter, say, all address inormation in one cell (return or tab exits the cell).

• New Rule Wrap Text All Cells Excel For Mac Free
• Clear All Cells Excel
• How To Display Formulas In All Cells Excel
• Highlight All Cells Excel
• New Rule Wrap Text All Cells Excel For Mac

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.

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.

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

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...

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

New Rule Wrap Text All Cells Excel For Mac Free

fn + ⌃ + ⌥ + ↩.

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

In Microsoft Excel for Mac (Preview)

ctrl ^ + U

or

fn + F2

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

Clear All Cells Excel

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?

How To Display Formulas In All Cells Excel

Not the answer you're looking for? Browse other questions tagged keyboardms-office .

You can format a cell so that text wraps automatically.

Highlight All Cells Excel

Wrap text in a cell or group of cells

New Rule Wrap Text All Cells Excel For Mac

1. Select the cells that you want to format.

2. On the Home tab, click Wrap Text.

   .

   Text inside the cell wraps to fit the column width. When you change the column width, text wrapping adjusts automatically.

   Note: If all wrapped text is not visible, it might be because the row is set to a specific height. To enable the row to adjust automatically and show all wrapped text, on the Format menu, point to Row, and then click AutoFit.