Excel on Mac: How to type newline inside a cell?

Here is one of the simple things that just makes life better. Typing a new line within a cell in Excel. Very useful for many reasons but essentially i am talking about the option to write, for example, an mailing address, where the first line is the name of the place, second line is the street address and third line is city and zip code. Something like this:

 Screen Shot 2014-11-08 at 9.40.45 AM

In the Windows version of Excel this was something i was using all the time. The combination of Control + Enter did the trick.

But in the Mac version of Excel this combination does not work. But don’t lose hope. There is simply a different combination that does it:

Control + Option (or Alt) + Enter

And it works just the same!

(I found this information here).

Advertisements

Author: dave

Consider myself kid in soul and naive by choice. I am interested in people, technology and business and thrive when they all work together. My favorite quote and motto is that “You can fool some people some times but you cant fool all the people all the time” ― Bob Marley

1 thought on “Excel on Mac: How to type newline inside a cell?”

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s