And why should I use it?

When I first discovered the quick access toolbar in excel I thought none of it. Why would anyone use it, when all the commands are available in excel anyways?

Then it dawned on me. The shortcuts on the quick access toolbar are set from 1 to 9. So technically you can get a set of shortcuts, you just need to be used to the number shortcuts when you press the Alt modifier key.

Excel quick access toolbar with the Alt key pressed

You can add any tools to any of the shortcuts.

I believe that by default the Save, Undo and Redo commands are assigned to the first three keys.
But I came up with a set of keys over the years that I found extremely time saving when working in an office environment.

My setup is the following

Quick Access toolbar Setup for General office work
  1. Format Painter
  2. Paste Special
  3. Filters On/Off
  4. No Borders
  5. All Borders (thin)
  6. Thick Outside Borders
  7. Freeze Panes
  8. Calculation Options (for when you work with large workbooks)

How to set up the toolbar?

“-It’s Easy, You can’t miss it!” – A quote from Dear Billy Connolly 🙂

All you need to do is to right click inside the toolbar (Note: try to right click where the icons are, otherwise you will be presented by the right click menu for the header.)
Then you can select out of the thousand commands available within the excel application from the left and add it to the right (representing your quick access toolbar.)
I suggest to change the left hand side Choose commands from:
menu from the default Popular programs to All Programs

Change Quick Access toolbar setup
from Popular Programs to All Programs

This way you will be able to see ALL the commands available within Microsoft Excel. Whatever you put to the right will be available at your fingertips. All you need to do is to press Alt first.

Want to find about who is behind the blog?
Who is the Angel?

Did you know that we have a facebook page?
Check out ExcelAngel on facebook!

[et_pb_ccfcm_facebook_comments_module ccfcm_app_id=”339898187197719″ _builder_version=”4.6.1″ _module_preset=”default”][/et_pb_ccfcm_facebook_comments_module]