Ctrl On For Excel Mac Select The

Ctrl On For Excel Mac Select The

On your Mac select the Apple icon () and click System Preferences Select Keyboard, and then make sure to click the Keyboard tab.

Check the box for: Show Keyboard Character Viewers in menu bar.

The screen shot above shows the Command and Shift keys are depressed.

The Keyboard Viewer will also show different symbols when you press various keys, like fn, Control, Option, Command, etc.

While depressing the fn key, the left arrow button changes its angle to point up about 30 degrees.

Knowing that allowed me to do a little testing in Microsoft Excel 2011 for the Mac.

The kind folks over at Excel Skin gave me an overlay that slips over the Mac keyboard and shows, via color coding, a wide array of shortcuts that work in Excel for Mac.

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.

I have purchased Microsoft Office for Mac, which is what Im using when I say Mac Excel I am a power excel user in PC Excel but am having a hard time in Macs excel, as many of the Mac excel shortcuts dont work.

For instance, to edit active cell, in Windows its an easy F2 shortcut, in Mac excel, U (shift U) isnt working.

In fact, none of the shortcuts (with the exception of the most basic like cut and paste (CtrlC, CtrlV in Windows) are working.

I switched my command button to be my control button, since Im so used to the PC keyboard layout, but I always press Macs CONTROL when a shortcut indicates to use the squigly square COMMAND button.

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.

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.

Thats 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 dont 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.

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 FnF2, because adding the Fn key always makes a function key do the opposite of whatever the Use all F1, F2.

You can try this out now.

If that edits the cell, the behavior is because of the Keyboard system preference.

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.

Two days ago, I noticed that the clipboard (after taking screenshots) was not clearing and CMDC and CMDX had stopped working.

Well, I may be crazy, but on the menu, next to cut and copy, where it used to list the shortcuts (CMDC and CMDX), 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.

Ctrl On Mac For Excel