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

59 comments:

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

    ReplyDelete
  2. who would've guessed! thanks for the tip

    ReplyDelete
    Replies
    1. 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. Thanks for the tip!

    ReplyDelete
  4. Replies
    1. 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. not work for me on mac

    ReplyDelete
  6. Thanks you so much :)

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

    Thanks!

    ReplyDelete
  8. Replies
    1. 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
  9. 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
  10. 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. 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
  11. 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. 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
  12. Thanks - you saved me such frustration!

    ReplyDelete
  13. 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. 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. Thanks for the short and sweet answer...

    ReplyDelete
  15. 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
  16. 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
  17. 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
  18. 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. 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
  19. Thank you!! The "shortcuts" on Mac Excel are so terribly frustrating - e.g., control + fn + command + tilde + 'J' - Arggg!

    ReplyDelete
    Replies
    1. 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
  20. Thanks for this - was driving me crazy!

    ReplyDelete
  21. THANK YOU THANK YOU THANK YOU!!!

    ReplyDelete
  22. 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
  23. Thank you!! That was driving me insane!!

    ReplyDelete
  24. 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
  25. Great article ...Thanks for your great information, I will be waiting for your next post.

    ReplyDelete
  26. 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
  27. For carriage returns -
    Toggle to the 'table inspector', uncheck 'Return key moves to next cell'
    Hit return - voila magic.

    ReplyDelete
  28. 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
  29. This comment has been removed by the author.

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

    ReplyDelete
    Replies
    1. The best solution seems the following
      =SUBSTITUTE(A1,CHAR(13),"")

      Delete
  31. 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
  32. 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
  33. 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
  34. Delta airline ticket reservations Traveling can be viewed as such an exciting movement that permits voyagers to investigate their fantasy objections.

    ReplyDelete
  35. 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
  36. 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