Many heavily used Excel features do not have shortcut keys assigned. But with KeyRocket you can assign your own shortcuts in Excel. In this text I show you how to set up a shortcut. This works for all Office products.
There are two ways to create a shortcut in Excel: Either while working via the shortcut notification or from within the shortcut browser.
On demand, while you work
When you use a function in Excel several times with the mouse, a missed shortcut notification pops up on the screen. If the feature has no shortcut assigned yet, the notification should show the ribbon access key combination and a shortcut field below to assign your own shortcut keys. The shortcut field already contains a suggestion. By pressing save you can assign the feature to the suggested shortcut. You can also override the suggestion by clicking inside the field and pressing the desired keys:
From within the shortcut browser
Just open the KeyRocket shortcut browser by pressing Win+Shift+K. Set the currently shown application to Excel (1.). Search for the feature in the search bar (2.). Press the small wrench icon to assign a custom shortcut (3.):
Then a shortcut field appears where you can enter the desired keys (4.). Finish by pressing Enter key:
And finally there it is: You now have assigned your own shortcut to a function in Excel: