Understanding The Ribbon In Microsoft Excel

Table of Contents[Show]
Understanding The Ribbon In Microsoft Excel

The Excel Ribbon - One of the major changes to the display or user interface of Microsoft Excel that started in the Excel 2007 version is the Ribbon. The excel Ribbon menu is still being maintained in the excel version 2010, 2013 and I am currently using the excel 2016 version.

Understanding the Excel Ribbon

Understanding the Excel ribbon itself is a collection of command buttons on Microsoft Excel which are grouped into tabs based on similar categories of functions. Starting from the Home tab, Insert, Page Layout, Formula, Data, Review, View and other hidden tabs.

The main idea of ​​the emergence of this excel ribbon is to speed up and make it easier for Excel users to access and use menus or command buttons that are considered important.

Command buttons in the form of icons are placed at the top in several menu tabs according to their category. On each tab, the command menu buttons are grouped into certain groups that are related to each other functionally. In some groups there is a launcher button in the lower right corner which functions to display further functions of the group.

In this basic excel tutorial series, we will not discuss in detail the function of each command button on the excel ribbon. However, it will be explained in outline about what things we can do on this excel ribbon menu. Like how to hide or remove and show back the excel ribbon and about how to adjust the excel ribbon to suit our needs.

Parts of the Excel Ribbon

Parts of the Excel Ribbon

1) Tabs Menu: Contains a set of buttons that are grouped according to their function. By default there are Home Tabs, Insert, Page Layout, Formulas, Data, Review and View. Meanwhile, the Developer tab is hidden.

2) Group Menu: Within each tab the buttons are further grouped into groups. Each group is separated by a vertical line. On the Page Layout tab above, there are Group Themes, Pade setup, Scale to fit, Sheet Options and Arrange.

3) Command Buttons: Within the group there are several Command Buttons according to their respective functions.

4) Dialog Box Launcher: In some corners of the Group Menu there is a Dialog Box Launcher to display further settings for each group which by default these settings are not displayed.

TAB on the Excel Ribbon

The excel ribbon is divided into several TABs. In each of these TAB menu buttons are grouped into several groups according to their proximity or similarity in function. So that it will be easier for us to find the menu we need and find other related menus.

TAB on the Excel Ribbon

The tabs on the excel ribbon are divided into the following categories:


TAB file

These tabs are used to access the Backstage View. Unlike other tabs that contain a specific group of commands. The File tab contains information related to the Excel file that we are currently opening as well as a menu or option button for Excel settings.

You can read other information about Backstage View on the following page:

TAB Home

I think this tab is the tab we access the most when using excel. This tab not only contains command buttons that are related to each other but is also a tabs which contains the most popular Excel command menus, including those related to cell formatting, text alignment, cell operations, data search and shortening and filtering features.

TAB Insert

If we need to insert something into a worksheet or excel worksheet this is the place to look for the command menu. On this tab, we can find command buttons for inserting charts, tables, pictures and some others.

TAB Page Layout

In this section, there are command buttons for manipulating the excel worksheet display. The menus on this tab are mostly menus related to printing data (Print out).

TAB Formulas

All available excel functions can be found in this section. Where each excel function is grouped based on certain function categories.

TAB Data

In the Data tab, we can find a menu for connecting with data sources from curved (external data source) and related ones, as well as a menu of shortening and filtering data.

TAB Review

On the Review tab, we can find the check spelling menu, add comments and protect the worksheet.

TAB View

On the View tab, we can set the Excel application window display options.

TAB Developer

By default the developer tab is hidden by Excel. The menus in this section are basically intended for advanced users and not for basic users.

Contextual Tabs

Contextual Tabs or Tool Tabs contain command buttons that are specific to certain objects. Where each object will have different command button contents according to the object we are currently selecting.

The tool tabs menu will only appear when we activate certain objects. For example, Chart Tools, Table Tools, Drawing Tools, Pivot Table Tools, etc.

 

Contextual Tabs

How to Hide and Show Excel's Ribbon

To make the worksheet area feel wider, sometimes we need to hide this excel ribbon.

How to hide or more precisely folding the ribbon in Excel is by selecting (clicking) the small triangle icon on the lower left of the ribbon as shown in the image below.

How to Hide and Show Excel's Ribbon


As for the way to display the ribbon that was lost or folded earlier, the method is the same. Namely by selecting (clicking) the pin icon in place of the previous small triangle.

The second way is to use a shortcut. If the ribbon is in a folded condition, when pressing this shortcut, the ribbon will appear again and vice versa if it is visible, the ribbon will be folded or hidden. Ctrl + F1

Another way to show or hide menus on the Excel ribbon is to double click (click 2x) on one of the Excel tabs. This method I often use when using a mouse.

Apart from the three methods above, there is still a way to hide or display the excel ribbon, namely by using the Ribbon Display Options which we can activate by selecting the button in the upper right corner next to the minimize button as shown below.

How to Hide and Show Excel's Ribbon

Arrange the Excel Ribbon

By default Excel's ribbon is set so that we can access Excel features more easily and quickly. However, we can also arrange or adjust the menu display on the ribbon according to our needs. The trick is to open the Customize Ribbon option.

Arrange the Excel Ribbon

There are 2 ways you can open the window as shown above:

  1. Open the FILE Tab - Options - Customize Ribbon
  2. Right click on any part of the ribbon then select the Customize Ribbon menu

The items that are checked on the right side of the window above are the menus displayed on the Excel ribbon. Uncheck if you want to remove that section on the ribbon and turn on the check instead to display these menus on the excel ribbon.

Customize Ribbon menu

In this window you can also create a (New Tab) and arrange menu groups (new Group) on that tab as needed and add other available menus on the left to the ribbon tab or group.

If the ribbon setting that you created is messy and you want to return the display back to normal, use the reset menu in the window.

Using the Ribbon with the Keyboard

If your mouse is damaged or unusable, you can use the buttons on the keyboard to select or activate the menus on the ribbon. The trick is to press the button Alt followed by the letter characters that appear on the Excel ribbon as shown below.

Using the Ribbon with the Keyboard

For example, if you want to activate the menu or the wrap text button, you just need to press the button Alt followed by the letter character H to activate the home tab, then followed by pressing the letter W on the keyboard. Or briefly by using a shortcut. Alt + H + W

Before leaving, don't forget to bookmark and share this excel tutorial article with the buttons provided below. Greetings Excel Class.

Leave a Comment