Instructions for setting up Ribbon in Microsoft Excel 2016

The Excel 2016 ribbon in the Office 2016 office suite is a powerful "factory" command that helps you dig deeper into your data. It is always ready for you to make the most of your work with daily functions to enhance data tools and view with one click.

Download Office 2016 for Windows

Download Office 2016 for Mac

You can personalize the Microsoft Excel 2016 Ribbon to suit your specific usage needs and the following is an article to guide you to do that.

The ribbon is a graphical user interface that contains a large number of commands as well as a set of commands called groups. Separate commands and groups are organized into tabs. Like the Quick Access Toolbar , the Ribbon provides easy location and use for most items that you use in Excel 2016.

1. The ribbon display options

Instructions for setting up Ribbon in Microsoft Excel 2016

In the upper right corner of the program window, you will see the icon of Ribbon display options. You can change its appearance with just one click and the following are the display options:

  • Auto-Hide Ribbon : This option removes most commands, including the Ribbon. What remains are basic worksheet options, like the formula bar and name box. To view the Ribbon , simply click the Options icon in the upper right corner to display it from the top of the screen.
  • Show Tabs : This option removes groups and commands from view, leaving only the Ribbon tab . Clicking on a single tab will display the command.
  • Show Tabs and Commands : This option works like returning to the default display option as you see when you first access Excel 2016.

Hide Ribbon

While the Ribbon exists there to serve whenever you need it, you don't always need it to be there. If you want those commands to disappear so you can see more boxes on the screen, you can hide the Ribbon and its tabs by clicking the ^ icon in the middle right corner of the ribbon.

Pin the tab contents

  • Click on a Tab name to display the groups.
  • Click the pin icon to pin groups to the default display mode.

2. Customize the Ribbon

To access the Customize Ribbon option , click File> Options> Customize Ribbon .

Instructions for setting up Ribbon in Microsoft Excel 2016

The Options screen is a bit confusing, but really easy to navigate. The left column Choose commands from contains 9 list of commands and tabs to browse while the right column Customize the Ribbon lists what is in the Ribbon. You can select commands and tabs from the left column and click on the> icon to move them to the right column to display the Ribbon, or select the displayed items on the right column and click on the <icon to remove them. You also need to keep in mind that incoming commands cannot be changed and removed.

Add a command

  • To add a command, click File> Options> Customize Ribbon . Select a command from the Choose commands from list and click on the command . Then, click on Add and Ok to save the operation.

Delete a command

  • To delete a command, go to File> Options> Customize Ribbon . Then, click on the command and select Remove .

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

Add a Custom Tab

  • To add a Custom Tab , go to File> Options> Customize Ribbon . Then select New Tab and click OK to save.

Add a group to a tab

  • To add a Group to a Tab , go to File> Options> Customize Ribbon .
  • In the Customize the Ribbon list on the right, select the Tab you want to add a group to.
  • Then click New Group at the bottom of the list. Finally click OK to save the changes.

Remove a Tab

  • To remove a Tab, go to File> Options> Customize Ribbon .
  • Click on the group you want to delete to remove it from the Customize the Ribbon column . Then click on Remove and Ok to finish.

Rename a tab in the Ribbon

  • You can rename a tab in the Ribbon by right-clicking on the Ribbon and selecting Customize the Ribbon .
  • Then select the Tab you want to rename and click on Rename . Enter a new name and select OK to save.

The renaming option can be applied to group names in a tab as well as to custom group commands.

Rearrange tabs on the Ribbon

Click on any tab on the Ribbon and select Customize the Ribbon . Select the tab to move in the Customize the Ribbon column . Then, use the up and down arrow keys to reposition the tab in the list. Finally, click on OK to finish.

The same steps can be applied to rearrange the commands in your custom group.

Hide and show a tab

Instructions for setting up Ribbon in Microsoft Excel 2016

  • Click File> Options> Customize Ribbon .
  • In the Customize the Ribbon column , uncheck / select the tabs you want to hide / show and click on OK to save changes. You cannot hide the File tab .

Reinstall the Ribbon

  • To reset the Ribbon back to its factory default settings, go to File> Options> Customize Ribbon and click on Reset in the Customizations section .
  • Then, select Reset all customizations to clear all options, or select Reset only selected Ribbon tab to return one tab to its default.

3. Import and export the Ribbon

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

Enter a Ribbon

  • To import a Ribbon, go to File> Options> Customize Ribbon and click on Import / Export .
  • Then choose Import customize files and Open . Finally, click Yes in the confirmation window to complete the process.

Export a Ribbon

You can export a Ribbon by going to File> Options> Customize Ribbon and selecting Import / Export . Then click on Export all Customizations . Choose a location and file name in the File Save window . Finally, click on Save to save.

You do not need to know all the commands to understand the Ribbon's function. You will gradually discover its functions during use.

Sign up and earn $1000 a day ⋙

Leave a Comment

Microsoft announces end of support date for Office 2016 and 2019 applications and servers

Microsoft announces end of support date for Office 2016 and 2019 applications and servers

Microsoft has finally officially announced the planned end of support (EOS) for the Office 2016 and Office 2019 application ecosystem.

Compare Microsoft Office 2016, Office 365 and Office Online

Compare Microsoft Office 2016, Office 365 and Office Online

What features do you get in the different versions of Office: Office 2016, Office 365, and Office Online?

Instructions for writing chemical formulas on Microsoft Word

Instructions for writing chemical formulas on Microsoft Word

Sometimes we don't know how to type chemical formulas in Microsoft Word. The following article will help you do this easily.

The simplest way to install Microsoft Office 2016 for Windows, Mac

The simplest way to install Microsoft Office 2016 for Windows, Mac

Along with the Windows 10 operating system, Office 2016 is the latest version of Microsoft Office with a beautiful graphical interface, giving users many new and attractive experiences. Today, WebTech360 will guide you through the easiest way to install and use Microsoft Office 2016 for Windows and Mac.

Instructions for creating columns and breaking columns in Microsoft Word 2016

Instructions for creating columns and breaking columns in Microsoft Word 2016

Many people still have difficulty creating columns and breaking columns in Microsoft Word 2016, so the following article will guide you to do that easily.

How to insert Math formulas in Word 2016

How to insert Math formulas in Word 2016

Perhaps a lot of people have trouble typing Math formulas, don't even know where to insert Math formulas in Word.

Tips to customize the interface of Microsoft Office 2016

Tips to customize the interface of Microsoft Office 2016

Office 2016 is Microsoft's latest office suite, offering a lot of useful features that make for an extremely enjoyable user experience.

Create charts that automatically update data in Excel 2016

Create charts that automatically update data in Excel 2016

You can create automatically updated charts according to newly added data in Excel with just three simple steps.

How to create a chart in Microsoft Word 2016

How to create a chart in Microsoft Word 2016

Drawing diagrams and charts is one of the quite useful features when editing text in Word. Help viewers easily visualize, compare and capture a lot more.

Microsofts foldable smartphone wont have a crease

Microsofts foldable smartphone wont have a crease

Microsoft is said to be getting closer to launching its first foldable smartphone when it was granted a patent for a foldable phone with the ability to fold 360 degrees but without creating wrinkles on the screen on October 1.

Google testing blue checkmark in search

Google testing blue checkmark in search

Google is testing a new verification feature through a blue checkmark in search that will help users avoid clicking on fake or fraudulent website links.

Distinguishing Microsoft 365 and Office 2024

Distinguishing Microsoft 365 and Office 2024

At first glance, Microsoft 365 and Office 2024 may seem very similar, as they both give you access to Microsoft's popular and widely used applications.

Latest Elemental Dungeons Codes and How to Enter Codes

Latest Elemental Dungeons Codes and How to Enter Codes

Elemental Dungeons codes are a necessary form of reward for gamers. Like any other online game on Roblox, players can receive these aids in exchange for money or other items.

How to repeat table title bar in Word

How to repeat table title bar in Word

When you print a Word document, create a table in Word, repeating the title in Word helps us track the title more conveniently, read the document title seamlessly across different pages, especially with long titles.

How to create animated messages on iMessage iOS 18

How to create animated messages on iMessage iOS 18

The new iOS 18 iMessage is updated with animated messages, text effects with many options to use for the messages you send.

Why are pigs the nemesis of snakes?

Why are pigs the nemesis of snakes?

There is an interesting fact about pigs that not everyone knows: pigs are considered the enemy of snakes, because when these two animals meet, most snakes will become food for pigs.

What is the distance from Earth to Jupiter - the largest planet in the Solar System?

What is the distance from Earth to Jupiter - the largest planet in the Solar System?

How far is Jupiter from Earth? If you don't know, this article will tell you how far Jupiter is from Earth.

Discover the out meta generals of season S1 2023 Lien Quan Mobile

Discover the out meta generals of season S1 2023 Lien Quan Mobile

Which champions are out of the Lien Quan Mobile meta? Let's find out now!

Graves DTCL season 7.5: Standard items, Graves Loi Long squad

Graves DTCL season 7.5: Standard items, Graves Loi Long squad

Graves DTCL from season 1, season 3 and season 6 all cost only 1 gold and seem to be just an additional champion to stimulate the clan system, the main role in the early game is still used but not much. Until this DTCL season 7.5, Graves has increased his price to 4 gold and is definitely an indispensable main force if you decide to play Thunder Dragon or Gunner.

How to use separate app sounds on Samsung

How to use separate app sounds on Samsung

With Samsung phones, you should use the separate app audio feature. For example, you can play Apple Music and your phone will route the audio through your car's speakers.

Good quotes about work, good statuses about work inspire you to achieve success

Good quotes about work, good statuses about work inspire you to achieve success

There are many good statuses about work on the Internet. This article will summarize for you good and meaningful statuses about work.

Wedding anniversary captions, meaningful and sweet wedding anniversary statuses

Wedding anniversary captions, meaningful and sweet wedding anniversary statuses

What is a good and meaningful wedding anniversary caption? This article will summarize for you short, concise wedding anniversary captions that can make your spouse remember forever.

List of latest Dai Hiep Phong Van codes and how to redeem codes

List of latest Dai Hiep Phong Van codes and how to redeem codes

Code Dai Hiep Phong Van helps players use attractive rewards even if they have just started wandering the world in the game.

List of latest Sword of Convallaria codes and how to redeem codes

List of latest Sword of Convallaria codes and how to redeem codes

Code Sword of Convallaria gives players a series of rewards such as currency, experience points, character summons...