How Quick Access Toolbar makes even shortcuts shorter

Now let’s see how Quick Access Toolbar can make some shortcuts redundant with the help of an example. 

In a workplace we often end up getting a file that has been poorly drafted. Before we move on with our work, it becomes necessary to do a bit of formatting and editing on the file. For example, consider the following –

It is clear from the screenshot that we need to adjust the column width to give the data a clean and proper look. Now this can be done in two ways –

a) Adjusting the width by dragging the boundary of the concerned column.

b) Using the following shortcut – ALT > H > O > I

Any of the above will do the job. But you will have to repeat it every time the column or row entries needed adjustment. This is where the quick access toolbar comes handy. All you need to do is add ‘Autofit Column Width’ from the list of commands on the toolbar. 

Now select the concerned column as shown below

Click on the shortcut for Autofit Column Width on the quick access toolbar and voila! Your job is done in a single click. Isn't it wonderful?

Similarly you can shorten several long shortcuts to make your working on Excel even easier and faster.

In our next article we will be learning about different cell editing modes. 

Quick access toolbar utility in MS Office

Have you thought about making a keyboard shortcut shorter? Sounds funny? But it’s true. Quick Access Toolbar allows to you to do just this.

Saving time is one of our foremost objectives while using Microsoft Excel. There are a number of features in MS Excel 2007 and 2010 that help us achieve that. Quick access toolbar is one such wonderful feature.

Often we find that some actions need to be repeated frequently like saving, print preview, opening new file etc. Wouldn't it be better, then, to have the shortcuts to these features right in front of you where you can use them quickly and easily? This can be done through the Quick Access Toolbar.

The Quick Access Toolbar is a customizable toolbar that allows you to store the shortcuts of the commands on the top left corner of Excel workbook. By default you will have few commands on the toolbar. However, you can add more commands to the toolbar by following these easy steps –

1. Click on the down arrow given at the end of the Quick Access Toolbar. A drop-down menu will open. Choose the option ‘More Commands’ from the list

2. A dialog box called ‘Excel Options’ will appear in front of you. 

(Alternative way of opening it in MS Excel 2010 is File Tab >> Options >> Customize Quick Access Toolbar)

3. Click on ‘Customize’ in the left. Another drop down menu will emerge. Select ‘All Commands’ from the options. 

4. You will see a complete list of commands in front of you. You can browse this list tab-wise

5. Select the commands you want on the quick access toolbar and click on ‘Add’. Here we have selected Paste. 

6. Once all the needed commands have been added, click OK. 

7. Shortcuts of all the required commands will now be on toolbar where you can access them quickly. 

8. Note that the order followed here will result in shortcuts accordingly (i.e. ALT > 1, ALT > 2, ALT 3 etc)

In next article we will see how quick access toolbar can make even the use of shortcuts redundant in some case.