Microsoft Office Tutorials and References
In Depth Information
Customizing the Ribbon
Excel 2010 enhances your ability to customize the entire ribbon by enabling you to hide and
display ribbon tabs, reorder tabs displayed on the ribbon, customize existing tabs (including
tool tabs, which appear when specific items are selected), and to create custom tabs.
To begin customizing the ribbon, click the File tab 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.
Tip The procedures taught in this section apply to both the main tabs and the tool tabs.
Each ribbon tab’s name has a check box next to it. If a tab’s box is selected, then that tab
appears on the ribbon. You can hide a tab by clearing the check box and bring it back by
selecting the check box. You can also change the order in which the tabs are displayed
on the ribbon. To do so, click the name of the tab you want to move and then click the
Move Up or Move Down arrows to reposition the selected tab.