Page 82 - Excel 2013 All-in-One For Dummies

64 Exercising Your Options
2. Select the tab under Main Tabs in this list box immediately after
which the new Ribbon is to be inserted.
By default, Excel inserts the new tab after the one that’s currently selected in the Customize the Ribbon list box. This means that if you want your new custom tab to precede the Home tab, you must put it ahead of the Home tab with the Move Up button after first creating the new tab behind it.
3. Click the New Tab command button below Main Tabs in the Customize the Ribbon list box.
Excel inserts a tab called New Tab (custom) with the single group called New Group (Custom) displayed and selected. This New Tab (Custom) is placed immediately after the currently selected tab.
4. Add all the commands you want in this group on the custom tab by selecting them in the Choose Commands From list box and then click- ing the Add Command button.
When adding commands, you can select them from any of the catego- ries: Popular Commands, Commands Not in the Ribbon, All Commands, Macros, Office Menu, All Tabs, Main Tabs, Tool Tabs, and Custom Tabs and Groups (which lists all custom tabs and groups you’ve previously created).
As you add each command from these categories, Excel displays the button’s icon and name in the list beneath New Group (Custom) in the left-to-right order in which they’ll appear. (See Figure 2-10.) To change the order of these command buttons in the new group on the custom tab, click the Move Up and/or Move Down buttons.
5. Rename the new group by clicking the Rename button under the Customize the Ribbon list box and then typing the new name in the Display Name text box of the Rename dialog box before clicking OK.
6. (Optional) To add other groups to the same custom tab, click the New Group button under the Customize the Ribbon list box and then add all its command buttons before renaming it. (Refer to Steps 4 and 5.)
To add any additional groups of commands to be included on the new custom tab, simply repeat Step 6. Use the Move Up and Move Down but- tons if you need to reposition any groups on the custom tab.
7. Rename the custom tab by clicking the New Tab (Custom) in the Customize the Ribbon list box. Then, click Rename button and type the name for the tab in the Display Name text box of the Rename dialog box before you click OK.
To add additional custom tabs to the Ribbon, repeat Steps 2 through 7. After you finish all your custom tabs to the Ribbon, you’re ready to close the Excel Options dialog box and return to the worksheet.