Adding buttons to the Quick Access Toolbar
You
might discover that you use certain commands much more frequently than
others. 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 pane below
the Choose Commands From field. Click the control you want, and then
click the Add button.
You
can change a button’s position on the Quick Access Toolbar by clicking
its name in the right pane and then clicking either the Move Up or Move
Down button at the right edge of the dialog box. To remove a button from
the Quick Access Toolbar, click the button’s name in the right pane,
and then click the Remove button. When you’re done making your changes,
click the OK button.
If you saved your changes but want to return the Quick Access Toolbar to its original state, click the Reset button and then click either Reset Only Quick Access Toolbar, which removes any changes you made to the Quick Access Toolbar, or Reset All Customizations, which returns the entire ribbon interface to its original state.
If
you’d like to export your Quick Access Toolbar customizations to a file
that can be used to apply those changes to another Excel 2013
installation, click the Import/Export button and then click Export All
Customizations. Use the controls in the dialog box that opens to save
your file. When you’re ready to apply saved customizations to Excel,
click the Import/Export button, click Import Customization File, select
the file in the File Open dialog box, and click Open.
