Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
To reposition a particular button on the toolbar, select it in the list box on
the right and then select either the Move Up button (the one with the black
triangle pointing upward) or the Move Down button (the one with the black
triangle pointing downward) until the button is promoted or demoted to the
desired position on the toolbar.
You can add a pair of vertical separators to the toolbar to group related
buttons. To do this, select the <Separator> option in the list box on the left
followed by the Add button twice. Then, select the Move Up or Move Down
button to position one of the two separators at the beginning of the group and
the other at the end.
To remove a button you’ve added, open the Quick Access toolbar’s
shortcut menu (right-click or tap and hold on a touchscreen) and then select the
Remove from Quick Access Toolbar option.
Adding non-Ribbon commands to the Quick Access toolbar
You can also use the options on the Quick Access Toolbar tab of the Excel
Options dialog box (refer to Figure 1-6) to add a button for any Excel
command even if it isn’t one of those displayed on the tabs of the Ribbon:
1. Select 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 Popular Commands 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, select
Commands Not in the Ribbon near the top of the drop-down list. To
display a complete list of the Excel commands, select All Commands near
the top of the drop-down list.
2. Select the command button you want to add to the Quick Access
toolbar in the list box on the left.
3. Click the Add button to add the command button to the bottom of the
list box on the right.
4. (Optional) To reposition the newly added command button so that it
isn’t the last one on the toolbar, click the Move Up button until it’s in
the desired position.
5. Click OK to close the Excel Options dialog box.
If you’ve created favorite macros (see Chapter 12) that you routinely use and
want to be able to run directly from the Quick Access toolbar, select Macros
in the Choose Commands From drop-down list box in the Excel Options dialog
box and then click the name of the macro to add followed by the Add button.