This tutorial demonstrates how to customize the Excel Ribbon.
How to Customize the Ribbon
The Ribbon in Excel allows you to access commands and features available. The most popular and used commands and features are by default on the Ribbon. You may wish to add commands that you use on a daily basis or add new features to the Ribbon that don’t currently exist. There are several ways to customize the Ribbon.
To start, right-click on the Ribbon, and then select Customize the Ribbon.
In the Ribbon, select File > Options and then select Customize Ribbon.
Show Hidden Tab
The right hand list will show a list of all the Main tabs that are visible on the Ribbon. By default, some of these tabs are hidden (namely the Draw and Developer tabs).
To show these tabs in the Ribbon, make sure the box next to those two Ribbon options is checked.
Click OK to show those new tabs in the Ribbon.
In Customize Ribbon Options, you can also move the location of tabs on the Ribbon.
Select the tab you wish to move, and then click on the Move Up (to move the tab to the left on the Ribbon), or the Move Down (to move the tab to the right on the Ribbon) button.
Click OK to update the Ribbon.
Rename Default Tabs and Groups
You can rename any of the tabs and groups within the tabs on the Ribbon.
- In the list of tabs on the Customize Ribbon Options window, select the tab you wish to rename and click Rename.
- Type in the new name and click OK.
You can also rename a group in the same way by selecting the group in the list and then clicking Rename.
Your custom names will then appear in the Ribbon instead of the default names.
Add New Tab to the Ribbon
- In Customize Ribbon Options, select in the Right hand list of tabs where you wish your new tab to go, and then click on New Tab.
This creates a new tab and a new group within that tab.
- Click on the new tab, and then click Rename.
- Type in the new name, and then click OK.
- You can also rename the group by selecting the New Group and clicking on Rename.
- Type the name for the group and click OK.
- You can add additional Groups to your new tab by selecting the New Group button. The groups will not be visible on the Ribbon until you add new commands to it.
Add New Custom Group
You can add new custom groups to existing or custom tabs in the Ribbon.
- In the Customize Ribbon Options dialog box, select the tab you want, then click New Group.
- Select the New Group and click Rename.
- Type in the name for your group and click OK.
The group will not be visible on the Ribbon until you add new commands to it.
Add Command Buttons to Group
Now, you can add commands to the new group.
- Select the command you wish to add to the group from the list of commands on the left, and then click on the Add button to add them to the group.
- Repeat as often as required, selecting the command from the left and clicking Add to add it to the group on the right.
- Click OK to make the new tab and group visible in the Ribbon.
Remove Command Buttons From Group
Use the Remove button to remove any unwanted commands from the selected group in the Ribbon.
Note that you can only remove commands from Custom Groups you have created; you cannot remove any commands from the default groups.
Remove Group From Tab
You can also use the Remove button to remove a group from either a default tab or a custom tab.
While still in Customize Ribbon Options, in the list of Main Tabs, select the group you wish to remove, and then click Remove.
If you wish to put a group you have deleted from a default group back into that group, select the relevant group, and then in the Reset drop down list, select Reset only selected Ribbon tab.
However, if you remove a custom group, you will need to recreate it.
Remove Custom Tab
In Customize Ribbon Options, select the tab you wish to remove, and then click the Remove button.
Reset the Ribbon
You can also remove custom tabs (and any other customizations you have made, including to the Quick Access Toolbar), but selecting Reset > Reset all customizations.