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:
Another important use of the QAT is for creating a new workbook in Excel 2007 and 2010. In Excel 2007, if you click on the Office Logo found in the top left hand corner of the spreadsheet to create a new workbook, you will have to go through another step of selecting a workbook. But if you have the new workbook icon in the QAT, you can create a new workbook in one click.
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!