How to set up Microsoft Excel's Ribbon

It sits ready to get the most out of your worksheet with both everyday functions to robust viewing and data tools available at a click of a mouse.

You could personalize the Microsoft Excel 2016 Ribbon to suit your specific needs — here's how!

The Ribbon is a graphical user interface that houses a large number of commands as well as a collection of commands called groups. These individual commands and groups are sorted into tabs. Much like the Quick Access Toolbar, the Ribbon provides easy location and use of your most commonly used items to within Excel 2016.

Ribbon display options

excel display options

At the top right corner of the program window, you will see the Ribbon Display Options icon. This gives you a one-click means of changing the appearance of the ribbon. You can perform the following:

  • Auto-Hide Ribbon — This option removes nearly all commands, including the Ribbon. What you are left with is the basic spreadsheet options, such as the formula bar and name box. To view the Ribbon, you need only to click on the options icon in the top right corner to slide it down from the top of the screen.
  • Show Tabs — This view removes groups and commands from sight, leaving only the Ribbon tabs. Clicking on a tab will cause the reappear below it.
  • Show Tabs and Commands — This acts as a return to default view option just as you would see when first accessing Excel 2016.

Hiding and Repinning the Ribbon

While the Ribbon stands to serve you when you need it, it does not always have to be visible. If you want those commands to go away so you can see more cells on your screen, you can hide the Ribbon and its tabs by clicking on the ⌃ icon at the bottom right corner of the ribbon.

How to repin the tab contents

  1. Click on a Tab name to drop down the groups.
  2. Click on the pin icon to pin the groups back on default view.

Customizing the Ribbon

How to access the Customize the Ribbon option

excel ribbon options

How to access ribbon customization options

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.

The Options screen, though intimidating, is actually quite simple to navigate. The left column (Choose commands from) contains nine lists of commands and tabs to browse through while the right column (Customize the Ribbon) lists what is in your ribbon. You can select commands and tabs from the left column and click the > button to move them into the right column to display in the Ribbon, or select displayed items in the right column and click the < button to remove them. You do have a few limitations to keep in mind as come commands must not be altered or removed. Let's see how you can customize the Ribbon.

How to add a command

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Select a command inside the Choose commands from list.
  5. Click on the command.
  6. Click on Add.
  7. Click OK for the addition to take effect.

How to remove a command

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Click on the command.
  5. Select Remove.

Individual commands cannot be added to existing tabs or groups. You can create a custom group in an existing tab or a subgroup of a group. This will then allow you to add commands.

How to add a Custom Tab

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Click New Tab.
  5. Click OK to save.

How to add a Group to a Tab

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Under the Customize the Ribbon list on the right, select the Tab you wish to add a group to.
  5. Click New Group from the bottom of the list.
  6. Click OK to keep your changes.

How to remove a Tab

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Click on the Group to remove from the Customize the Ribbon column.
  5. Click Remove.
  6. Select OK to finish.

How to change the name of the tab of the Ribbon

  1. Right-click on the Ribbon.
  2. Select Customize the Ribbon.
  3. Select the Tab you wish to rename.
  4. Click on Rename.
  5. Enter the new title of the tab.
  6. Click OK to save.

The renaming option can also apply to the names of groups within a tab as well as actual commands in a custom group.

How to use a custom group in place of a default group

  1. Click on the default tab to add a custom group to.
  2. Select New Group.
  3. Right-click on the group and click Rename.
  4. Click Main Tabs from the Choose Commands from column.
  5. Click the plus sign for the default tab that houses the group to be customized.
  6. Click the plus sign for that default group to customize it.
  7. Select the command to add to the custom group.
  8. Click Add.
  9. Right-click the default group.
  10. Select Remove.
  11. Click OK to view the changes.

How to reorder tabs in the ribbon

  1. Right-click on any tab in the ribbon and select Customize the Ribbon.
  2. Select the tab to move under the Customize the Ribbon column.
  3. Use the Up and Down arrows to reposition the tab in the list.
  4. Click OK to finish.

The same steps can apply to reordering commands within your custom groups.

How to hide a tab

excel hide tab

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. In the Customize the Ribbon list, uncheck the tabs you want to hide.
  5. Select OK.

Keep in mind that you cannot hide the File tab.

How to display a hidden tab

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. In the Customize the Ribbon list, check the tabs you want to display.
  5. Click OK to save.

Microsoft's Tell me help feature

Tell me

Within the Ribbon of Excel 2016 is a text box that reads, "Tell me what you want to.." (or Tell me.. if you're working in a smaller window). Tell me is where you can type what you are trying to accomplish in an Office 2016 program. It could be as simple as "share my workbook" something a little more complex such as translating or inserting an online image.

How to use Tell me

  1. Click on the Tell me box.
  2. Type what you are trying to do in basic terms. A list of possible commands will begin to appear.
  3. Select a menu command to take action.Alternatively, you can select a Smart Lookup menu command to use Bing to refine the information.

Using Tell me could help you discover frequently accessed commands, thus allowing you to build custom tabs and groups much more quickly. Once you know the term used, it is much easier to search for them. Tell me cannot be removed from the Ribbon

How to Reset the Ribbon

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Click Reset under Customizations.
  5. Select Reset all customizations to clear all options.
  6. Select Reset only selected Ribbon tab to revert a tab to its default.

Import and Export Ribbons

If your team seems to use the same commands in Excel 2016, you may choose to import their Ribbons or export your own to them.

How to Import a Ribbon

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Click Import/Export.
  5. Select Import customization files
  6. Choose Open
  7. Click Yes in the verification window to complete the process.

How to Export a Ribbon

  1. Click File.
  2. Select Options.
  3. Select Customize Ribbon.
  4. Select Import/Export.
  5. Select Export all Customizations.
  6. Choose a destination and file name in the File Save window.
  7. Click Save to finish.

Wrapping Up

You do not have to understand all of the commands to understand the functionality of the Ribbon. It is meant to help you understand the relationships between the commands as well as help you create new relationships. You know how you truly work to let the Excel 2016 Ribbon become your own. Do you use the Ribbon in Excel? How you left it at its default view or have you added your own customization? Let us know!

And be sure to visit our Office 101 help hub for more related articles!

  • Microsoft Office 101: Help, how-tos and tutorials
Ryan Blundell