Hidden secrets in Excel Quick Access Toolbar
Excel Quick Access Toolbar is a very powerful tool yet many people including Excel gurus tend to underutilize it.
This toolbar gives you all the build in functions available in Excel including those that are not seen in Excel ribbon
(hence not known by most of the people). This article will show you one example on how this toolbar can drastically
change your Excel experience.
Let's first take a look of that an ordinary worksheet with comment in Excel 2007 looks like.
Notice that there is no option available in the Excel ribbon which allows you to do any kind of formatting on the
shape of the comment. You only have one choice: rectangular box.
Now take a look of the following:
It looks nice, but how to do it?
The answer is Quick Access Toolbar (QAT).
Follow the steps below:
- Click on the inverted triangle on the QAT and choose "More Commands".
- In the customization window, choose all commands from the dropdown list
- Scroll down to find the "Change Shape" command and click on "Add" button to add the command to the QAT and make
sure the command appears in the box on the right hand side.
- Now go back to your worksheet and click on the normal comment you have and click on the "Change Shape" command in the
QAT. Now you have access to a rich pool of shapes. Take the one you like and make your comments full of fun!
As you can see, there are many others features available in the QAT. In future articles, we will be introducing more
useful commands which can really improve your productivity and user experience with Excel. Stay tuned!