microsoft excel keyboard shortcuts not working

#Microsoft excel keyboard shortcuts not working pro#

What's more, there is a shortcut key that opens the Split Cells dialog box. If we need to merge cells, then we need to merge cells, and Word provides a way to do it. Your comment about merged cells not being useful is irrelevant. The question was about a Word table, but your answer is about Excel. Shutting down rather than sleeping seems to cure a few.Bob, that's not a helpful answer at all. 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. If it happens again, reboting away from the wireless devices may be the trick!. I am not sure whether this is your problem and I did not check the CTRL + U shortcut, but it is odd. This morning, I booted the Mac, away from the wireless mouse and keyboard, and bingo, they are back. 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. Two days ago, I noticed that the clipboard (after taking screenshots) was not clearing and CMD+C and CMD+X had stopped working. I also have a wireless keyboard and a magic mouse.

#Microsoft excel keyboard shortcuts not working pro#

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. This may not be the same problem, but it is odd and as expected, the Apple Shop Genius guys had no clue. If that edits the cell, the behavior is because of the Keyboard system preference. Select a cell and instead of pressing F2, press Fn+F2. 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. (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.) keys as standard function keys.' When you do that, F2 will now function as F2 and not as screen brightness adjustment. Open System Preferences, click the Keyboard icon, click the Keyboard tab in there, and select the setting 'Use all F1, F2, etc. On F2: If pressing F2 changes your screen brightness instead of editing the active cell, then there is a setting you can change. 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. (I think that would work, anyway)īut ultimately my recommendation is that if you bought a Mac intending to commit to the Mac.then really commit to the Mac. Basically you would be swapping the two keys. 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.

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). 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. 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. On Control-U: I am wondering if this no longer works on your Mac because you remapped Command to Control. So I'm starting to think that there is a configuration problem somewhere on your Mac. I also pressed F2 and I was again able to edit it. I pressed Control-U and I was able to edit it. I opened up Mac Excel 2011 and selected a cell. I have just done a little experimenting and I think I have some idea of why you're having a problem.