Use a linebreak in Excel on Mac
Sometimes you need a linebreak in an Excel spreadsheet cell, but when you hit return or enter it always jumps you to a new cell. On Windows, you can just hit alt-return (or maybe alt-enter; if one doesn’t work, try the other). On Mac, you’ll need to hit control-option-return.
Took me a while to figure this out, and I figured it could be useful for others. Enjoy!





I. says...
Cool! Thanks for the tip. I was searching the help section and amazingly enough I didn’t find anything!
Posted at 8:09 AM on February 5th, 2009 .:. Link ↑
Ian Beck says...
If they put that kind of info in the help, then anyone might be able to use the program. :-)
Posted at 8:45 AM on February 5th, 2009 .:. Link ↑
Rob says...
Thanks, it definitely helped me!
Posted at 7:43 AM on March 18th, 2009 .:. Link ↑
Mike says...
Thanks so much. I was just banging my head against my desk trying to figure out why this string didn’t exist. You just saved me about 45 minutes of work-around hell.
Posted at 8:09 AM on June 4th, 2009 .:. Link ↑
margaret francis says...
thanks! recently switched from PC to mac and the lack of this shortcut was maddening….
Posted at 11:58 AM on July 13th, 2009 .:. Link ↑
Sonia says...
You’re a lifesaver!
Posted at 10:59 PM on August 4th, 2009 .:. Link ↑
Leigh says...
Thank you! Thank you! Thank you!
Posted at 12:26 PM on September 12th, 2009 .:. Link ↑
Ian Beck says...
Glad you guys found this useful!
Posted at 6:22 PM on September 12th, 2009 .:. Link ↑
Mikke says...
Add my voice to the thanks. Though it did give me yet another chance to practice my Port Town Poetry on Excel.
Posted at 5:56 PM on September 20th, 2009 .:. Link ↑
drewvy says...
Thanks for that one (CTRL+OPTN+ENTER for line break in Excel cell).
And, I LOVE the “track me like a stalker” bit. Too funny.
CHEERS,
Drew
Posted at 5:23 PM on October 25th, 2009 .:. Link ↑
sonja says...
one more reason I really, really hate ms*ft products. Because of course sometime someone is going to want to put a line break in a cell, but why on earth would they make it either easy or intuitive???
Thank you for this work around … I was getting ready to throw things, but not my MBP :)
Posted at 6:54 PM on November 4th, 2009 .:. Link ↑
Kate says...
Glad to have found this, however, on my MacBook keyboard Control+Option+Enter doesn’t work…Command+Option+Enter does!!!
Cheers,
Kate
Posted at 9:48 PM on December 17th, 2009 .:. Link ↑
Brent says...
THANK YOU! This was driving me nuts.
Posted at 7:30 PM on January 31st, 2010 .:. Link ↑
Barry Chertov says...
Blessings to you, your family and friends for all time!
Thanks!
Posted at 11:29 AM on February 23rd, 2010 .:. Link ↑
Jen says...
Thank you so much for sharing this! I bookmarked you just in case I ever forget :) Thanks again, you saved me lots of aggravation!
Posted at 12:47 PM on February 23rd, 2010 .:. Link ↑
Megs says...
Thanks, that was a huge help! like you said, you’d think they’d have put that in the help section. Thank goodness for friendly (virtual) neighborhood bloggers!
Posted at 9:50 AM on April 28th, 2010 .:. Link ↑
Pancho L says...
Thank you very much!! Sometimes you think things like these are going to be really to find out for yourself, but you find yourself pressing every available key with enter and when nothing happens you can get really frustated!!!
Thanks again!
Posted at 1:49 PM on May 3rd, 2010 .:. Link ↑
Jezabel says...
Thank you so much. I needed to know this for a work project. Now if only you could explain the LOST finale.
Posted at 12:24 AM on May 25th, 2010 .:. Link ↑
vcrmchl says...
So useful! Much appreciated.
Posted at 6:10 AM on May 28th, 2010 .:. Link ↑
sama says...
just the thing I was looking for.
thx!
Posted at 11:50 AM on June 22nd, 2010 .:. Link ↑