Saturday, April 30, 2011

Mac Excel 2011 (in Microsoft Office) -- Carriage Return in Cell

How to get enter a "Carriage Return in Cell" in Excel 2011 in Microsoft Office?

Windows: Alt + Enter
Mac: Control + Option + Enter
Labels: , , , , ,

59 comments:

  1. AnonymousMay 17, 2011 at 11:58 PM

    Thank you for this!! Couldn't remember how to do this for Mac.

    ReplyDelete
  2. AnonymousJune 3, 2011 at 9:22 AM

    who would've guessed! thanks for the tip

    ReplyDelete
    Replies
    1. NuZetaOctober 16, 2013 at 11:05 AM

      You can check that following , I have updated with several related short-cuts
      http://mymacslife.blogspot.hk/2013/05/excel-2010-shortcut-mac-vs-windows-part.html

      Delete
  3. AnonymousDecember 22, 2011 at 8:42 PM

    Thanks for the tip!

    ReplyDelete
  4. UnknownJanuary 3, 2012 at 11:32 PM

    THANK YOU!!

    ReplyDelete
    Replies
    1. NuZetaOctober 16, 2013 at 11:05 AM

      You can check that following , I have updated with several related short-cuts
      http://mymacslife.blogspot.hk/2013/05/excel-2010-shortcut-mac-vs-windows-part.html

      Delete
  5. AnonymousFebruary 7, 2012 at 2:13 PM

    not work for me on mac

    ReplyDelete
  6. MatheosMarch 30, 2012 at 5:56 PM

    Great!!! thanks for sharing.

    ReplyDelete
  7. AnonymousMay 5, 2012 at 7:07 PM

    Thanks you so much :)

    ReplyDelete
  8. AnonymousJune 20, 2012 at 9:42 PM

    Thanks!

    ReplyDelete
  9. AnonymousJuly 1, 2012 at 8:54 PM

    Hei, guys/gals! Great tip. But, is it possible to enter a code for a CR in a if...else...end structure?

    Thanks!

    ReplyDelete
  10. UnknownAugust 17, 2012 at 2:39 AM

    thanks!

    ReplyDelete
    Replies
    1. NuZetaOctober 16, 2013 at 11:05 AM

      You can check that following , I have updated with several related short-cuts
      http://mymacslife.blogspot.hk/2013/05/excel-2010-shortcut-mac-vs-windows-part.html

      Delete
  11. AnonymousAugust 17, 2012 at 5:36 PM

    Thanks so much. I've tried every combination of key strokes I could think of (except this one, of course). It's a miracle smoke hasn't start coming out of my laptop's ears (keys, optical drive, etc.).

    ReplyDelete
  12. AnonymousSeptember 4, 2012 at 5:44 PM

    Option key = alt key, I have to again google this to find out what you meant by the above. It says 'alt' on the Mac keyboard so it would be more useful if you had used that term in the above

    ReplyDelete
    Replies
    1. AnonymousDecember 1, 2012 at 2:43 AM

      Option Key apparently = alt key ONLY when used with Control key. Otherwise it would work just like it does in Windows - which of course it does not.

      Delete
  13. random chickSeptember 5, 2012 at 10:29 PM

    whew.. worked. been trying to figure this out!!
    this mac is killing me. totally can't find any of the right shortcut keys.
    thank you so much!

    ReplyDelete
    Replies
    1. NuZetaOctober 16, 2013 at 11:03 AM

      You can check that following , I have updated with several related short-cuts
      http://mymacslife.blogspot.hk/2013/04/useful-shortcuts-about-filling-cells.html

      Delete
  14. AnonymousNovember 9, 2012 at 8:09 AM

    Thanks!

    ReplyDelete
  15. AnonymousNovember 9, 2012 at 11:00 PM

    Thanks - you saved me such frustration!

    ReplyDelete
  16. AnonymousNovember 13, 2012 at 5:38 AM

    Thank you! Since the Windows command is Alt + Return, I was surprised that the Mac command wasn't Option + Return. Ah well...
    Thanks again!

    ReplyDelete
    Replies
    1. NuZetaOctober 16, 2013 at 11:03 AM

      You can check that following , I have updated with several related short-cuts
      http://mymacslife.blogspot.hk/2013/04/useful-shortcuts-about-filling-cells.html

      Delete
  17. AnonymousDecember 1, 2012 at 2:45 AM

    Thanks for the short and sweet answer...

    ReplyDelete
  18. AnonymousJanuary 23, 2013 at 2:49 PM

    You are a god-sent!! Thank you!! I had wasted so much time trying everything. Know how for Microsoft but not for Mac. Now I do, thanks to you.

    ReplyDelete
  19. AnonymousFebruary 15, 2013 at 10:20 PM

    Star!

    ReplyDelete
  20. UnknownMarch 6, 2013 at 6:33 PM

    Thanks, guy!!

    ReplyDelete
  21. KendraMarch 19, 2013 at 12:13 AM

    HALLELUJAH!

    ReplyDelete
  22. hkinsaulMarch 27, 2013 at 7:51 AM

    Any idea how to drop the information from the cell above, i.e. CTR + D on windows?? Lifesaver if so (oh and thanks for this as well!)

    ReplyDelete
  23. NuZetaApril 2, 2013 at 4:46 PM

    The fill Down function is the same Windows
    CTR + D

    For more Excel related shortcut, please refer to my other issue in the same blog.

    ReplyDelete
  24. UnknownMay 24, 2013 at 7:12 PM

    THANK YOU!!!

    ReplyDelete
  25. AnonymousJune 1, 2013 at 5:43 PM

    the Mac: Control + Option + Enter It is not entirely correct.
    you have to go out of the cell and back in to perform this action
    Does anybody have a remedy to bypass this annoying extra action.

    ReplyDelete
    Replies
    1. AnonymousJuly 19, 2013 at 3:14 PM

      No you don't, something is wrong with your Excel.
      I use that key combination many times in the same cell without needing to go out of it.

      Delete
  26. AnonymousJuly 20, 2013 at 1:58 AM

    THANK YOU!!

    ReplyDelete
  27. AnonymousAugust 16, 2013 at 9:24 AM

    Thanks!

    ReplyDelete
  28. tiekimAugust 28, 2013 at 4:51 AM

    Thank you!! The "shortcuts" on Mac Excel are so terribly frustrating - e.g., control + fn + command + tilde + 'J' - Arggg!

    ReplyDelete
    Replies
    1. NuZetaOctober 16, 2013 at 11:06 AM

      You can check that following , I have updated with several related short-cuts
      http://mymacslife.blogspot.hk/2013/05/excel-2010-shortcut-mac-vs-windows-part.html

      Delete
  29. AnonymousSeptember 4, 2013 at 6:28 AM

    Cheers big ears!

    ReplyDelete
  30. MarkOctober 8, 2013 at 6:09 PM

    Thanks for this - was driving me crazy!

    ReplyDelete
  31. AnonymousMarch 19, 2014 at 7:10 AM

    THANK YOU!!!

    ReplyDelete
  32. AnonymousApril 24, 2014 at 11:27 PM

    THANK YOU THANK YOU THANK YOU!!!

    ReplyDelete
  33. computerteachMay 7, 2014 at 6:30 PM

    By getting Excel training in new york you would know the importance of excel.Excel has a helpful built in tool that lets you define what you want the outcome of a formula to be. By showing excel which variable to change in order to get the desired formula result many questions can be answered.

    ReplyDelete
  34. UnknownSeptember 30, 2014 at 3:14 AM

    Thank you for this tip!

    ReplyDelete
  35. Erica AOctober 7, 2014 at 4:29 AM

    Thank you!! That was driving me insane!!

    ReplyDelete
  36. roll call the bookOctober 23, 2014 at 8:39 PM

    Can you help me figure out how to copy and paste public domain books and then format them in word for mac 2011? I paste it and it comes out unformatted and I have to go line by line to remove hyphens and fix the sentence and paragraph structure. My Facebook is under Author Glenn Langohr. I can pay you a little.

    ReplyDelete
  37. TechnogigsMay 25, 2015 at 1:30 PM

    Great article ...Thanks for your great information, I will be waiting for your next post.

    ReplyDelete
  38. AnonymousJuly 17, 2015 at 12:42 AM

    Great tips for creating carriage returns via Mac Excel, but you also have a method for removing carriage returns from a cell? All tips I can locate are to use the find/replace functionality but they are for a PC and do not translate to the Mac. Any help is appreciated!

    ReplyDelete
  39. AnonymousNovember 10, 2015 at 12:23 PM

    For carriage returns -
    Toggle to the 'table inspector', uncheck 'Return key moves to next cell'
    Hit return - voila magic.

    ReplyDelete
  40. juanjuergensMay 17, 2017 at 5:06 AM

    Thank you for some other informative blog. Where else could I get that type of information written in such an ideal means? I have a mission that I’m just now working on, and I have been at the look out for such information.
    excel vba courses london

    ReplyDelete
  41. AnonymousAugust 2, 2018 at 6:46 AM

    This comment has been removed by the author.

    ReplyDelete
  42. AnonymousAugust 2, 2018 at 6:47 AM

    How do you remove them using find/replace ? I have a Mac Excel 2011

    ReplyDelete
    Replies
    1. NuZetaNovember 26, 2018 at 11:26 AM

      The best solution seems the following
      =SUBSTITUTE(A1,CHAR(13),"")

      Delete
  43. martin lutharMay 2, 2019 at 2:39 AM

    I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. If you are looking for antivirus security for your PC and any other digital devices than. Visit@: my sites :-
    mcafee.com/activate

    mcafee.com/activate

    norton.com/setup

    ReplyDelete
  44. delta airlines flight reservationsOctober 1, 2020 at 3:50 PM

    Going To delta airlines flight reservations can be viewed as such an exciting action that permits voyagers to investigate their fantasy objections. In this way, on the off chance that you need to investigate the hypnotizing magnificence of nature

    ReplyDelete
  45. delta airlines book flightOctober 1, 2020 at 3:50 PM

    Delta airline book flight gives two unmistakable approach to finish Delta Airlines reservations. Initially you can finish the booking cycle on the aircraft's authentic site. Recollect that the carrier gives online installment techniques.

    ReplyDelete
  46. delta airlines ticket reservationsOctober 1, 2020 at 3:51 PM

    Delta airline ticket reservations Traveling can be viewed as such an exciting movement that permits voyagers to investigate their fantasy objections.

    ReplyDelete
  47. Delta Airlines Vacations PackegsOctober 1, 2020 at 3:52 PM

    On the off chance that you are searching for a moderate Delta Airlines Vacations packages, at that point Delta is here to get you secured.

    ReplyDelete
  48. Aol Sign inAugust 12, 2021 at 8:15 PM

    Most of us are unaware of the fact that we can take a hard copy of the emails that are available in our aol mail login account. This feature may not be found in other email clients but is specifically available for AOL mail account holders. As you can see, using the "Print" feature is pretty easy and can be used on any email in any folder of your account. PayPal Login | www.Amazon.com/mytv | Yahoo Mail not working | Yahoo Mail Login

    ReplyDelete

Subscribe to: Post Comments (Atom)