Customize the Ribbon in Excel

Excel 2013 has a tabbed ribbon concept instead of traditional menu system. The ribbon in excel 2013 is a container of plenty of tabs and each tab contain some commands group and each group contains lots of commands. Ribbon can be customized by the user by including or excluding any command into any main tabs or tool tabs or from main tabs or tool tabs, as well as new main tabs or group tabs can also be created.

Customize the Ribbon

Right-click the Ribbon and then select Customize the Ribbon... from the drop-down menu.

edit-ribbon

The Excel Options dialog box will appear. To create a new tab within the main tab click on New Tab show below.

edit-ribbon-new

A new tab will be created within the main tabs, by default. You can create the new tab in other tabs also by choosing from Customize the Ribbon drop down menu. You can change its name using Rename button and to type a suitable name for this tab. Here is the picture shown below.

By default the new group tab under the main tabs will be selected. You can change the name of the group tab by using Rename button and to type a suitable name for this group. You can choose any command item from the left side within the command lists and click Add button or drag it into the right side within the selected group. Similarly you can remove any command from any group by using Remove button.

new-ribbon

The picture below shows that a new command item have been added within the created new tab.

ribbon-aelect-all

How to Collapse the Ribbon ?

Right-click the here as shown below and select Collapse the Ribbon from the drop-down menu.

collapse-ribbon

After clicking the collapse the Ribbon, ribbon menu will be disappeared.

collapse-ribbon1

How to display the Ribbon again?

Click the Ribbon Display Option. And also click Show Tabs and Commands as shown in the picture below.

ribbon-display

After clicking Show Tabs and Commands the ribbon will appear again.

ribbon-home

Slide show of Ribbon

  • Excel: Home ribbon
 

Click the buttons in the interactive below to become familiar with the Excel 2013 interface.

excel-interface2 

 

 

Source:http://www.w3resource.com/excel/excel-customize-ribbon.php