Excel 2019 Bible

Chapter 8: Customizing the Excel User Interface

8

Creating a new group

To create a new group, select the tab that will hold the new group and click the New Group

button. Excel creates a new group named New Group (Custom). Use the Rename button to

provide a more descriptive name, and use the Move Up and Move Down arrow buttons on

the right to reposition the group within the tab.

Adding commands to a new group

Adding commands to the Ribbon is similar to adding commands to the Quick Access tool-

bar, which we described earlier in this chapter. Commands that you add must be placed in a

new group. Here’s the general procedure:

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


2. Select the command in the list box on the left.


3. Use the Customize the Ribbon drop-down list on the right to choose a group
   of tabs. Main Tabs refers to the tabs that are always visible; Tool Tabs refers 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 want 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.

You can add commands only to groups that you’ve created.

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

To rearrange the order of tabs, groups, or commands, select the item and use the Move Up

and Move Down buttons on the right. Note that you can move a group into a different tab.

Although you can’t remove a built-in tab, you can hide the tab by clearing the check box next to its name.

Figure 8.5 shows a part of a customized Ribbon. In this case, two groups were added to the

View tab (to the right of the Macros group): Extra Commands (with three new commands)

and Speech (with five new commands).

FIGURE 8.5

The View tab, with two new groups added