Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kind 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 in 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 ‘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 ‘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 that they are showing in the Ribbon. For example, ‘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 ‘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

What is Ribbon in Excel. Dialog box launcher.

Read More…

Working with Dialog Boxes in Excel

How to show the Developer Tab on the Ribbon

Types of commands on the Ribbon


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 here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply