Microsoft Office Tutorials and References
In Depth Information
You can add an existing group to your new ribbon tab by clicking the Choose Commands
From field’s arrow, selecting a collection of commands, clicking the group you want to
add, and then clicking the Add button. You can also add individual commands to your
ribbon tab by clicking a command in the command list and clicking the Add button. To
add a command to your tab’s custom group, click the new group in the right tab list,
click the command in the left list, and then click the Add button. If you want to add
another custom group to your new tab, click the new tab, or any of the groups within
that tab, and then click New Group.
Tip You can change the order of the groups and commands on your custom ribbon tabs by
using the techniques described earlier in this section.
The New Tab (Custom) name doesn’t tell you anything about the commands on your new
ribbon tab, so you can rename it to reflect its contents. To rename any tab on the ribbon,
display the Customize The Ribbon page of the Excel Options dialog box, click the tab
you want to modify, and then click the Rename button. Type the tab’s new name in the
Rename dialog box, and click OK. To rename any group on the ribbon, click the name of
the group, and then click Rename. When you do, a different version of the Rename dialog
box appears. Click the symbol that you want to use to represent the group on the ribbon,
type a new name for the group in the Display Name box, and click OK.
If you’d like to export your ribbon customizations to a file that can be used to apply those
changes to another Excel 2010 installation, click the Import/Export button and then click
Export All Customizations. Use the controls in the dialog box that opens to save your file.
When you’re ready to apply saved customizations to Excel, click the Import/Export button,
click Import Customization File, select the file in the File Open dialog box, and click Open.