Adding non-Ribbon commands to the Quick Access toolbar

You can also use the options on the Customize tab of the Excel Options dialog box to add a button for any Excel command even if it’s is not one of those displayed on the tabs of the Ribbon:

• Click the type of command you want to add to the Quick Access toolbar in the Choose Commands From drop-down list box.

The types of commands include the File pull-down menu (the default) as well as each of the tabs that appear on the Ribbon. To display only the commands that are not displayed on the Ribbon, click Commands Not in the Ribbon near the bottom of the drop-down list. To display a complete list of all the Excel commands, click All Commands at the very bottom of the drop-down list.

• Click the command whose button you want to add to the Quick Access toolbar in the list box on the left.
• Click the Add button to add the command button to the bottom of the list box on the right
• (Optional) To reposition the newly added command button so that it’s not the last one on the toolbar, click the Move Up button until it’s in the desired position.
• Click the OK button to close Excel Options dialog box.

Related Post

• Adding command buttons on the ribbon
• Formatting and Editing from the Home tab
• The Ribbon