How to Customize the Excel 2010 Ribbon

By Greg Harvey

In Microsoft Excel 2010, you can customize the Ribbon by adding brand new tabs and creating custom groups of command buttons within the displayed Ribbon tabs. Use the Customize Ribbon tab of the Excel Options dialog box to add new tabs to the Ribbon and customize the existing Ribbon tabs. You also can change the order in which the tabs appear in the Ribbon and which groups of command buttons appear on each of these displayed tabs.

To add a brand new tab to the Ribbon, follow these steps:

1Choose File→Options→Customize Ribbon.

Excel displays the Customize Ribbon tab of the Excel Options dialog box, with the Main Tabs selected in the Customize the Ribbon list box on the right.

2Under Main Tabs, select the tab that you want the new Ribbon tab to come before.

Excel inserts the new tab before the one that’s currently selected in the Customize the Ribbon list box. (If you want your new tab at the end, select the new tab and later use the Move Down button to move the new tab down one position in the list box.)

3Click the New Tab button below the Customize the Ribbon list box.

Excel inserts a tab called New Tab (Custom) with a single group called New Group (Custom) displayed and selected.

4Add commands to this custom group by selecting them in the Choose Commands From list box and then clicking the Add button.

When adding commands, you can select them from any of the categories: Popular Commands, Commands Not in the Ribbon, All Commands, Macros, File, All Tabs, Main Tabs, Tool Tabs, and Custom Tabs and Groups.

5To rename the custom tab or group, select it and click the Rename button, type the new group name in the Display Name text box, and click OK.

The new group name now displays in the Customize the Ribbon list box.

6(Optional) To add another group to the same custom tab, click the New Group button below the list box, and then add all its command buttons before renaming it (refer to Steps 4 and 5).

Use the Move Up and Move Down buttons (to the right of the Customize the Ribbon list box) if you need to reposition any groups on the custom tab.

7Click OK.

The new custom tab appears in the Ribbon. The following figure shows a new Ribbon tab named Quick Formulas that holds the Calculate Now button.