Use and Customize Ribbon Commands in Excel Office 365 ~ Quick Ways!!
Tags: excelpreface, useandcustomizetheri, exceltutorials
Published: 2020-11-27 09:11:31

---
title: Use and Customize Ribbon Commands in Excel Office 365 ~ Quick Ways!!
published: true
date: 2020-11-26 12:01:47 UTC
tags: ExcelPreface,useandcustomizetheRi,ExcelTutorials
canonical_url: https://geekexcel.com/use-and-customize-ribbon-commands-in-excel-office-365-quick-ways/
---

[**Ribbon Command**](https://geekexcel.com/use-command-ribbon-options-in-microsoft-excel-365/) has buttons and icons for every operation performed in Excel. It is located above the work area of the spreadsheet. Typically, it contains only eight commands on the Excel ribbon. They are **File,**  **Home, Insert, Page Layout, Formulas, Data, Review,** and **View.** This article will help you to understand how to use Ribbon Command in Excel 365. Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**
## Ribbon Tabs:

- Excel has a total of eight default ribbon tabs such as **File, Home, Insert, Page Layout, Formulas, Data, Review,**  **view, and Help.**
- You can see the Ribbon tabs in the following image.

![Command Ribbon](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/s11.png)<figcaption id="caption-attachment-9850">Command Ribbon</figcaption>

## Show or Hide Ribbon:

### Hide/Minimize Ribbon:

If you want to [**hide the ribbon tab**](https://geekexcel.com/show-or-hide-ribbon-formula-bar-and-status-bar-in-excel-365/) from your worksheet to get more workspace on the [sheet](https://geekexcel.com/how-to-use-excel-sheet-function-in-office-365-with-examples/), then the following ways might help you to do that.

- **Way 1 –** To minimize the ribbon, you need to **double-click** on any **tab name.**
- **Way 2 –** Use the **CTRL + F1**   [shortcut key](https://geekexcel.com/shortcut-keys-to-expand-or-collapse-ribbon-in-excel-365/) to hide the ribbon tab.
- **Way 3 –** You need to **right-click** on any **ribbon tab name** , and then **select** the **Collapse the Ribbon** option from the menu.

![Select the Collapse the Ribbon option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Collapse-the-Ribbon-option.png)<figcaption id="caption-attachment-18214">Select the Collapse the Ribbon option</figcaption>

- **Way 4 – ** You can also **click** the **Ribbon Display Options icon** in the top-right corner, then **select** the **Show Tabs** option from the menu.

![Select the Show Tabs option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Show-Tabs-option.png)<figcaption id="caption-attachment-18215">Select the Show Tabs option</figcaption>

This is how you can **hide/minimize** the ribbon tab from Excel. The below screenshot shows you the minimized ribbon.

![Hidden tabs](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Hidden-tabs.png)<figcaption id="caption-attachment-18216">Hidden tabs</figcaption>

### Show/Maximize Ribbon:

It also has four ways to [maximize the hidden ribbon](https://geekexcel.com/show-or-hide-ribbon-formula-bar-and-status-bar-in-excel-365/) tab in Excel. Do as follows.

- **Way 1 – ** Double-click on any of the tab names.
- **Way 2 – ** You can click **CTRL** + **F1** to show the ribbon tab.
- **Way 3 – ** You need to **right-click** on anywhere on the **ribbon,** and then **uncheck** the **Collapse the Ribbon** option.

![Select the Collapse the Ribbon option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Collapse-the-Ribbon-option.png)<figcaption id="caption-attachment-18214">Select the Collapse the Ribbon option</figcaption>

- **Way 4 – ** You can **click** the **Ribbon Display Options icon** in the top-right corner, then **select** the **Show Tabs** option from the menu.

![Select the Show Tabs and Commands option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Show-Tabs-and-Commands-option.png)<figcaption id="caption-attachment-18217">Select the Show Tabs and Commands option</figcaption>

In this way, you can easily **show or maximize** the ribbon tab in Excel.

## Customize the Ribbon:

You can quickly customize the ribbon in Excel. You can **add, remove, rename, reorder, reset ribbon tabs, groups,** and **commands.**

## Add Ribbon Tabs and Groups:

- You need to **right-click** on any **ribbon tab name** and then **click** the **Customize the Ribbon** option.

![Select the Customize the Ribbon option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Customize-the-Ribbon-option.png)<figcaption id="caption-attachment-18218">Select the Customize the Ribbon option</figcaption>

- Then, it will display the **Excel Options window** , you need to **click** the **New Tab** option to add a new ribbon tab and custom ribbon group.

![New Tab option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/New-Tab-option.png)<figcaption id="caption-attachment-18219">New Tab option</figcaption>

## Rename Ribbon Tab:

- In the **Excel Options window** , you need to **click** the **tab** that you want to rename.
- Then, **select** the **Rename** option.
- Next, it will display the **Rename Dialog Box** , you need to **enter the name** that you want to set.

![Rename option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Rename-option.png)<figcaption id="caption-attachment-18220">Rename option</figcaption>

## Add Ribbon Command to Custom Group:

- **Open** the **Excel Options** window.
- You need to **click** the **custom group** that you want to add a command.
- Then, **select one command** from the left command list.
- Now, **click** the **Add** button.

![Add Command](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Add-Command.png)<figcaption id="caption-attachment-18221">Add Command</figcaption>

## Reset Ribbon Tabs to Default:

- You can reset all customizations or reset only the selected tabs.
- To do that, you need to **click** the **Reset button**.
- Then, **click** the **reset all customizations** or **reset only selected ribbon tab** option.
- The below image has shown the customized ribbon tab for your reference.

![Reset option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Reset-option.png)<figcaption id="caption-attachment-18222">Reset option</figcaption>

## Customize the Quick Access Toolbar on Ribbon:

If you use any command most frequently, you can add it to the quick access toolbar. So that you can access it instantly.

- Quick Access Toolbar has some **default commands** such as **Save, Undo, Redo.**

![Default options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Default-options.png)<figcaption id="caption-attachment-18223">Default options</figcaption>

- Let’s see how to add a new command to the quick access toolbar.
- Click the **down arrow** in the quick access toolbar and **select** the **More Commands** option from the menu.

![Click More Commands option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-More-options.png)<figcaption id="caption-attachment-18224">Click the More Commands option</figcaption>

- It will open the **Excel Options window.**
- You need to **select** the **commands** that are not available in the quick access toolbar.
- Then, **click** the **Add** button and **click** the **OK** button.

![Click Add button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-Add-button-1.png)<figcaption id="caption-attachment-18225">Click Add button</figcaption>

- Now, you can see the newly added command in the quick access toolbar as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-24.png)<figcaption id="caption-attachment-18226">Result</figcaption>

## Add Developer Tab to Ribbon:

To add the developer tab to the ribbon, follow the below steps.

- You need to **right-click** on any **ribbon tab name** and then **click** the **Customize the Ribbon** option.

![Select the Customize the Ribbon option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Customize-the-Ribbon-option.png)<figcaption id="caption-attachment-18218">Select the Customize the Ribbon option</figcaption>

- Then in the **Excel Options** window, you need to **check** the **Developer** option under the **Customize the ribbon** list.
- Then, **hit** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-OK-button-2.png)<figcaption id="caption-attachment-18227">Click OK button</figcaption>

- Now, you have successfully added the Developer tab to the Ribbon as shown in the below image.

![Developer Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Developer-Tab.png)<figcaption id="caption-attachment-18228">Developer Tab</figcaption>

**Check this too:** [**Ribbon Keyboard Shortcut Keys**](https://geekexcel.com/ribbon-keyboard-shortcut-keys-in-microsoft-excel-365/)

## End of the Article:

In this article, you can clearly understand how to **use and customize the Ribbon Commands** in **Excel Office 365.** Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!