Ribbon Commands in Excel (Detailed Explanation)

Different Types of Ribbon Commands in Excel

There are several types of commands in Excel. Different commands are for different purposes. Based on usage and formats, we can classify Excel Ribbon Commands into the following categories.


Type 1 – Simple Buttons

It’s easy to use the simple buttons. Increase Font Size button in the Home tab is an example of a simple button. Some simple buttons do what they’re supposed to right away, while others may bring up a box where we can find and insert more information.

ribbon commands


Type 2 – Toggle Buttons

When you click a Toggle button, its color changes. The Bold button in the Home tab is an example of Toggle button. Let’s say you want to make the text in a cell in bold. To do this, click on the cell to make it active, click the Bold command button and type something into the cell. The information you typed will be in bold, and the color of the Bold button will change. Clicking the Bold button again will return the text in the active cell to normal and restore the Bold button’s original color.

Toggle Buttons Ribbon Commands


Type 3 – Simple Drop-downs

Some commands on the Ribbon have a small arrow pointing down. These are drop-down commands. If you click on a command in a drop-down menu, other commands will appear below it. The Format command in the Cells group of the Home tab is an example of a simple drop-down. If you click on this button, the screen will show you other commands that are useful.

Simple Drop-downs Ribbon Commands

Read More: How to Show Menu Bar in Excel


Type 4 – Split Buttons

Split buttons have two activities: one-click activity and a button that opens a drop-down menu. When the button is clicked, the command is applied. By clicking the down arrow, several other similar types of commands that might be useful will show up on the screen. In the Alignment group of the Home tab, the Merge & Center button is an example of a Split button. Click the left part of this command to merge and center the text in a cell. Click the arrow on the button to get more commands for Merges & Centers.

Split Buttons Ribbon Commands

Read More: How to Show Ribbon in Excel


Type 5 – Checkboxes

A checkbox makes something work or not work. The Headings command in the View tab is an example. When the box next to Headings is ticked, the sheet shows Headings (Column letters & Row numbers). The headings don’t show up when the control isn’t checked.

Checkbox


Type 6 – Spinners

In the Excel Ribbon, there is a single Spinner button. It’s in the Page Layout tab. If you click the top of the spinner, the value goes up, and by clicking the bottom, the value goes down.


Type 7 – Dialog Box Launcher

In the bottom-right corner of some Ribbon groups, there is a small diagonal array icon. It’s called a launcher for dialog boxes. For example, the Clipboard, Font, Alignment, and Number groups have dialog box launchers on the Home tab, but the Styles, Cells, and Editing groups do not. If you click the icon, Excel will show a dialog box with commands related to the group.

Dialog Box Launcher

Read More: How to Pin the Ribbon in Excel


Difference Between Drop-down Button & Split Button

Small arrows are on both kinds of buttons. When you move your mouse pointer over a simple drop-down button, the whole button will change color. There are two parts to the split button. If you move your mouse pointer over the left part, the color of the left part will change, but not the color of the arrow part. If you click on the arrow, the whole command button will change color and show the relevant commands in a drop-down menu.


Download Practice Workbook


Related Articles


<< Go Back to Excel Ribbon | Excel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Tags:

Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo