Ribbon In Excel

Updated on April 19, 2024
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What Is Ribbon In Excel?

The ribbon is an element of the UI (User Interface) at the top of Excel. In simple words, the ribbon can be called a strip consisting of buttons or tabs seen at the top of the Excel sheet. The ribbon was first introduced in Microsoft Excel in 2007.

In an earlier version of Excel, a menu and toolbar were replaced by a ribbon 2007. The basic tabs under the ribbon are – “Home,” “Insert,” “Page Layout,” “Formulas,” “Data,” “Review,” and “View.” We can customize it according to the requirements. See the image below. The highlighted strip is called ribbon, consisting of tabs like “Home, “Insert,” etc.

Ribbon in Excel Example 1.23

Key Takeaways

  1. The ribbon in Excel is a user interface strip located at the top of the sheet. It consists of buttons and tabs and was introduced in 2007.
  2. Add only frequently used tabs to the ribbon to improve performance. Place logical commands in logical groups or tabs for easy access.
  3. When adding commands from the “Command” option, ensure that a “New Group (Custom)” has been created. Otherwise, an error will be displayed. When adding commands, ensure that a “New Group (Custom)” is created, or it will display an error.

Understanding Ribbon Tabs

Ribbons are similar to the catalogue of options and functions we can use in Excel. To understand effectively, we need to understand how to

  • Hide Ribbons
  • Show or unhide ribbons
  • Customize ribbons

In this article, we will learn all 3 with detailed examples.

Hide Ribbon In Excel

We can easily hide ribbons in Excel with the following ways;

  • Use the shortcut key, Ctrl + F1.
  • We can also double click on the tab we are currently in to hide the entire ribbon.
  • Similarly, we can also click on the pin seen on the lower-right corner and select the option, Show Tabs Only to hide the ribbon.
Hide Ribbon in Excel

Unhide Ribbon In Excel

We can easily unhide or show ribbons in Excel with the following ways;

  • Use the shortcut key, Ctrl + F1.
  • We can also double click on the tab we are currently in to hide the entire ribbon.

How To Customize Excel Ribbon?

Below are the steps to customize the ribbon.

Step 1 – Right-click anywhere on the ribbon. It will open a pop-up with options, including “Customize the Ribbon.”

 Example 1

Step 2 – This will open the Excel Options box for you.

Ribbon in Excel Example 1.1

Step 3 You can see two options on the screen: “Customize the Ribbon” on the right and the “Choose commands from” option on the left.

Example 1.2

In the dropdown below, there are three options to customize the ribbon. By default, the “Main Tabs” is selected. The other two are “Tool Tabs” and “All Tabs.”

Ribbon in Excel Example 1.3

Step 4 You can click on the (+) sign to expand the list.

 Example 1.4

You will see some more tabs under the “Main Tabs.”

Ribbon in Excel Example 1.5

You can shrink the list by clicking on the (-) sign.

Example 1.6
Ribbon in Excel Example 1.7

Step 5 – You can select or deselect the required tab to customize the ribbon. It will appear on the sheet accordingly.

You can also add additional tabs to your sheet by following the below steps.

  • Click “New Tab (Custom)” or “New Group (Custom) ” and rename it with some name (not necessary) by clicking on the “Rename” option.

Example 1.24

  • Choose a command from the option and select the desired option from the dropdown.
  • Add command to the tab or group you have created.
Ribbon in Excel Example 1.25

Note: You can also open the Excel option pop-up by following the steps.

Click on File Menu —> Options

It will open Excel options for you, where you will see the option to customize the ribbon.

Example 1.8

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

How To Collapse (Minimize) Ribbon In Excel?

You can collapse the ribbon by right-clicking anywhere on the ribbon and then selecting the “Collapse the Ribbon” option.

Ribbon in Excel Example 1.22

How to Use a Ribbon in Excel with Examples

Below are some examples where you required customization of the ribbon.

Example #1

Someone asks you to record a macro or write a code in VBAWrite A Code In VBAVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more. How will you do that?

Solution:

We can use excel shortcutsExcel ShortcutsAn Excel shortcut is a technique of performing a manual task in a quicker way.read more “Alt + F8” to record macro and “Alt + F11” to open the VBA screen. But remembering shortcuts is not always easy, so here is another option.

Shortcut key to Record Macro:

Example 1.9

Shortcut key to Open VBA Screen:

Ribbon in Excel Example 1.10

Add the “Developer” ribbon in Excel by using the following steps. 

First, “Customize the Ribbon” will open the Excel options box.

Ribbon in Excel Example 1

Check the “Developer” option shown in the list under the “Main Tabs.” See the image below. Click “OK.”

 Example 1.11

You will see the developer tabDeveloper TabEnabling the developer tab in excel can help the user perform various functions for VBA, Macros and Add-ins like importing and exporting XML, designing forms, etc. This tab is disabled by default on excel; thus, the user needs to enable it first from the options menu.read more under the ribbon. See the image below.

Ribbon in Excel Example 1.12

You can see the macros or basic visual screens option.

Example #2

Someone asks you to create an interactive dashboard using Power View in ExcelPower View In ExcelExcel Power View is a data visualization technology that helps you create interactive visuals like graphs, charts. It allows you to analyze data by looking at the visuals you created. As a result, it makes your excel data more meaningful and insightful for better decision making.read more 2016.

Solution:

The “Power View” option is hidden in Excel 2016. So, we must follow the below steps to add the “Power View” command in our Excel. First, go to “Customize the Ribbon.”

 Example 1

Under “Customize the Ribbon,” extend the “Insert” option, then click on the “New Group (Custom).”

Ribbon in Excel Example 1.13

Now, choose the command shown on the left and select the command, not in the ribbon from the dropdown. Now, select “Insert a Power View Report.” Next, click on “Add.” It will add a “Power View” under the “Insert” tab. (When you click on “Add,” make sure a “New Group (Custom)” is selected. Else, an error will pop up). Select “OK.” See the below image:

 Example 1.14

Now, you can see the “Power View” option under the “Insert” tab in the “New Group” section:

Ribbon in Excel Example 1.15

Example #3

Let us take another scenario.

Suppose we are working on a report requiring the sum of the values in subsequent rows or columns very frequently.

To sum up the values, we need to write a SUM function whenever the total value is required. Here, we can simplify our work by adding the AutoSum command to our ribbon. Then, go to “Customize the Ribbon.”

 Example 1

Under “Customize the Ribbon,” extend the “Home” tab, then click on the “New Group (Custom).”

Example 1.16.0

Now, choose the command shown on the left and select “All commands” from the dropdown. Now, select the “∑” AutoSum option. Next, click on “Add.” It will add “∑” “AutoSum” under the “Home” tab. (when you click on “Add,” make sure a “New Group (Custom)” is selected. Else, an error will pop up). Select “OK.” See the below image:

Ribbon in Excel Example 1.17

Now, you can see the “AutoSum” option under the “Home” tab in the “New Group” section:

Ribbon in Excel Example 1.18

Now, let us see its use.

We have some numbers in cells A1 to A7. We need to get the sum in A8. Select cell A8 and click “AutoSum.” It will automatically apply the SUM formula for the active range and give you the SUM.

Example 1.20

We get the following result.

Ribbon in Excel Example 1.21

Important Things To Note

  • We must slow the performance by adding tabs to the ribbon. So, we must add and keep only those tabs, whichever is required frequently.
  • We must add a logical command to a logical group or tab so it can easily find that command.
  • When adding commands from the “Command” option, not the ribbon, we must ensure that we have created a “New Group (Custom).” Otherwise, it will display the error.

Frequently Asked Questions

1. How to get Power Query ribbon in Excel?

Power Query is a feature that comes pre-installed with Excel 2016 and later versions. However, sometimes users may need to activate it. To activate Power Query, one can go to the “File” menu, select “Options,” and then choose “Add-ins.” Next, they should click on “COM Add-ins” and enable “Microsoft Power Query for Excel.”

2. How to increase size of ribbon in Excel?

It is not possible to adjust the size of the ribbon, the text, or the default icons in Excel. However, you do have the option to hide the ribbon altogether or collapse it so that only the tab names are visible. While it’s not possible to change the color of the ribbon specifically in Excel, you can alter the color scheme of the entire Office suite.

3. What is the shortcut for the ribbon in Excel?

The ribbon can be accessed through the utilization of KeyTips, which are denoted over each command available within the current view. To display the KeyTips, one can execute either of the following methods: On Windows, press Alt+Period and Control+Period on Mac.

Recommended Articles

This article is a guide to Ribbon in Excel. Here, we discuss how to customize, collapse, and use ribbon in Excel, along with examples and explanations. You can learn more about Excel from the following articles: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *