The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,878 other followers

keyboard – How to add a line break in a cell in Excel for Mac – Ask Different

Posted by jpluimers on 2019/06/03

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: [WayBackkeyboard – 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).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: