Understanding the nuances of Quick Access Toolbar shortcuts

In Excel for Windows, every command on your Quick Access Toolbar is assigned an alphanumeric keyboard shortcut. (Excel for macOS does not offer this feature.) These keyboard shortcuts entail pressing the Alt key and a shortcut code determined by the position of a command in your Quick Access Toolbar. I’ll discuss how to reposition commands on the toolbar in the Repositioning and removing icons section a little later. As shown in Figure 3.6, when you tap the Alt key, onscreen tips will show you the keyboard shortcut associated with each command:

Figure 3.6 – The Quick Access Toolbar shortcut tips

The shortcut naming convention works as follows:

• The first nine shortcuts are assigned from 1 to 9, meaning you press Alt + 1 to access the first command, Alt + 2 for the second, and so on.
• The 10th through 18th shortcuts are assigned from 09 to 01, meaning you press Alt + 09 to access...