Microsoft Office Tutorials and References
In Depth Information
Just as you can change the order of the tabs on the ribbon, with Excel 2010, you can change
the order in which groups of commands appear on a tab. For example, the Page Layout tab
contains five groups: Themes, Page Setup, Scale To Fit, Sheet Options, and Arrange. If you
use the Themes group less frequently than the other groups, you could move the group to
the right end of the tab by clicking the group’s name and then clicking the Move Down
arrow button until the group appears in the desired position.
To remove a group from a built-in ribbon 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 ribbon tab.
The built-in ribbon 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 ribbon tab, you can create a custom tab and then add
groups and commands to it. To create a custom ribbon 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.