Mac shortcuts not working in Mac Excel - MS Office.

I have the new 2013 MacBook Pro. I have purchased Microsoft Office for Mac, which is what I'm using when I say "Mac Excel" I am a power excel user in PC Excel but am having a hard time in Mac's excel, as many of the Mac excel shortcuts don't work. For instance, to edit active cell, in Windows its an easy "F2" shortcut, in Mac excel, ^+U (shift +U) isn't working. In fact, none of the shortcuts (with the exception of the most basic like cut and paste (Ctrl+C, Ctrl+V in Windows) are working. I switched my command button to be my control button, since I'm so used to the PC keyboard layout, but I always press Mac's CONTROL when a shortcut indicates to use the squigly square COMMAND button.

I just don't understand why the most basic shortcut like ^+U to edit an active cell isn't working in my Mac excel. So frustrating!

Thank you for any tips on how to fix the Mac excel problem with Mac shortcuts not working.


JYNYC

MacBook Pro with Retina display, OS X Mavericks (10.9.2)

Posted on Mar 14, 2014 7:50 PM

Reply
9 replies

Jun 3, 2014 2:37 PM in response to jyNYC

Not sure if this is what you're referring to but there is a way to correct your keystrokes in Excel. This just happened to me after I applied the latest Office update as well but the only way to restore Cmd+C (Copy) and Cmd+V (Paste) in Excel is to do the following:


1) Go to Menu in Excel "Tools" / "Customize Keyboard"

2) Highlight "Edit" in the "Categories" window

3) Highlight "Copy" in the "Edit" window

4) In the dialog box you'll see "Press new shortcut key"

5) Click in that window then type "Cmd+C" and click the "Add"

User uploaded file


A dialog box may pop up and ask if you want to reassign it to the newly selected command... click "Ok"

User uploaded file


Simply click on "Paste" in the "Edit" window and repeat for Cmd-V for Paste... from here you should be good to go!


Good luck!

Mar 14, 2014 8:48 PM in response to jyNYC

Nothing you can do but either learn the Mac shortcuts or install Windows to use PC Excel. As you've seen, you can remap the keyboard but really is 1 step forward, 1 step backward.


If you are a true PC Excel power user (you never touch the mouse), then you will find the Mac version extremely infuriating and better to run Windows Excel.

Mar 12, 2015 7:22 AM in response to JimN

I found that regardless of the keyboard customizations I attempted, the Excel edit menu continued to look like this:


User uploaded file


The solution that worked for me was to quit Excel and then delete the Excel playlist:

  1. Close Excel.
  2. In the Finder, click the “Go” menu with “option” key pressed simultaneously. Select Library. (Note: Library will not be visible if you are not holding down the option key).
  3. Open the Preferences folder.
  4. Delete com.microsoft.Excel.plist
  5. Empty Trash
  6. Restart Excel.

I actually had to do this a couple of times before the problem went away entirely. Hope this helps.


Greg

Mar 15, 2014 11:11 AM in response to jyNYC

I have just done a little experimenting and I think I have some idea of why you're having a problem.


I opened up Mac Excel 2011 and selected a cell. I pressed Control-U and I was able to edit it. I also pressed F2 and I was again able to edit it. So I'm starting to think that there is a configuration problem somewhere on your Mac.


On Control-U: I am wondering if this no longer works on your Mac because you remapped Command to Control. Because in Mac Excel, Command-U (apply underline formatting) and Control-U (edit selected cell) are two different features, so if you remapped Command to Control at the system level, Excel now behaves such that all Command-modifier shortcuts are now Control. Therefore, Command-U (underline text) is now Control-U, and whatever was Control-U before (edit active cell) is disabled since a shortcut can only mean one thing at a time. That's my theory on why Control-U stopped working for you: You told the Command-U feature (underline text) to replace the former Control-U feature (edit active cell).


One possible way to fix this is that because remapping Command to Control eliminates access to Control key shortcuts, you could also remap Control to Command so that you can regain access to shortcuts that need the Control key like Control-U. Basically you would be swapping the two keys. (I think that would work, anyway)


But ultimately my recommendation is that if you bought a Mac intending to commit to the Mac...then really commit to the Mac. Stop trying to use the Control key and learn the Command key so that in applications that make use of both Command and Control shortcuts, you don't lose an entire set of shortcuts when you remap.


On F2: If pressing F2 changes your screen brightness instead of editing the active cell, then there is a setting you can change. Open System Preferences, click the Keyboard icon, click the Keyboard tab in there, and select the setting "Use all F1, F2, etc. keys as standard function keys." When you do that, F2 will now function as F2 and not as screen brightness adjustment. (I like some F keys to be function keys and other F keys to be hardware keys, so I use a utility called FunctionFlip to set the behavior of each F key separately.)


The other way to do that is to not change the "Use all F1, F2...as function keys" setting but instead press Fn+F2, because adding the Fn key always makes a function key do the opposite of whatever the "Use all F1, F2..." setting is.


You can try this out now. Select a cell and instead of pressing F2, press Fn+F2. If that edits the cell, the behavior is because of the Keyboard system preference.

Apr 13, 2014 11:32 PM in response to Network 23

Hi

This may not be the same problem, but it is odd and as expected, the Apple Shop Genius guys had no clue.


I have moved to a Mac (2104 Macbook Pro with MS Office 2011) from years on a PC and worked out the new keys, just as have been mentioned above. I also have a wireless keyboard and a magic mouse. Two days ago, I noticed that the clipboard (after taking screenshots) was not clearing and CMD+C and CMD+X had stopped working. I had to use the Edit menu.


Well, I may be crazy, but on the menu, next to cut and copy, where it used to list the shortcuts (CMD+C and CMD+X), there was nothing! Being tired, I gave up.


This morning, I booted the Mac, away from the wireless mouse and keyboard, and bingo, they are back.


I am not sure whether this is your problem and I did not check the CTRL + U shortcut, but it is odd.


If it happens again, reboting away from the wireless devices may be the trick!.


I must admit, I always though Macs were immune to bugs and stupid things, but I have noticed a few in the first two months. Shutting down rather than sleeping seems to cure a few.


Good luck.

Tony

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Mac shortcuts not working in Mac Excel - MS Office.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.