EXCEL 2007-RIBBONS

EXCEL 2007-RIBBONS


Ribbons is the most important part of Microsoft Excel 2007. It contains the majority of commands.

Ribbons have replaced the 2003 menus and toolbars


Lets go through the different ribbons

                   1. Home Ribbons contains the frequently used 
              commands.

 

2. Insert Ribbon as the name suggest it is used to insert or add elements

 3.Page Layout Ribbon contains commands which controls the appearances of the worksheet

4.Formula Ribbon: contains commands dealing with the power aspects of MS Excel Functions/Formulas

5.Data Ribbons: We will find commands which will help us to import information to excel from access database, text file and web, filtering data, grouping and ungrouping etc

6.Review Ribbon:contain commands which deals with protecting and sharing the workbook, worksheets, adding comments etc

7.View Ribbon:containcommands in which the worksheet can be viewed while working. Commands to Zoom in and Zoom out, working with multiple worksheet simultaneously.

8:Developer Ribbon:contains commands to create macro, automation etc:

To make the Developer tab visible Click on in the excel--> Click on Excel Options-->Click on Popular-> Check Show developer tab in the Ribbon

This brings us to the end of this topic. Happy Learning.