Introduction To Excel Ribbon | How to Use Excel Ribbon | Excel Ribbon Tabs Detailed | Excel Ribbon Components

This page introduces you to some of the Basic of Excel ribbons that will surely help you to understand about functionalities provided by excel on its ribbon.

Excel Ribbon is a strip of buttons and icons. The buttons and icons in Excel Ribbon are grouped into different tabs based on the category of their functionalities.


Main components of Excel Ribbon are:-
Tabs: Tabs contain groups of Excel commands arranged based on the command's functionality

File-The File tab in Excel Ribbon is used to open Excel Backstage View. It contains many options to work with the Excel file & customization.


Home-Home Tab contains commonly used Excel commands like copy, paste, format, find, replace etc.


Insert-Insert Tab contains objects you can insert to your worksheets like tables, pictures, charts, icons, shapes etc.


Page Layout-Page Layout tab contains options mainly for page setup and print.
Formulas-Formulas tab contains options mainly for inserting and troubleshooting Excel functions.


Data-Data tab contains options mainly for filtering, sorting and manipulating data. It also has options for importing external data.


Review-Review tab contains tools mainly for spell checking, thesaurus, sharing, protecting and tracking changes in Excel Worksheets.


View-View tab contains mainly commands to view the Excel worksheet, like change views, freeze panes, arrange multiple windows etc.


Help-
Help tab contains mainly the options to get help on Excel.


There is another important tab in Excel Ribbon called as "Developer", which is not visible by default.The Developer tab contains commands for Excel VBA programmers.

To make the Developer tab visible, follow these steps.
Click File tab in Ribbon and then click Options in the left panel.
Select Customize Ribbon and check the Check box next to Developer and then click OK.

The below Video explains and show the examples of the above mentioned functionalities of Excel on How to Create, Save, Copy, Hide and Unhide Excel Worksheets?


Comments