Understanding contextual tabs in Excel Ribbon

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.

Working with contextual tabs

We shall add a shape to the Excel worksheet. Follow the following steps:

  1. Open your Excel program and create a new worksheet. When you have opened your worksheet, click the Insert tab.
  2. Click on the ‘Shapes’ button of the ‘Illustrations’ group of commands.
  3. Click the ‘Rounded Rectangle’ shape from ‘Rectangles’.
  4. Click anywhere on your worksheet to place your selected ‘Rounded Rectangle’ shape.
  5. 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.
What is Ribbon in Excel

What is Ribbon in Excel? Contextual Tab. Step 1, 2, 3, and 4

What is Ribbon in Excel

What is Ribbon in Excel? Contextual Tab. Step 5.

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.

What is Ribbon in Excel

What is Ribbon in Excel? Group of commands.

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.

What is Ribbon in Excel

Read More…




Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply