Sunday, November 13, 2011

How to get commonly used commands in the Quick Access Toolbar?

Before I write something, please see this:


These are the two commands that I use more than 10 times a day. One is to select Visible cells only and the other one is to Remove Duplicates. I have added these buttons to my Quick Access toolbar so that I do not have to do multiple clicks to perform the operation.

The quick access toolbar can be customized to show any of your commonly used command. To customize it, go to Excel options - Customize. You can select the commands from the left hand side drop down & list box and add them to the toolbar (i.e. the right side listbox).




Hope it will make your task a little quicker!

No comments:

Post a Comment