Microsoft Office Tutorials and References
In Depth Information
Customizing the ribbon
To remove a group from a built-in tab, click the name of the group in the right pane and
click the Remove button. If you remove a group from a built-in tab and later decide you
want to put it back on the tab, display the tab in the right pane. Then, click the Choose
Commands From field’s arrow and click Main Tabs. With the tab displayed, in the left pane,
click the expand control (which looks like a plus sign) next to the name of the tab that
contains the group you want to add back. You can now click the name of the group in the left
pane and click the Add button to put the group back on the selected tab.
The built-in tabs are designed efficiently, so adding new command groups might crowd the
other items on the tab and make those controls harder to find. Rather than adding controls
to an existing tab, you can create a custom tab and then add groups and commands to it.
To create a custom tab, click the New Tab button on the Customize The Ribbon page of the
Excel Options dialog box. When you do, a new tab named New Tab (Custom), which
contains a group named New Group (Custom), appears in the tab list.
You can add an existing group to your new tab by clicking the Choose Commands From
field’s arrow, selecting a collection of commands, clicking the group you want to add, and
then clicking the Add button. You can also add individual commands to your tab by clicking
a command in the command list and clicking the Add button. To add a command to your
tab’s custom group, click the new group in the right tab list, click the command in the left
list, and then click the Add button. If you want to add another custom group to your new
tab, click the new tab, or any of the groups within that tab, and then click New Group.
TIP You can change the order of the groups and commands on your custom ribbon tabs by
using the techniques described earlier in this section.
The New Tab (Custom) name doesn’t tell you anything about the commands on your new
tab, so you can rename it to reflect its contents. To rename any tab on the ribbon, display
the Customize The Ribbon page of the Excel Options dialog box, click the tab you want to
modify, and then click the Rename button. Enter the tab’s new name in the Rename dialog
box, and click OK. To rename any group on the ribbon, click the name of the group, and
then click Rename. When you do, the Rename dialog box appears. Enter a new name for
the group in the Display Name box and click OK.