Summary

In this chapter, first, you saw how the Quick Access Toolbar is evolving in Microsoft 365 and how to unhide the toolbar if needed. The Quick Access Toolbar allows you to create up to 44 custom keyboard shortcuts in Excel for Windows, but if you’re not aware of the nuance, you might be baffled why, let’s say, a heart or spade appears in your worksheet cell instead of carrying out a command. We always hold down the Ctrl key when executing a shortcut such as Ctrl + Z, but we must use an alternate behavior for the Alt key. Remember to tap the Alt key if you want to your number pad to execute a shortcut. You have complete control over the order of your icons, which enables you to prioritize the keyboard shortcuts.

We explored ways to create shortcuts for Ribbon commands that don’t have shortcuts, and we dug into the Commands Not in the Ribbon area to unearth commands that can streamline repetitive tasks. You can add commands to your default Quick Access...