When you will work with charts or shapes or these kinds of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual tabs contain commands related to objects that you have selected.
For example, if you add a rectangular shape in your worksheet and select it, a contextual tab naming ‘FORMAT’ will appear after the last tab in the tab zone.
Table of Contents
Working with contextual tabs
We shall add a shape to the Excel worksheet. Follow the following steps:
- Open your Excel program and create a new worksheet. When you have opened your worksheet, click the Insert tab.
- Click on the ‘Shapes’ button of the ‘Illustrations’ group of commands.
- Click the ‘Rounded Rectangle’ shape from ‘Rectangles’.
- Click anywhere on your worksheet to place your selected ‘Rounded Rectangle’ shape.
- Select the new shape by clicking on it. You will see the contextual tab, labelled ‘Format’. ‘Format’ tab will be visible only if you select the shape.
Group of commands in Excel Ribbon
Under every tab, the command buttons reside in the group. A group contains loosely similar commands. Under the ‘INSERT’ tab, the ‘Tables’ group of commands is made up of ‘PivotTable’, ‘Recommended PivotTables’, and ‘Table’ command buttons.
Dialog Box launcher of Excel Ribbon
Some groups may have more commands than they are showing in the Ribbon. For example, the ‘PAGE LAYOUT’ tab’s Page Setup group has more commands than it is showing in the ribbon. How did we understand this? As there is a small arrow located in the lower-right corner of the ‘Page Setup’ group. Click on this small arrow and the dialog box will appear on the screen with more commands.