w3resource

Customize the Ribbon in Excel 2013

Introduction

Excel 2013 has a tabbed ribbon concept instead of the 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. 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 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 has been added to 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
  • Excel: Insert ribbon
  • Excel: Page-layout ribbon
  • Excel: Formulas-ribbon
  • Excel: Data-ribbon
  • Excel: Review-ribbon
  • Excel: View-ribbon

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

excel-interface2

Quick Access Tool

quick-access-tool

Ribbon Display Option

ribbon-display

Font Setting

command-group

Name Box

namebox

Formula Bar

formulabar1

Column

column

Row

row

Cell

cell

New Sheet

worksheet

View Options

worksheet-view-option

Zoom Control

zoom-control

Horizontal and Vertical Scrollbar

horizontal-vertical-scrollbar

Previous: View Worksheet - Excel 2013
Next: Quick Access Toolbar - Excel 2013