Microsoft Office Tutorials and References
In Depth Information
Customizing the Quick Access Toolbar
h Right-click any control on the Ribbon and choose Add To Quick Access Toolbar. The
control is added to your Quick Access toolbar, positioned after the last control.
h Use the Quick Access Toolbar tab of the Excel Options dialog box. A quick way to access
this dialog box is to right-click any Quick Access toolbar or Ribbon control and choose
Customize Quick Access Toolbar.
Figure 11-1: The Quick Access toolbar drop-down menu is one way to add a new command to the Quick
Figure 11-2 shows the Quick Access Toolbar tab of the Excel Options dialog box. The left side of
the dialog box displays a list of Excel commands, and the right side shows the commands that
are now on the Quick Access toolbar. Above the command list on the left is a drop-down control
that lets you filter the list. Select an item from the drop-down list, and the list displays only the
commands for that item.
Some of the items in the drop-down control are described in this list:
h Popular Commands: Displays commands that Excel users commonly use
h Commands Not In The Ribbon: Displays a list of commands that you cannot access from
h All Commands: Displays a complete list of Excel commands
h Macros: Displays a list of all available macros
h File Tab: Displays the commands available in the back stage window
h Home Tab: Displays all commands that are available when the Home tab is active
In addition, the drop-down list contains an item for every other tab.