Microsoft Office Tutorials and References
In Depth Information
QUICK ACCESS TOOLBAR
You can add features you frequently use to the Excel
Quick Access toolbar. The Quick Access toolbar
enables you to access commands with a single click.
Right-clicking a Ribbon command provides you with
a way to add commands in the Ribbon to the Quick
Access toolbar easily.
You can also add features that are not in the Ribbon
to the Quick Access toolbar by accessing the
Customize Quick Access Toolbar screen and clicking
the commands you want to add. Excel divides the
commands into categories to make it easier for you
to find the command you want. You can specify
whether the command should appear on the toolbar
of all Excel workbooks or only on the Quick Access
toolbar in the workbook you specify. By default, the
button will appear in all workbooks. Task #s 8, 20,
36, 77, and 90 demonstrate features you must add
to the Quick Access toolbar before you can use them.
The Quick Access toolbar can appear above or below
A DD A F EATURE TO THE Q UICK A CCESS
Click here and select More
The Excel Options dialog box
opens to the Customize the
Quick Access Toolbar screen.
Click here and select a
Click here and select the scope
of the addition.
Click For All Documents if you
want to add the command to
the Quick Access toolbar in
Click the document name if you
only want to apply the option to
the current document.
Click the command you want to
add to the Quick Access
l The item moves to the list box
on the right.