Excel Printing Problems Format Mac Excel I

Excel Printing Problems Format Mac Excel I

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.

As youve 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.

So Im 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.

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.

Excel For Mac Printing Problems Format