How to Customize the Ribbon in Excel

This tutorial demonstrates how to customize the Excel Ribbon.

 

CustomRibbon CustomTab

 

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 on the Ribbon by default. 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…

 

CustomRibbon RightClick

 

OR

In the Ribbon, select File > Options > Customize Ribbon.

 

CustomRibbon Options

 

Show Hidden Tab

The list on the right shows 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 options is checked.

 

CustomRibbon ShowTabs

 

Click OK to show those new tabs in the Ribbon.

 

CustomRibbon AllTabs

 

Reorder Tabs

In Customize Ribbon Options, you can also move tabs.

Select the tab you wish to move, and then click on the Move Up (to move the tab to the left on the Ribbon) button or the Move Down (to move the tab to the right) button.

 

CustomRibbon MoveTabs

 

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.

  1. In the list of tabs on the Customize Ribbon Options window, select the tab you wish to rename and click Rename…

 

CustomRibbon SelectHomeTab

 

  1. Type in the new name and click OK.

 

CustomRibbon RenameDefaultTab

 

You can also rename a group in the same way by selecting the group in the list and then clicking Rename.

 

CustomRibbon RenameDefaultGroup

 

Your custom names, instead of the default names, then appear in the Ribbon.

 

CustomRibbon RenameStuff

 

Add New Tab to the Ribbon

  1. In Customize Ribbon Options, select – in the list of tabs to the right – where you wish your new tab to go, and then click on New Tab.

 

CustomRibbon NewTab

 

This creates a new tab and a new group within that tab.

  1. Click on the new tab, and then click Rename…

 

CustomRibbon NewTabRename

 

  1. Type in the new name, and then click OK.

 

CustomRibbon RenameTab

 

  1. You can also rename the group by selecting the New Group and clicking on Rename…

 

CustomRibbon RenameGroup

 

  1. Type the name for the group and click OK.
  2. You can add additional Groups to your new tab by selecting the New Group button. A group is not 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.

  1. In the Customize Ribbon Options dialog box, select the tab you want, then click New Group.

 

CustomRibbon NewGroup Create

 

  1. Select the New Group and click Rename…

 

CustomRibbon NewGroup Rename

 

  1. Type in the name for your group and click OK.

 

CustomRibbon RenameCustomGroup

 

A group is not 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.

  1. 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.

 

CustomRibbon AddToGroup

 

  1. Repeat as often as required, selecting the command from the left and clicking Add>> to add it to the group on the right.

 

CustomRibbon AddMoreCommands

 

  1. Click OK to make the new tab and group visible in the Ribbon.

 

CustomRibbon CustomTab

 

Remove Command Buttons From Group

Use the <<Remove button to remove any unwanted commands from the selected group in the Ribbon.

 

CustomRibbon RemoveCommand

 

Note that you can only remove commands from the 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.

 

CustomRibbon RemoveGroup

 

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.

 

CustomRibbon Reset

 

However, if you remove a custom group, you would need to recreate it.

Remove Custom Tab

In Customize Ribbon Options, select the tab you wish to remove, and then click <<Remove.

 

CustomRibbon RemoveTab

 

Reset the Ribbon

You can also remove custom tabs (and any other customizations you have made, including changes to the quick access toolbar), but selecting Reset > Reset all customizations.

 

CustomRibbon ResetRibbon

 

One benefit of resetting the Ribbon to its default state is that it might be easier to follow tutorials like this one!