Microsoft Office Tutorials and References
In Depth Information
Adding buttons to the Quick Access Toolbar
6
On the View tab, in the Window group, click the Switch Windows button, and then
click PackageCounts to display the PackageCounts workbook.
7
On the View tab, in the Window group, click the Arrange All button to open the
Arrange Windows dialog box.
8
Click Cascade , and then click OK to cascade the open workbook windows.
CLEAN UP Close the PackageCounts and MisroutedPackages workbooks, saving your
changes if you want to.
Adding buttons to the Quick Access Toolbar
As you continue to work with Excel 2013, you might discover that you use certain
commands much more frequently than others. If your workbooks draw data from external
sources, for example, you might find yourself displaying the Data tab and then, in the
Connections group, clicking the Refresh All button much more often than the program’s
designers might have expected. You can make any button accessible with one click by
adding the button to the Quick Access Toolbar, located just above the ribbon in the upper-left
corner of the Excel program window.
To add a button to the Quick Access Toolbar, click the File tab to display the Backstage
view, and then click Options in the left pane. In the Excel Options dialog box, display the
Customize The Quick Access Toolbar page. This page contains two panes. The pane on the
left lists all of the controls that are available within a specified category, and the pane on
the right lists the controls currently displayed on the Quick Access Toolbar. To add a
command to the Quick Access Toolbar, in the Choose Commands From list, click the category
that contains the control you want to add. Excel displays the available commands in the
Search JabSto ::




Custom Search