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.