Data : Data tab contains options mainly for filtering, sorting and manipulating data.

Formulas : Formulas tab contains options mainly for inserting and troubleshooting Excel functions.Page Layout : Page Layout tab contains options mainly for page setup and print.Insert : Insert Tab contains objects you can insert to your worksheets like tables, pictures, 3D models, charts, icons, shapes etc.Home : Home Tab contains commonly used Excel commands like copy, paste, format, find, replace etc.

Excel Backstage View is where data about the files is edited and managed. Excel Backstage View contains many options to work with the Excel file & customization. File : The File tab in Excel Ribbon is used to open Excel Backstage View.Those Tab labels are 'File', 'Home', 'Insert', 'Page Layout', 'Formulas', 'Data', 'Review', 'View' and 'Help'. For example, the 'Formulas' tab contains commands related with Excel functions and formulas.Īfter installation, if no customization done in Excel, the Excel Ribbon contains nine tabs in its Tab list as explained below. Main components of Excel Ribbon are explained below.ġ) Tabs: Tabs contain groups of Excel commands arranged based on the command's functionality. The buttons and icons in Excel Ribbon are grouped into different tabs based on the category of their functionalities.įour main components of Excel Ribbon are Tabs, Groups, Buttons and Dialog Box launcher. Excel Ribbon is a strip of buttons and icons, as marked in below image.

What is a dialog box launcher in excel