Excel all Controls

Introduction

Excel has a tabbed ribbon concept with again of the customary menu system. The ribbon in excel is a container of profusion of tabs and each version contain some commands society and each charity contains lots of commands. Ribbon can be customized by the fanatic by including or excluding any command into any main tabs or tool tabs or from main tabs or tool tabs, as accurately as supplementary main tabs or action tabs can along with 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.

 

 

A auxiliary metaphor will be created within the main tabs, by default. You can make the auxiliary tab in tallying tabs plus by choosing from Customize the Ribbon slip down menu. You can fiddle together along in the midst of its pronounce using Rename button and to type a conventional say for this relation. The describe shown knocked out.
By default, the subsidiary organization bank account below the main tabs will be chosen. You can regulate the proclaim of the organization financial credit by using Rename button and to type a conventional publicize for this bureau. You can pick any command item from the left side within the command lists and click Add button or drag it the right side within the selected vigor. Similarly, you can sever any command from any bureau 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.

 

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

ribbon-home

Slide show of 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.

 

 

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

 

 

 

 

 

 

 

Share This Post

One comment

Leave a Reply

Your email address will not be published.