Chapter 23: Customizing the Excel User Interface
543
Adding new commands to the Quick Access toolbar
You can add a new command to the Quick Access toolbar in three ways:l (^) Click the Quick Access toolbar drop-down control, which is located on the right side of
the Quick Access toolbar (see Figure 23.2). The list contains a few commonly used com-
mands. Select a command from the list, and Excel adds it to your Quick Access toolbar.
l Right-click any control on the Ribbon and choose Add to Quick Access Toolbar. The con-
trol is added to your Quick Access toolbar, after the last control.
l Use the Quick Access Toolbar tab in the Excel Options dialog box. A quick way to access
this dialog box is to right-click any Ribbon control and choose Customize Quick Access
Toolbar.
FIGURE 23.2
This drop-down list is one way to add a new command to the Quick Access toolbar.
The remainder of this section discusses the Quick Access Toolbar tab of the Excel Options dialog
box, shown in Figure 23.3.
The left side of the dialog box displays a list of Excel commands, and the right side shows the com-
mands currently on your Quick Access toolbar. Above the command list on the left is the Choose
Commands From drop-down list from which you can filter the list. Select an item from the drop-
down list, and the list displays only the commands for that item. In Figure 23.3, the list shows
commands in the Popular Commands category.