Part IV: Using Advanced Excel Features
544
FIGURE 23.3Use the Quick Access Toolbar tab in the Excel Options dialog box to customize the Quick Access toolbar.
Some of the items in the drop-down list arel Popular Commands: Displays commands that Excel users commonly usel (^) Commands Not in the Ribbon: Displays a list of commands that you cannot access from
the Ribbon
l (^) All Commands: Displays a complete list of Excel commands
l Macros: Displays a list of all available macros
l (^) File Tab: Displays the commands available in the Backoffice menu
l Home Tab: Displays all commands available when the Home tab is active
In addition, the Choose Commands From drop-down list contains an item for every other tab. To
add an item to your Quick Access toolbar, select it from the list on the left and then click Add. The
command appears in the list on the right.
Tip
You can create a Quick Access toolbar configuration that’s specific to a particular workbook. In other words,
the commands on the Quick Access toolbar appear only when a particular workbook is active. Start by activat-
ing the workbook, and then display the Customize Quick Access Toolbar tab of the Excel Options dialog box.
When you add a command to the Quick Access toolbar, use the drop-down list in the upper right to specify the
workbook (only the active workbook is available as a choice). By default, customizations are For All
Documents option. n