To begin customizing the ribbon, display the Backstage view and then click Options. In the Excel Options dialog box, click Customize Ribbon to display the Customize The Ribbon page.
To
select which tabs appear in the tabs pane on the right side of the
screen, click the Customize The Ribbon field’s arrow and then click
either Main Tabs, which displays the tabs that can appear on the
standard ribbon; Tool Tabs, which displays the tabs that appear when you
click an item such as a drawing object or PivotTable; or All Tabs.
Each
tab’s name has a check box next to it. If a tab’s check box is
selected, then that tab appears on the ribbon. You can hide a tab by
clearing the check box and bring the tab back by selecting the check
box.
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.
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.
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.
You can also rename any tab. 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.
