Ribbon in MS Excel

Ribbon in MS Excel

In Microsoft Office 2007, Microsoft introduced “Familiar User Interface” or “Familiar UI”, that replaced the traditional Menu bars and adjustable toolbars with a solitary “Office menu”, a smaller than usual toolbar known as “Quick Access Bar” and a Ribbon bar having multiple tabs. Every tab holds a toolbar bearing buttons for various operations. Toolbar controls have heterogeneous sizes and are grouped in a significant manner.

By default, the Ribbon contains 8 tabs in MS Excel 2013

File

file

Home

Home

Insert

insert

Page Layout

page layout

Formulas

formulas

Data

data

Review

review

View 

veiw

Minimizing and Maximizing the Ribbon

By default, Ribbon is set to be fixed, however, it can be minimized or maximized by using the following methods.

Minimizing the Ribbon

Method 1

You can click the “^” symbol on bottom-right corner of the ribbon.

arrow symbol

Method 2

Right click on the ribbon, and click on “Collapse the Ribbon”.

Collapse the Ribbon

Method 3

The fastest way to minimize the ribbon is by pressing a shortcut key “Ctrl + F1”.

Ctrl + F1

Maximizing the Ribbon

Method 1

Right click on the ribbon, and un-tick the “Collapse the Ribbon” option. 

Collapse the Ribbon

Method 2

The fastest way to pin the ribbon is by pressing the shortcut key “Ctrl + F1”.

Customizing the Ribbon

To customize the ribbon, right click on the Ribbon and click on “Customize the Ribbon” options

Customize the Ribbon

This will option the ribbon customization window

ribbon customization

In this example, a new tab has been added.

new tab

And it is renamed as DEMO TAB

DEMO TAB

Now this tab is visible next to File Menu

File Menu

Multiple handy options like All Charts type, Cut, Font Color and Format Cells have been added for demonstration purpose.

More Related Articles For You

    Microsoft Excel Tutorial

Search

Shortcodes Ultimate

 
Follow Us
 
BGP