Back to news

How to enter a line break in Excel for Mac

Posted by Robert Lee on 24 June 2013

How to enter a line break in Excel for Mac

Most users won't ever need to enter a line break in an Excel spreadsheet cell - but if you do - it's not as easy as you might think!  Simply hitting the enter key makes Excel jump to the next cell.  So how is it done?

Using Shift-Enter doesn't work, but fortunately there is another key combination that does work:

Ctrl-Alt-Enter (or Ctrl-Option-Enter)

That works perfectly - problem solved!

I'm using Excel for Mac 2011 but I expect it will work in all Mac versions.

TAGS: Mac OS X

Comments

3 comments received

Posted by Caroline on 17 September 2015 at 1:48pm:

Hi again,

Just found the automatic line break function :) Mark all/specific cell --> Format --> Cells --> Adjustments --> Text control --> Click the box where it says "Line-break"

Thanks anyways!

Posted by Caroline on 17 September 2015 at 1:25pm:

Hi,
I'm also using Excel 11 for Mac.
I'm doing a loooot of line breaks in my Excel spreadsheet. Do you know if there is a way to get automatic line break, so that I don't have to do it manually - by Ctrl-Alt-Enter - every time. I've tried Start --> Adjustments, however there is no "Line break"-function as Microsoft Support describe there to be???

Grateful for advice :-)

Posted by Julia on 24 June 2015 at 11:34am:

I love you! I knew the solution on a PC but thought I'd tried every combination on the Mac to no avail! Thank you.

© Copyright 2003-2017 Something Digital Ltd. All rights reserved. Sitemap