The groups in Excel Ribbon have many additional commands.
By clicking the button, you can run the related command.
Each group contains buttons, sub-menus, and dialog box launchers. Select Customize Ribbon and check the Check box next to Developer and then click OK.Ģ) Groups: Each Tab has its own specific groups of related commands. To make the Developer tab visible, follow these steps.Ĭlick File tab in Ribbon and then click Options in the left panel. The Developer tab contains commands for Excel VBA programmers. You need to configure the Options to make it visible. There is another important tab in Excel Ribbon called as "Developer", which is not visible by default.
Help : Help tab contains mainly the options to get help on Excel. View : View tab contains mainly commands to view the Excel worksheet, like change views, freeze panes, arrange multiple windows etc. Review : Review tab contains tools mainly for spell checking, thesaurus, sharing, protecting and tracking changes in Excel Worksheets. It has options for importing external data. 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.
0 kommentar(er)
