Microsoft Office Tutorials and References
In Depth Information
want to add. Excel 2010 displays the available commands in the box 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 prefer not to save your changes,
click the Cancel 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.
You can also choose whether your Quick Access Toolbar changes affect all your
workbooks or just the active workbook. To control how Excel applies your change, in the
Customize Quick Access Toolbar list, click either For All Documents to apply the change to
all of your workbooks or For Workbook to apply the change to the active workbook only.
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 2010 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.