How to Add or Remove commands to the Excel Quick Access Toolbar

The Quick Access Toolbar in Excel 2010 is a great timesaver for regular Excel users, read on to discover how to Add or Remove commands to the Quick Access Toolbar and speed up your Excel work today…

What is the Quick Access Toolbar?

The Quick Access Toolbar in Excel is a conveniently located area on the Workbook where you can access frequently used commands with a single click. For example if ‘Paste Special: Values’ is a command you use all the time then it would be worth adding to the Quick Access Toolbar so it becomes a single click process saving you time.

 

 

Where is the Quick Access Toolbar?

The Quick Access Toolbar is located above the main components of the Ribbon starting on the top-left side of the workbook. By default you will have icons for Save, Undo and Redo placed in the Quick Access Toolbar:

00076_Quick Access Toolbar_24042015_1

How do I add or remove commands to the Quick Access Toolbar?

The process is very simple, first left-click on the black downward arrow which is directly on the right hand side of Quick Access Toolbar:

00076_Quick Access Toolbar_24042015_2

Then select ‘More Commands…’ from the Customise Quick Access Toolbar options box:

00076_Quick Access Toolbar_24042015_3

The Excel Options box will open and this allows you to Add or Remove commands to the Quick Access toolbar:

00076_Quick Access Toolbar_24042015_4

If you want to Add ‘Paste Special: Values’ to the Quick Access Toolbar then you would first select All Commands from the Command Category Drop Down:

00076_Quick Access Toolbar_24042015_5

All the available commands, sorted by Name, will then show in the left hand box. Scroll down until you find Paste Values and left-click to select:

00076_Quick Access Toolbar_24042015_6

Then left-click on Add:

00076_Quick Access Toolbar_24042015_7

You have now added the Paste Values command to the Quick Access Toolbar, left-click OK to close down the Excel Options box and return to your workbook:

00076_Quick Access Toolbar_24042015_8

When you have finished adding or removing any commands in the Excel Options box and clicked OK you will immediately see the results in the Quick Access Toolbar:

00076_Quick Access Toolbar_24042015_9

Time Saving Tips for the Quick Access Toolbar

  • Think about the commands you use on a regular basis and be sure to add anything that you use often when working in Excel.
  • If you are an Excel developer or Excel Analyst consider some of the commands that are either not available on the ribbon or multiple clicks away. One of the command categories in the drop down menu is for ‘Commands Not in the Ribbon’ and it contains some very useful commands like ‘Paste and Transpose’, ‘Privacy Options’ and a host of others.
  • Try not to overload the Quick Access Toolbar and stick to the main commands that you use. A cluttered Quick Access Toolbar will lead to you hunting around looking for commands and in the end that is no quicker than the old way!

Hopefully you now have an overview of the Quick Access Toolbar in Excel and understand how easy it is to add or remove commands to save a heap of time. If you are not using the Quick Access Toolbar or maybe just forgotten its existence then now is the time to start using it again and making it work to save time in your Excel work.

Keep Excelling,

Leave a Comment