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

53 comments:

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

    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
  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. 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
  7. Thanks you so much :)

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

    Thanks!

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

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

    ReplyDelete
  16. 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
  17. 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
  18. 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
    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
  19. 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
  20. 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
  21. 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
    2. 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
  22. Thanks for this - was driving me crazy!

    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
  23. THANK YOU THANK YOU THANK YOU!!!

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

    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
  26. 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
    Replies
    1. Let me change and get back to you later.

      Delete