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!
Cool! Thanks for the tip. I was searching the help section and amazingly enough I didn’t find anything!
Posted 8:09 AM on Feb. 5, 2009 ↑
If they put that kind of info in the help, then anyone might be able to use the program. :-)
Posted 8:45 AM on Feb. 5, 2009 ↑
Thanks, it definitely helped me!
Posted 7:43 AM on Mar. 18, 2009 ↑
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 8:09 AM on Jun. 4, 2009 ↑
thanks! recently switched from PC to mac and the lack of this shortcut was maddening….
Posted 11:58 AM on Jul. 13, 2009 ↑
seconded.
Thank you :)
Posted 9:17 PM on Aug. 5, 2012 ↑
thirded.
Thanks…
Posted 9:58 AM on Oct. 26, 2012 ↑
fourthed!
Thanks
Posted 8:02 AM on Nov. 11, 2013 ↑
You’re a lifesaver!
Posted 10:59 PM on Aug. 4, 2009 ↑
Thank you! Thank you! Thank you!
Posted 12:26 PM on Sep. 12, 2009 ↑
Glad you guys found this useful!
Posted 6:22 PM on Sep. 12, 2009 ↑
Add my voice to the thanks. Though it did give me yet another chance to practice my Port Town Poetry on Excel.
Posted 5:56 PM on Sep. 20, 2009 ↑
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 5:23 PM on Oct. 25, 2009 ↑
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 6:54 PM on Nov. 4, 2009 ↑
yeah… b/c mac keyboard commands are SO intuitive…
Posted 1:11 PM on Apr. 26, 2013 ↑
Glad to have found this, however, on my MacBook keyboard Control+Option+Enter doesn’t work…Command+Option+Enter does!!!
Cheers,
Kate
Posted 9:48 PM on Dec. 17, 2009 ↑
THANK YOU! This was driving me nuts.
Posted 7:30 PM on Jan. 31, 2010 ↑
Blessings to you, your family and friends for all time!
Thanks!
Posted 11:29 AM on Feb. 23, 2010 ↑
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 12:47 PM on Feb. 23, 2010 ↑
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 9:50 AM on Apr. 28, 2010 ↑
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 1:49 PM on May. 3, 2010 ↑
Thank you so much. I needed to know this for a work project. Now if only you could explain the LOST finale.
Posted 12:24 AM on May. 25, 2010 ↑
So useful! Much appreciated.
Posted 6:10 AM on May. 28, 2010 ↑
just the thing I was looking for.
thx!
Posted 11:50 AM on Jun. 22, 2010 ↑
Thanks for the info. I agree that this is a poor shortcut, and poorly documented.
Posted 11:35 AM on Aug. 13, 2010 ↑
Thanks so much for this! I spent a good 15 minutes searching all over the web with no luck (plus at least that much time asking various people in my office!)
Posted 11:19 AM on Aug. 25, 2010 ↑
Thank you!!
Posted 6:28 PM on Aug. 29, 2010 ↑
I’ve been trying to find the solution to this for months – thank you so much!
Posted 5:53 AM on Sep. 7, 2010 ↑
You have my un-dying gratitude…
I love the ‘Net.
I love Google.
I love you.
Microsoft? Eh…not so much.
Posted 7:48 AM on Oct. 19, 2010 ↑
You’re the best!
Posted 10:59 AM on Nov. 19, 2010 ↑
Thanx! Wonder why such a useful tip is kept secret.
Posted 2:41 AM on Dec. 13, 2010 ↑
Thanks! This was driving me crazy! You’ve lowered my stress level (at least by a little!).
Posted 2:10 PM on Dec. 23, 2010 ↑
Thank you so much for this tip! Such a common necessity and yet hard to find!
Posted 7:19 AM on Dec. 29, 2010 ↑
Thank you: I’d been trying every other combo for this, but thanks to Google and your blog, I found the solution. :)
Posted 12:02 PM on Jan. 7, 2011 ↑
THANK YOU! it was killin’ me, :)
Posted 12:06 PM on Jan. 11, 2011 ↑
As Larry said:
You have my un-dying gratitude…
I love the ‘Net.
I love Google.
I love you.
Posted 6:54 AM on Feb. 7, 2011 ↑
Now if there was a character (like ^l and ^p in the PC versions) so we could do a universal find and replace.
Posted 12:19 PM on Feb. 21, 2011 ↑
Wow. Many thanks for this information.
Posted 12:59 PM on Mar. 10, 2011 ↑
Thank you for the tip
D – Portugal
Posted 6:18 AM on Mar. 12, 2011 ↑
What about removing a line break in an Excel for Mac cell?
Posted 12:24 PM on Mar. 19, 2011 ↑
FOUND IT!!!
=SUBSTITUTE(CELLS,CHAR(13),””)
or
=SUBSTITUTE(CELLS,CHAR(10),””)
Posted 1:01 PM on Mar. 19, 2011 ↑
Here’s another thank you. This has annoyed the #$!! out of me for years. I finally decided to look for a solution and here you are helping to make me just a little less crazy.
Posted 12:29 PM on Apr. 2, 2011 ↑
And another Thank you! Timeless info, you posted this over two years ago and still helping folks every day. Cheers!
Posted 8:21 AM on Apr. 4, 2011 ↑
Hi all,
I have a document with over 1,000 subtitles for a film (I have it in both Word and Excel versions).
Most of the subtitles have 2 lines, which are separated with this character: |
In Word (Windows or Mac), I can easily replace all the | with a line break (^p).
How can I do it in Excel for Mac?
Is there a way to represent the line break within the Excel “Replace” tool, just like ^p in the Word “Replace” tool?
Or is there a way to paste a Word table (which has line breaks within the table cells) into Excel, keeping the line breaks?
Thanks!
Enrique.
[email protected]
Posted 1:01 PM on Apr. 10, 2011 ↑
Thanks, Beck. You rock. Now why couldn’t Excel Help have answered this with such straightforward simplicity?
Posted 5:13 PM on May. 4, 2011 ↑
Wow, you wrote this 4 years ago and it was the first hit! Obviously a popular problem. Thanks!
Posted 6:35 AM on Jun. 2, 2011 ↑
Aces, thank you. I tried all the single key combinations and I sure as hell didn’t want to go down that old two-key road without Googling the problem first. Just think of the protracted agony you’ve saved me. It makes me weep.
Posted 8:21 AM on Jun. 6, 2011 ↑
looks like you’re going to get thankyous till the end of time – and you deserve it, of course!
Posted 1:26 PM on Jun. 26, 2011 ↑
Thank you sooooo much!
Posted 9:01 AM on Jul. 11, 2011 ↑
Exactly what I was looking for – thanks!
Posted 7:52 PM on Jul. 11, 2011 ↑
Thank you! I was having the same problem trying to negotiate the mac to perform this action using two key combinations (based on my prior PC knowledge). When I googled help your instruction was the first thing that popped up :) love when it’s that easy.
Posted 9:29 AM on Jul. 15, 2011 ↑
Thanks!
Posted 10:58 AM on Aug. 3, 2011 ↑
Thank you! New on Mac Excel, after more than 10 years of Windows!
I had no idea on how to do it, and definitely no clue on the possibility of using 2 keys!
THANX
Posted 7:46 AM on Aug. 13, 2011 ↑
Thank you…. This was exactly what i needed. :)
Posted 7:26 AM on Aug. 17, 2011 ↑
awesome – thanks!
Posted 2:50 PM on Aug. 26, 2011 ↑
I couldn’t figure it out, thanks!
Posted 9:46 AM on Sep. 8, 2011 ↑
Three and a half years on, it’s STILL helping people like me.
Posted 12:42 PM on Sep. 14, 2011 ↑
Thank you, thank you, thank you.
Posted 1:42 PM on Sep. 26, 2011 ↑
Thank you alt-ctrl-return works on 2011 version.
Posted 9:06 AM on Oct. 8, 2011 ↑
I’m an Excel power user but I’m new to the Mac version. This little nugget of help was brilliant in the simple way it was written. Thanks!
Posted 2:28 AM on Oct. 15, 2011 ↑
Beyond Fabulous, Thanks! I’m making the switch from PC to Mac and this was making me nuts. You are a true lifesaver.
Posted 12:20 PM on Nov. 1, 2011 ↑
Oh yes. Can’t thank you enough. And big thanks to whoever it was pointed out the MacBook keyboard variation. Heroes, one and all!
Posted 3:50 AM on Nov. 9, 2011 ↑
Thank you!
Posted 11:40 AM on Nov. 12, 2011 ↑
Sweet, so annoying they can’t make keyboard shortcuts consistent between Office for PC and Mac! It’s not like alt enter does anything in Excel 2011…
Posted 10:03 PM on Nov. 20, 2011 ↑
Thank you so much. It is so helpful to have knowledgeable people willing to put this stuff out there so dummies like me can find it …….. and save my sanity!!
Posted 3:24 PM on Nov. 23, 2011 ↑
I’m yet another grateful recipient of this tip.
Posted 8:05 AM on Nov. 25, 2011 ↑
Thanks, it helps :)
Posted 7:43 AM on Nov. 29, 2011 ↑
Many thanks to you and to Google for directing me instantly to this fix. All the best!
Posted 7:04 PM on Dec. 2, 2011 ↑
Thank you! Very helpful…
Posted 4:08 PM on Dec. 4, 2011 ↑
oooh thank you
Posted 3:31 PM on Dec. 22, 2011 ↑
THANK YOU!
Posted 10:48 AM on Jan. 6, 2012 ↑
Lifesaver! THANK YOU for posting this!!!!
Posted 10:35 AM on Jan. 19, 2012 ↑
Very Helpful. Thank you!
Posted 8:43 AM on Jan. 20, 2012 ↑
Thanks, it definitely helped me
Posted 12:38 PM on Jan. 29, 2012 ↑
Thank you so much. Ditto to the other responses, why don’t they put these things in the help menu. Anyone got a key combination for inserting a page break?
Posted 9:35 PM on Feb. 1, 2012 ↑
OH MY GOSH! YOU ROCK! Thank you.
Posted 11:52 AM on Feb. 11, 2012 ↑
Thank you, man!
Posted 10:27 AM on Mar. 7, 2012 ↑
Thank you!!
Posted 6:00 AM on Mar. 17, 2012 ↑
Thank you!!
Posted 3:18 AM on Mar. 19, 2012 ↑
You blessed!
Posted 12:13 AM on Mar. 20, 2012 ↑
OMG thank you! it’s been making me crazy!
Posted 7:16 AM on Mar. 22, 2012 ↑
Helpful to me working on a spreadsheet at 2 in the morning. Thanks!
Posted 5:06 PM on Mar. 25, 2012 ↑
hahaha… I’ve been looking for this for an hour…
Posted 7:50 PM on Mar. 27, 2012 ↑
THANK YOU!!!!
Posted 7:53 AM on Apr. 4, 2012 ↑
Thank you thank you thank you!
Posted 2:25 PM on Apr. 9, 2012 ↑
Thank you for this. Greatly appreciated. Found CTRL_OPTION and Option-Command combined with return key or enter key on the extended wired Apple keyboard both work for me in Excel
Posted 6:18 PM on Apr. 11, 2012 ↑
One more voice of thanks! Your explanation was concise, spot-on, and just what I needed.
Posted 6:19 PM on Apr. 11, 2012 ↑
Thanks for posting this. Trying to figure these things out sometimes takes so much time and being new to Macs appreciate the tip. Good job.
Michael
Posted 10:31 AM on Apr. 19, 2012 ↑
Cheers, brother.
Posted 6:44 AM on Apr. 27, 2012 ↑
Thanks so much. Been wondering about this for a long time…
Best from New York!
wmk
Posted 9:01 AM on Apr. 28, 2012 ↑
You’re the man. Thank you.
Posted 7:05 PM on Apr. 29, 2012 ↑
Thank you very much.. Cheers!!
Posted 2:18 AM on May. 14, 2012 ↑
Thaaaaank you so much!!!
Posted 4:55 AM on May. 17, 2012 ↑
just wanted to say thank you so much for sharing your insight on what was such a mystery to me!! it’s so simple!!
Posted 2:04 PM on May. 22, 2012 ↑
thank you! I have been trying to figure this out forever.
Posted 5:29 PM on May. 25, 2012 ↑
I “second” all of this praise. You’re so popular now – You should run for President!
(I have learned and forgotten this trick so many times – now I’ve bookmarked your page)
Posted 8:55 PM on May. 29, 2012 ↑
Ha!
“Has my opponent ever taught you tricks for using Excel? I thought not! I promise that once I’m elected, every citizen will know how to properly enter a linebreak in Microsoft programs, regardless of race, class, or creed!”
Yeah; I’m definitely ready.
Posted 9:01 PM on May. 29, 2012 ↑
Brilliant! thanks!
…. now why didn’t the help topic tell me that?
Posted 1:24 AM on Jun. 12, 2012 ↑
So awesome.. I was finding it a pain in the neck to hit the space bar the whole time.. this is saving me so much time! Could not find in the excel help section. Thank you!!
Posted 11:23 PM on Jun. 19, 2012 ↑
Thankyouverymuch mate!
Posted 6:12 AM on Jun. 26, 2012 ↑
Thank you – have been trying to work this out for weeks!!
Posted 7:56 AM on Jul. 16, 2012 ↑
thanks! Google rightly showed ur page in the top of the searches.
Posted 6:59 PM on Jul. 21, 2012 ↑
thanks so much for posting this – from moscow, russia
Posted 2:57 AM on Jul. 24, 2012 ↑
It has taken me 12 months with my new Mac of going round the bend trying to work this out…until I found your site. Many thanks for this :)
Posted 2:02 PM on Jul. 24, 2012 ↑
Thank you! I’d been trying to figure it out. Much needed info. :)
Posted 6:33 AM on Jul. 30, 2012 ↑
Thanks !!! So Helpful!!!
Posted 12:00 PM on Aug. 2, 2012 ↑
Ah, the gurus at Microsoft can’t tell us their master’s secrets, but Beckism releases them to the masses….
A thousand blessings on you sir.
Posted 6:33 AM on Aug. 3, 2012 ↑
Thank you a whole lot, now if you have any idea how to have the set background image print, please share.
All I find is, you can’t print it, then why would you even bother with a background image !
Posted 1:19 AM on Aug. 7, 2012 ↑
Really small thing that made me very happy. Thanks.
Posted 5:06 PM on Aug. 10, 2012 ↑
thanks. BTW, someone mentioned COMMAND-option-enter. Looks to me like they *both* work; ie, COMMAND-option-enter OR CONTROL-option-enter.
Also, someone had a question about removing a line break in a cell. I just tried putting the cursor at the beginning the next line and hitting delete, and that seems to work.
Posted 3:16 PM on Aug. 14, 2012 ↑
3 years later and your TIP is still one of the better painkillers.
thanks a million, this one caused me some serious headache
Posted 6:10 PM on Aug. 26, 2012 ↑
Yes and yes. Thanks for the tip!
Posted 6:22 PM on Aug. 28, 2012 ↑
Thank you! I was going crazy until I found this tip – still useful 4 years later!
Posted 9:22 PM on Aug. 29, 2012 ↑
Thanks!
Posted 6:20 PM on Sep. 10, 2012 ↑
Thank you! I just switched to a Mac and couldn’t work out how to add line breaks. You saved me :-)
Posted 5:06 AM on Sep. 12, 2012 ↑
Tx! You are now showing up very high on Google search!
Posted 2:43 AM on Oct. 3, 2012 ↑
Thank you!!!
Posted 5:50 PM on Oct. 15, 2012 ↑
Thanks a lot! There is a lot of little tricks that one has to master to ride one’s Mac efficiently. Especially after 10 years on Windows PC’s.
Posted 2:07 AM on Oct. 16, 2012 ↑
Thank you so much for the information! Really helpful.
Posted 10:54 AM on Oct. 22, 2012 ↑
Thanks Appreciate you taking the time to publish this little tip which has obviously been greatly appreciated by many!
Posted 10:19 AM on Oct. 25, 2012 ↑
thanx a lot..saved my life
Posted 11:40 AM on Oct. 25, 2012 ↑
Wait, what is this for? I am trying to make a long list of words one line. Will this work?
Posted 6:09 AM on Nov. 2, 2012 ↑
No, this tip is for creating linebreaks within a single cell. If you want to have a list of words on one line then you’ll probably be either using a single cell without linebreaks or multiple consecutive cells.
Posted 7:37 AM on Nov. 2, 2012 ↑
Thanks indeed!
Posted 11:17 AM on Nov. 26, 2012 ↑
You have no idea how incredibly useful this is. Almost more useful than spellcheck itself. Well, maybe that’s a bit overboard, but still!
Posted 3:32 PM on Nov. 27, 2012 ↑
Thanks a lot !! Awesome !!
Posted 8:51 AM on Dec. 17, 2012 ↑
I know this if off topic but I’m looking into starting my own blog and was wondering what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny?
I’m not very internet savvy so I’m not 100% sure. Any recommendations or advice would be greatly appreciated. Cheers
Posted 2:51 PM on Dec. 24, 2012 ↑
God bless you! You solved a major “PITA” for me in seconds!
Posted 12:30 PM on Dec. 27, 2012 ↑
And still helping people into 2013!!! Thanks. :-)
Posted 2:51 AM on Jan. 3, 2013 ↑
Just what I was looking for. Thanks!
Posted 6:34 AM on Jan. 4, 2013 ↑
Another fan–your tip improved my day. Thank you for taking the time to share.And, you were at the very top of the Google search results.
Posted 10:00 AM on Jan. 5, 2013 ↑
thanks for sharing that! I was getting mad.
Posted 1:11 PM on Jan. 13, 2013 ↑
THANK YOU SO MUCH!!!!!!! YOURE THE GREATEST!!!!
Posted 1:31 PM on Jan. 14, 2013 ↑
Lifesaver!
That was killing me.
I can’t believe the first post was in 2009 and the most recent was yesterday.
Posted 5:44 PM on Jan. 15, 2013 ↑
Your latest grateful reader!!! God I love the internet!!
Thanks heaps for posting. :)
Posted 7:29 PM on Jan. 20, 2013 ↑
I see I’m already the 7th person in 2013 to share gratitude. You just saved me from wasting another 40
frustrating minutes trying to figure this out – on deadline! May blessings rain upon you!
Posted 3:13 PM on Jan. 29, 2013 ↑
THANKS sooooo much!
Posted 7:33 AM on Feb. 12, 2013 ↑
Thanks!!
Posted 3:18 AM on Feb. 25, 2013 ↑
Thanks a lot man, i’ve been looking for this since a while
Posted 6:06 AM on Feb. 25, 2013 ↑
JUST what I was looking for! THANK YOU!
Posted 2:45 PM on Feb. 26, 2013 ↑
Thank goodness people take the trouble to post these kinds of tips – this saved a bunch of time. Thanks!
Posted 11:38 AM on Mar. 13, 2013 ↑
Thanks, this worked perfectly…
Posted 2:44 AM on Mar. 18, 2013 ↑
Thanks, helped me too, awesome!
Posted 1:57 AM on Mar. 22, 2013 ↑
FINALLY!! Thank you so much for sharing this. I’ve been using Excel for years and this has always frustrated me beyond belief.
You should write their help module!
Posted 7:17 PM on Mar. 27, 2013 ↑
Thanks a lot!! That helped me!!
Posted 11:55 PM on Mar. 29, 2013 ↑
THANK YOU!
Posted 5:24 AM on Apr. 4, 2013 ↑
Thanks man!
..this little things drive me crazy!
Cheers!
Posted 11:52 AM on Apr. 7, 2013 ↑
Finally a working advice.
Thank you!
Posted 8:23 AM on Apr. 24, 2013 ↑
I’ve tried to figure this out for – well – ages! Thanks so much for the tip.
Posted 5:46 PM on Apr. 27, 2013 ↑
Thanks!!!
Posted 4:55 AM on Apr. 30, 2013 ↑
Thank you! It works!
Posted 10:09 AM on Apr. 30, 2013 ↑
Thank you SO VERY MUCH for sharing this info! Extremely helpful and you saved us a lot of time. Appreciate it!
Posted 9:08 AM on May. 1, 2013 ↑
seriously you are awesome, thanks for this.
Posted 2:21 PM on May. 3, 2013 ↑
Thank you. I need it, and it help me.
Posted 5:56 AM on May. 5, 2013 ↑
Thank you!
Posted 4:42 PM on May. 5, 2013 ↑
Thanks! Your post is still helping people around the world. Something MS Excel ‘Help’ doesn’t do very well.
Posted 3:30 AM on May. 11, 2013 ↑
Yeah! Still applicable in 2013! So glad excel is smart enough to tell us this info themselves! :|
Posted 12:37 PM on May. 16, 2013 ↑
Awesome, thanks!
Posted 9:51 AM on May. 21, 2013 ↑
Still helping people. May, 2013.
Posted 12:28 PM on May. 21, 2013 ↑
Thank you!!
Posted 3:39 PM on May. 22, 2013 ↑
Thank you!!
Posted 3:39 PM on May. 22, 2013 ↑
5 years and going strong. Thanks!
Posted 1:51 PM on May. 27, 2013 ↑
you deserve to be a top google search for this query!
THANKS
Posted 5:55 AM on May. 28, 2013 ↑
Ditto on Carry’s comment! Thanks for the excel tip. This really keeps the cells looking clean.
Posted 12:03 PM on May. 29, 2013 ↑
You need to double-click directly in the cell that you want to put a line-break. Doing this the old Microsoft way in the top part of the screen (the formula bar) where you can see what’s in the cell. For example, if you enter a formula +c5+d5 in a cell, the cell itself will show you the result of the formula but the formula bar will show the actual formula. You used to be able to put a line break while you’re in the formula bar but with Excel for Mac, you have to be in the cell itself for the Option+Command+Enter to insert a line break.
Posted 9:39 AM on Jun. 1, 2013 ↑
thanks for the tip on entering the new line within a cell on a mac
Posted 1:21 PM on Jun. 3, 2013 ↑
Please God never let this post go down.
Posted 9:03 PM on Jun. 4, 2013 ↑
And God spoke, saying, “Yea, so long as Mr. Beck can afford web hosting, so shall it be.” And the people heard, and were comforted.
Posted 9:21 PM on Jun. 4, 2013 ↑
thanks !! fantastic !!
Posted 10:22 AM on Jun. 6, 2013 ↑
Thanks. Still useful!.
And they still haven’t put in it the help..:)
Posted 8:58 AM on Jun. 7, 2013 ↑
Many thanks – another great tip – saved me hours!!
Posted 8:59 AM on Jun. 14, 2013 ↑
Thanks a million. Was tearing my hair out!
Posted 7:33 PM on Jun. 17, 2013 ↑
You don’t know how long I have been trying to figure this one out. Thanks!
Posted 3:37 AM on Jun. 23, 2013 ↑
THANKS! I kept trying to do it the Windows way :P
Posted 6:09 PM on Jun. 24, 2013 ↑
Still helping folks WELL into 2013… Was going mad hitting site after site and seeing “Alt + Enter” and it wasn’t until I found this page that I understood that they were sharing the PC solution. Thank you for restoring a bit of my sanity.
Posted 11:02 AM on Jun. 26, 2013 ↑
And on across the years….
YAY! Cataloguing my haiku – really need those line breaks. THANKS!
Posted 1:40 PM on Jun. 26, 2013 ↑
I’ve been trying to figure that out for days! thank you!
Posted 4:53 PM on Jun. 27, 2013 ↑
Thanks, like many others Excel help was…no help :-) Your tip worked perfectly
Posted 11:37 AM on Jun. 29, 2013 ↑
Si Latine scis, istud mihi placuit magnopere! Thanks!
Posted 9:09 AM on Jun. 30, 2013 ↑
Thanks!
Posted 5:00 PM on Jun. 30, 2013 ↑
Used Excel for 20 years but couldn’t remember what this was on a Mac – so thanks. I wish Microsoft produced printed manuals like the old days but I guess Googling is still faster :)
Posted 4:11 AM on Jul. 6, 2013 ↑
Thanks a million!
Posted 9:14 AM on Jul. 19, 2013 ↑
Wow… This has been bugging me for a long time. Haha, such an easy solution too :-)
Posted 2:11 PM on Jul. 20, 2013 ↑
Thanks so much… couldnt find it in help anywhere grrrr
I also moved from PC to Mac… very disappointing in some regards.
Posted 4:59 AM on Jul. 21, 2013 ↑
It’s simple – when you know how!
Posted 7:44 AM on Jul. 26, 2013 ↑
Great tip – thanks
Posted 10:11 AM on Jul. 27, 2013 ↑
Thank you!!! Why can’t Mac just tell me that. Guess they’re anti-Excel. Foolish.
Posted 5:41 AM on Jul. 31, 2013 ↑
It’s 3:48am. And I needed to know how to put a linebreak in Excel for Mac, in order to submit a report. Thanks for posting the tip.
Posted 2:50 AM on Aug. 9, 2013 ↑
Geez, thank you! I guess this post is the post that keeps on giving. I was just having a laugh with my Dad the other day about how spreadsheets are what turned the PC from a toy to a business tool. Wish Apple would understand that…
Posted 4:04 PM on Aug. 14, 2013 ↑
Thank you so much for this…my Masters Dissertation is just that tiny bit better becuase of this
Posted 3:30 AM on Aug. 31, 2013 ↑
First google option I see when looking for this. And you sir are a genious!
Thanks!
Posted 4:36 PM on Sep. 6, 2013 ↑
this saved my life today I can’t believe it worked like pixie magic right in front of my face!
Posted 10:38 AM on Sep. 11, 2013 ↑
Brilliant! Thank you.
Posted 8:08 AM on Sep. 13, 2013 ↑
A post over 5 years old and someone (me) is still finding it useful :-)!
Posted 8:31 AM on Sep. 13, 2013 ↑
You rock!!! I knew the shortcut for doing this a PC but not the Mac and it’s been driving me crazy as I find myself using a Mac where I work. Thank you!!!! :)
Posted 8:52 AM on Sep. 19, 2013 ↑
thanks!
Posted 9:36 AM on Sep. 30, 2013 ↑
Thanks – much appreciated.
Posted 3:32 PM on Oct. 3, 2013 ↑
Leave it to Microsoft to SCREW things up. Why couldn’t it be Command-Enter, Control-Enter, or since the key is labeled, OPTION-ENTER. OMG, Winblows!
Posted 6:06 PM on Oct. 6, 2013 ↑
Awesome! Was looking all over and here it was, made simple. Thanks!
Posted 4:29 PM on Oct. 8, 2013 ↑
Thanks buddy!! it was really helpful !
Posted 5:10 AM on Oct. 9, 2013 ↑
Thanks so much. It helped me greatly :)
Posted 6:45 PM on Oct. 10, 2013 ↑
Thanks alot. It helped me . Cheers
Posted 12:14 AM on Oct. 12, 2013 ↑
Thank YOU!!!!
Posted 8:20 AM on Oct. 23, 2013 ↑
Thanks. That helped.
Posted 7:52 AM on Nov. 5, 2013 ↑
Thanks!
Posted 6:10 PM on Nov. 17, 2013 ↑
Thank you! I have been trying to figure this out for soooo long!
Posted 6:00 PM on Nov. 18, 2013 ↑
Thanks!
Posted 7:40 PM on Nov. 20, 2013 ↑
Control + Option + Return is golden on a Mac and I thank you for publishing this short little article to aid everybody in the world. I’m trying to think of something witty to say but it’s fleeing me. Anyway, thank you Ian Beck.
Posted 9:55 AM on Dec. 4, 2013 ↑
I never post to these things no matter how good the help has been but today I am. Thank you Ian Beck, for taking the time share. Happy Holidays.
Posted 5:00 PM on Dec. 18, 2013 ↑
Greetings from 2014. Thank you.
Posted 10:29 AM on Jan. 6, 2014 ↑
Thanks, it helped me a lot! :-)
Posted 11:51 AM on Jan. 7, 2014 ↑
FINALLY!!! some actual useful help and straight to the point. Thank so very much for much needed help.
Posted 12:21 AM on Jan. 15, 2014 ↑
Thanks very much!!!
Posted 5:23 AM on Jan. 24, 2014 ↑
Thanks so much!!! I have been looking for this command for so long!
Posted 6:45 PM on Jan. 28, 2014 ↑
six years on from your post, thank you. It was really annoying me, as I use a PC at work and a Mac at home and just could not work out how to do it!
Posted 5:12 PM on Jan. 31, 2014 ↑
Same here!
Posted 12:14 PM on Feb. 27, 2014 ↑
Good to know, thanks!
Posted 11:16 AM on Mar. 25, 2014 ↑
I love that your post from 2008 is still found useful today, funny how something so little and what seems simple can be quite annoying when you just want it to work :)
thanks Ian!!
Posted 7:48 AM on Mar. 28, 2014 ↑
Thank you so much..
Posted 10:03 PM on Apr. 3, 2014 ↑
Can you run for world leader, please?
Posted 4:50 AM on Apr. 7, 2014 ↑
Thanks! Your posting this has saved time and frustration for many!
Posted 9:18 AM on Apr. 28, 2014 ↑
This is AWESOME, thank you!
Posted 7:10 PM on May. 12, 2014 ↑
Thanks, this helped and saved me a lot of time!! Cheers
Posted 1:14 PM on May. 14, 2014 ↑
Thanks!
Posted 1:44 PM on May. 22, 2014 ↑
You’re wonderful. Thank you!
Posted 7:24 AM on May. 26, 2014 ↑
Thanks a lot… simple answer are the best !!!!!
Posted 10:38 AM on Jun. 12, 2014 ↑
You are a LIFE SAVER!!! 6 years later and this little tip is still helping people :)
Posted 4:20 AM on Jul. 13, 2014 ↑
You are the very, very, very best.
Posted 2:16 PM on Jul. 16, 2014 ↑
Thank you ^^
Posted 6:46 PM on Jul. 26, 2014 ↑
Thank you -just using a Mac for first time
and love knowing things like this,
grateful to you -muchas gracias,
sir!
Posted 12:29 AM on Aug. 27, 2014 ↑