How to Customize the Ribbon in Excel

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on May 24, 2023

This tutorial demonstrates how to customize the Excel Ribbon.

CustomRibbon CustomTab

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 you use daily, 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 click Customize the Ribbon…

CustomRibbon RightClick
In the Ribbon, go to 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).

  1. To show these tabs in the Ribbon, make sure the box next to those two options is checked.

CustomRibbon ShowTabs

  1. Click OK to show those new tabs in the Ribbon.

CustomRibbon AllTabs

Reorder Tabs

In Customize Ribbon Options, you can also move tabs.

  1. Select the tab you wish to move, and then click 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.

custom ribbon move tabs

  1. 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 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 clicking 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 clicking 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 the Add >> button to add them to the group.

CustomRibbon AddToGroup

  1. Repeat as often as needed, 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.

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

  1. 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, choose 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 made) by clicking 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!

Customize the Quick Access Toolbar

The Quick Access Toolbar can be found above the Ribbon in Excel. By default it contains AutoSave, Save, Undo, and Redo. The purpose of this toolbar is to show commands you use on a daily basis, thus making them “quick access.”
custom-ribbon quickaccess default

  1. You can customize the quick access toolbar by clicking on the small arrow on the right side of the toolbar.

customribbon menu customize

  1. Select the commands that you might use very often – such as New, Open, and Quick Print. Each time you tick a command, you need to click again on the small arrow to get back to the Customize Quick Access Toolbar menu.

customribbon menu customized

  1. To add any other commands to the toolbar, or to rearrange the order of the current commands, click More Commands.

customribbon toolbar more commands

  1. As with the Ribbon, you are able to add any command to the quick access toolbar. You can also use the up and down arrows to rearrange the order of commands on the toolbar.

CustomRibbon quickaccess customize

Reset Quick Access Toolbar

Should you wish to reset the toolbar back to the default settings, click the Reset drop down and click Reset only Quick Access Toolbar. Click OK to apply your changes.

customribbon quickaccess reset

Move the Toolbar

You can also choose to show the quick access toolbar below the Ribbon by clicking Show Below Ribbon.

customribbon quickaccess show below ribbon

The toolbar is now shown below the Ribbon.

customribbon quickaccess below ribbon

AI Formula Generator

Try for Free

See all How-To Articles