Paul Wherly

Customising the Quick Access Toolbar in Excel 2010

Quick Tip for Microsoft Excel 2010

The Quick Access Toolbar  is where you can store and use shortcuts to Excel functions you use most often.  Here are some steps to follow for customising your Quick Access Toolbar:

Customising the Quick Access Toolbar (QAT)


To add a function you use often to the Quick Access Toolbar:

  1. Click on the drop down arrow (1)
  2. Click on the function you would like to add (2)

The function will then appear as a button on the QAT

Adding a Less Common Function to the Quick Access Toolbar


  1. Click on the QAT drop down arrow (1)
  2. Click on More Commands (2)


  1. Choose the command category from the drop down list (1)
  2. Click to select the command you want to add to the Quick Access Toolbar(2)
  3. Click on Add (3)
  4. Click on OK (4)
[callout]To learn more about our Excel training and how it can help your staff-  give us a call on  020 8203 1774  and see how we can help your organisation improve their performance with Microsoft Excel[/callout]

Shelley Fishel

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.