Chapter 23: Customizing the Excel User Interface
547
l (^) Add a new group to tab.
l Change the order of the tabs.
l (^) Change the name of a tab.
l Hide built-in tabs.
l (^) Groups
l Add new custom groups.
l (^) Add commands to a custom group.
l Remove commands from custom groups.
l (^) Remove groups from a tab.
l Move a group to a different tab.
l (^) Change the order of the groups within a tab.
l Change the name of a group.
Note
To restore all or part of the Ribbon to its default state, use the Reset button on the Customize Ribbon tab of the
Excel Options dialog box. Click this button to display two options: Reset Only Selected Ribbon Tab, and Rest
All Customizations. If you choose the latter, you will also lose any Quick Access toolbar customizations that
you made. n
That’s a fairly comprehensive list of customization options, but there are some actions that you
cannot do:
l (^) Remove built-in tabs — but you can hide them.
l Remove commands from built-in groups.
l (^) Change the order of commands in a built-in group.
Note
Unfortunately, you cannot customize the Ribbon (or Quick Access toolbar) by using VBA macros.
However, developers can write RibbonX code and store it in workbook files. When the file is open, the
Ribbon is modified to display new commands. Writing RibbonX is relatively complicated, and beyond the
scope of this book. n
How to customize the Ribbon
Customizing the Ribbon is done via the Customize Ribbon panel of the Excel Options dialog box
(see Figure 23.4). The quickest way to display this dialog box is to right-click anywhere on the
Ribbon, and choose Customize The Ribbon.