Excel 2010 Bible

Part IV: Using Advanced Excel Features

548

FIGURE 23.4

The Customize Ribbon tab of the Excel Options dialog box.

Customizing the Ribbon is very similar to customizing the Quick Access toolbar, which I describe

earlier in this chapter. The only difference is that you need to decide where to put the command

within the Ribbon. The general procedure is

1. Use the Choose Command From drop-down list on the left to display various
   groups of commands.


2. Locate the command in the list box on the left, and select it.


3. Use the Customize the Ribbon drop-down list on the right to choose a group of
   tabs. Main Tabs refer to the tabs that are always visible; Tool Tabs refer to the contextual
   tabs that appear when a particular object is selected.


4. In the list box on the right, select the tab and the group where you would like to
   put the command. You’ll need to click the plus-sign control to expand the tab name so
   that it displays its group names.


5. Click the Add button to add the selected command from the left to the selected
   group on the right.