How To Add Non-Ribbon Commands to Quick access toolbar in Excel


Introduction :

We now know very well how to customize quick access toolbar in Excel and add commands and buttons to QAT. We have also seen the steps to add ribbon buttons to the quick access toolbar. In this tutorial we'll learn how to add Non-ribbon commands to QAT. There are a lot of commands that are not present on the ribbon but can be used quite frequently while dealing with large spreadsheets. In this case we can add these commands to the quick access toolbar.

How to add Non-ribbon commands to the Quick access toolbar?

Here are the steps involved in adding non-ribbon commands to the quick access toolbar.

Step 1 :

Click on the Quick Access Toolbar Customization button.

Add Non-Ribbon Commands to Quick access toolbar
Step 2 :

From the drop down list that appears, choose the “More Commands…” option.

Add Non-Ribbon Commands to Quick access toolbar
Step 3 :

Locate the “Choose Commands From” dropdown in the top left portion of the dialog box that appears. The list below this dropdown lists the commands according to the option selected in this dropdown. Initially the “Popular commands” option is selected.

Add Non-Ribbon Commands to Quick access toolbar
Step 4 :

Choose the option “Commands not in the Ribbon” from the dropdown list.

Add Non-Ribbon Commands to Quick access toolbar
Step 5 :

The list below the dropdown now lists all the commands that are not listed in the Ribbon. Locate the command that you want to add in the Quick access toolbar. We have chosen the calculator command as an example.

Add Non-Ribbon Commands to Quick access toolbar
Step 6 :

Select the desired command and then click the “Add >>” button in the right of the list.

Add Non-Ribbon Commands to Quick access toolbar
Step 7 :

You can see that the calculator command is added in the right side list. Click “OK”.

Add Non-Ribbon Commands to Quick access toolbar

 

Your selected command will now be available in the Quick access toolbar.

Add Non-Ribbon Commands to Quick access toolbar

Conclusion :

It is very important to know all the ways in which we can customize the software that we are using. That is why we have created these tutorials that deal with customizing Excel.