Excel doesn’t allow you to view or specify keyboard shortcutsFebruary 1, 2012
One of the things I like about Word is that you can specify your own keyboard shortcuts for your macros and for functions that don’t already have a key combination. Or you can modify those that are already assigned in Word (though I wouldn’t advise it, because if you have to reinstall Word or you use someone else’s machine your keyboard shortcuts won’t work the same as the ones you’ve set up for your installation of Word).
Assigning keyboard shortcuts has been a feature in Word for years, and I just assumed that the other Office products would have similar functionality. Not so. I was alerted to this lack because of a comment on one of my blog posts — Ctrl+Shift+C activates the Format Painter in Word, but doesn’t do so in Excel, even though Excel also has the Format Painter function.
Microsoft Excel 2010 (and likely earlier versions), does NOT have any option available to view existing key combinations or to create your own. And on further investigation nor does PowerPoint 2010, Visio 2010, or Outlook 2010 (I didn’t check all the Office programs).
For example, here’s the Word 2010 screen with the option to assign a keyboard shortcut (found under File > Options > Customize Ribbon):
And here’s the same screen in Excel 2010 — nothing!:
I think this is a really big oversight by the Microsoft Office team. Those who use these products all day, every day, can be incredibly efficient using keystrokes instead of the mouse. I can’t believe that Microsoft has denied users the ability to add their own to existing functions.
Note: I understand that you can still assign a keyboard shortcut to a macro you create in Excel etc.
[Links last checked January 2012]