Custom keyboard shortcuts not working for Excel contextual menu item

keyboardms office

I want to bind control-option-command-F to "Filter by Selected Cell's Value", a contextual menu item in Excel. As you can see in the screenshot

it appears to be associated with the correct menu item, but pressing this keyboard shortcut does nothing. Selecting this menu item with the mouse does trigger the expected behavior.

I tried binding this same combination to a regular menu item ("Split") and that worked fine, so I don't think it's an issue of this combination of keys being incompatible with another shortcut.

Can anyone explain to me why this is not working?

Best Answer

Check your System Preferences -> Keyboard -> Keyboard Shortcuts.

It may be that those keystrokes are already bound to a System function.

Related Solutions

MacOS – Changing keyboard shortcut for cycling through windows? (Lion)

Many applications like Terminal also have a menu item like Window > Cycle Through Windows. It stays assigned to ⌘` even if you change the shortcut in the Keyboard & Text Input preferences.

You could add a custom shortcut for Cycle Through Windows in the Application Shortcuts preferences, or disable it with defaults write -g NSUserKeyEquivalents -dict-add "Cycle Through Windows" nul.

You could also force TotalTerminal to use ⌘` by editing ~/Library/Preferences/com.apple.Terminal.plist directly.

<key>ToggleVisor</key>
<dict>
    <key>KeyCode</key>
    <integer>50</integer>
    <key>Modifiers</key>
    <integer>9437184</integer>
</dict>

This odd Excel file doing here

This is a known bug in Office for Mac 2011. The icons represent temporary files that have been deleted. (Probably before they were deleted they were invisible.) You cannot Get Info on the files or find the files via Terminal because they do not exists; the bug is that the Finder is still showing them. If you force-quit the Finder it will restart and the file icons will be gone.

The best workaround to keep them from coming back seems to be to move files off the desktop and into a folder before opening them.

Best Answer

Related Solutions

MacOS – Changing keyboard shortcut for cycling through windows? (Lion)

This odd Excel file doing here

Related Question