Microsoft Office Tutorials and References
In Depth Information
Customize the Ribbon
Chapter 1: Making Excel More Efficient
Add a Command
1 Click the Choose
Commands From drop-
2 Click the command
category you want to use.
3 Click the command you
want to add.
4 Click the custom group
you want to use.
5 Click Add.
Excel adds the command.
To remove a custom
command, click it and
then click Remove.
6 Click OK.
Excel adds the new tab or
group, as well as the new
command, to the Ribbon.
You can also customize the tabs that appear
only when you select an Excel object. Excel calls
these tool tabs , and you can add custom groups
and commands to any tool tab. Right-click any
part of the Ribbon, and then click Customize
the Ribbon to display the Excel Options dialog
box with the Customize Ribbon tab displayed.
Click the Customize the Ribbon list and then
click Tool Tabs. Click the tab you want to add,
and then follow the steps in this section to
Right-click any part of the Ribbon,
and then click Customize the Ribbon;
the Excel Options dialog box appears
with the Customize Ribbon tab
displayed. To restore a tab, click the
tab, click Restore Defaults, and then
click Restore Only Selected Ribbon
Tab. To remove all customizations,
click Restore Defaults and then click
Restore All Ribbon Tabs and Quick
Access Toolbar Customizations.