We have already read about the importance of Quick access toolbar while exploring the Excel Worksheet. We have also seen, how to customize the quick access toolbar. In the previous tutorial we even had a look at how we can add more buttons to the Quick access toolbar. The previous tut was infact a generic method and in this tutorial we'll look at how to particularly add Ribbon commands to the QAT. There are some very important commands on the ribbon that we use very often and it is advised that we add these commands to the quick access toolbar - here's how to do this.
Add Ribbon Commands to the Quick access toolbar
Go to the tab on which the desired command is located. Suppose we want to add the Merge and Center command to the Quick access toolbar then first go to the Home tab.
Go to the command that we want to add to the QAT. In our case go to the “Merge and Center” command.
Right click on the Command. In our case right click on the “Merge and Center Command”
Click on the “Add to Quick Access Toolbar” Option at the top of the context menu.
A new button is now visible in the Quick access toolbar. In our case it is the “Merge and Center” command button.
How to remove Ribbon buttons from the Quick Access toolbar –
Go the command button in the Quick Access toolbar that you want to remove.
Right click on that command button.
Click on the “Remove from Quick Access Toolbar” Option at the top of the context menu.
The command button is now removed from the Quick access toolbar.
It is very important to add frequently used commands to the quick access toolbar of the excel worksheet. Most commonly ribbon commands should be added to the QAT as it will make your work easier and you'll look more proficient in Excel.