What do ribbon commands include in excel

Each group represents a function. The Number group includes commands that format numbers, for example, to increase or decrease the number of decimal places.

The Cells group includes options to insert, delete, and format cells. Selecting a command on the ribbon may lead to further options contained in a contextual menu or dialog box that relate to the chosen command.

The ribbon can be collapsed to increase the size of the worksheet visible on the computer screen. There are four ways to collapse the ribbon:. Since Excel , it has been possible to customize the ribbon using the Customize Ribbon option. Use this option to:. There are also command features that cannot be changed on the ribbon, specifically the default commands which appear in gray text in the Customize Ribbon window, for example:.

To add commands to the ribbon:. Select a tab, such as Home , Insert , or Page Layout. Right-click a blank area of the ribbon. Select Customize the Ribbon. Go to the Main Tabs list and select the tab for example the Layout tab to which you want to add a command. Then select New Group. A New Group Custom item appears under the tab you selected. To give the group a more specific name, select Rename. In the Rename window, select an icon, then go to the Display name text box and enter a descriptive name for the command.

Select OK. Select the group you just created. Data — holds the commands for managing the worksheet data as well as connecting to external data.

Review — allows you to check spelling, track changes, add comments and notes, protect worksheets and workbooks. View — provides commands for switching between worksheet views, freezing panes, viewing and arranging multiple windows.

Help — only appears in Excel and Office This tab provides quick access to the Help Task Pane and allows you to contact Microsoft support, send feedback, suggest a feature, and get quick access to training videos. This tab is hidden by default and you have to enable it first. Add-ins — appears only when you open an older workbook or load an add-in that customizes the toolbars or menu.

In addition to the constant tabs described above, the Excel ribbon also has context-sensitive tabs, aka Tool Tabs , which show up only when you select a certain item such as a table, chart, shape, or picture. For example, if you select a chart, the Design and Format tabs will appear under Chart Tools. Or you can hide the ribbon completely by clicking the Ribbon Display Options button at the upper-right corner of the Excel window, and then clicking Auto-hide Ribbon.

For more information, please see 6 ways to minimize and hide ribbon in Excel. Curious to learn 4 more ways to restore the missing ribbon? Check out How to show ribbon in Excel. If you wish to personalize the ribbon for your needs so you know exactly where everything is located, you can easily do that too. Your entry point to most customizations is the Customize Ribbon window under Excel Options. And the shortest path to it is to right-click on the ribbon and select Customize the Ribbon … from the context menu:.

From there, you can add your own tabs with any commands you choose, change the order of tabs and groups, show, hide, rename tabs, and a lot more. The detailed steps for each customization can be found in this tutorial: How to customize ribbon in Excel.

The problem is that the Developer tab is hidden by default. Excel Backstage View is where data about the files is edited and managed. It has options for importing external data. There is another important tab in Excel Ribbon called as "Developer", which is not visible by default.

You need to configure the Options to make it visible. To make the Developer tab visible, follow these steps. Click File tab in Ribbon and then click Options in the left panel. Each group contains buttons, sub-menus, and dialog box launchers. By clicking the button, you can run the related command.