Excel Ribbon


Ribbon Tabs  | show or hide the ribbon  | customize the ribbon | add ribbon tab and groupsrename ribbon tabadd ribbon command to custom group | reset ribbon tabs to defaultCustomize quick access toolbar on ribbonAdd developer tab to ribbon

The Ribbon is the strip of buttons and icons located above the work area. and it is organized into various tabs, such as: File, Home,Insert, Page Layout, Formulas, Data, Review, and View. while clicking on a tab, you will saw all of program’s features and commands.

This section will guide you how to customize/collapse/show/hide/reset/the Ribbon. you will also learn that how to add developer tab to ribbon and how to set quick access toolbar on ribbon.

Ribbon Tabs

The following tabs are shown on the ribbon by default: File, Home, Insert, Page, Layout, Formulas, Data, Review and view. you will find the most basic and frequent features on Home tab.

The Home tab is the default tab in Microsoft excel.  The below screenshot shows an example of the Ribbon Tabs and Home tab in excel 2013.

excel ribbon

Show or Hide the Ribbon(Maximize or Minimize the Ribbon)

If you want to get more space on the screen, you can easily minimize or hide the ribbon by the following 4 ways:

#1 -To minimize the ribbon, just double-click on any of the tab names

#2 – Just press “Ctrl +F1” to hide or show the ribbon

maximize excel ribbon

#3 – Right-click on any ribbon tab name, check “Collapse the Ribbon

excel collapse ribbon

#4 – Click “Ribbon Display Options” icon on the top-right corner, then click “show Tabs

maximize excel ribbon

Let’s see the below minimized ribbon:

minimized excel ribbon

Conversely, To maximize the ribbon, also following the below 4 ways:

#1 – Double-click on any of the tab names(now the ribbon is minimized)

#2 – Press “Ctrl +F1” to show the ribbon again

maximize excel ribbon

#3 – Right-click on any ribbon tab name or anywere on the ribbon , un-check “Collapse the Ribbon

 ribbon maximize the ribbon 2

#4 – Click “Ribbon Display Options” icon on the top-right corner, then click “show Tabs and Commands

ribbon maximize the ribbon

Customize The Ribbon

You can easily customize the ribbon in excel , such as : add, remove, rename, reorder, reset ribbon tabs, groups, commands.

1. Add Ribbon tab and groups

Step1# Right-click on any ribbon tab name or anywhere on the Ribbon , then click “Customize the Ribbon”.

customize the ribbon

Step2#  Click “New Tab” to Add a newly ribbon tab and custom ribbon group.

customize the ribbon

2. Rename ribbon tab

Step 1#  click the tab you want to rename ribbon tab(default or custom tab or groups)

Step 2#  then click “Rename

Step 3#  type the name you want to set.

customize the ribbon-rename tab

3. Add Ribbon command to custom group

Step 1# click the custom group that you want to add a command

Step 2# then choose one command from the left command list

Step 3# next to click “Add” command.

customize the ribbon-add commands

4. Reset ribbon tabs to default 

You can reset all Customizations or just reset only selected ribbon tab,  just click “Reset” button then click  “reset all customizations” or “reset only selected ribbon tab” .

customize the ribbon-reset tab

The below screenshot is the customized result for ribbon tab.

customize the ribbon_result

Customize quick access toolbar on ribbon

You can add the most frequently used command to Quick Access Toolbar.  by default, the Quick Access Toolbar just contains three button: SAVE, Undo Typing and Redo typing. Now we will talk how to add a command to the Quick Access Toolbar.

quick access toolbar

Step 1#  Right-click the appropriate tab or group or everywhere place on ribbon, then click “Add to Quick Access Toolbar

excel add command to quick access toolbar1

How to add a command to the Quick Access Toolbar that isn’t on the ribbon? See the below steps:

Step 1# click Customize the Quick Access Toolbar > More Commands.

excel add command to quick access toolbar2

Step2# Select commands Not in the Quick Access Toolbar, then click “Add” button, then click “OK”.

excel add command to quick access toolbar3

Last, see the result of add command to Quick Access Toolbar.

excel add command to quick access toolbar4

Add developer tab to ribbon

If you want to write macros, use XML commands/ActiveX controls… you need to add developer tab to ribbon, As the Developer tab is not displayed by default. To display developer Tab , just refer to the following steps:

Step 1#  Right-click any ribbon tabs or black space on the ribbon, then click “Customize the Ribbon…”

customize the ribbon

Step 2# check “Developer” tabs under “Customize the ribbon” list. Then click “ok” button.

add developer tab to ribbon 2

Now let’s see the result:

add developer tab to ribbon 3


Related Posts

How to Count Cells that Contain X or Y in Excel
count cell that contain x or y7

This post will guide you how to count the number of cells that contain X or Y in a given range cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text ...

How to Highlight Cell if Same Value Exists in Another Column in Excel
highlight cell if same value exists in another column8

This post will guide you how to highlight cell if same value exists in another column in Excel. How do I highlight cell if value is present in any cell in another column in Excel 2013/2016. Highlight Cell If Same ...

Split Excel workbook into separate Files
split workbook into separate file3

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

How to Convert Positive Numbers to Negative
change positive to negative 112

This tutorial will teach you how to change positive numbers to negative with Paste special multiply operation in excel. How to convert positive number to negative or how to reverse the number signs with VBA code in Excel. Convert Positive ...