17

Setup the Excel Quick Access Toolbar (QAT)

The Quick Access Toolbar (QAT) in Excel 2007 is a great option for shortcuts to your most used commands.  It’s faster to click on an icon in the QAT (one click) versus clicking on the ribbon tab and then the command (two clicks + mouse navigation).  And you can use keyboard shortcuts for the QAT to make things even easier.

The Setup

Setting up the QAT is simple and consists of two steps:  Adding commands and arranging the icons.

The easiest way to add commands to the toolbar is to:

  1. Navigate to the command you want to add in the ribbon.
  2. Right click on the icon and select Add to Quick Access Toolbar from the drop down menu.

QAT Add Item

The command icon will be added to the end of the QAT.

To arrange the icons:

  1. Right click anywhere on the QAT and select Customize the Quick Access Toolbar… from the drop down menu.Customize QAT drop down
  2. The Excel Options menu opens and you can move your icons to the left or right by selecting the icon in the right box and pressing the up or down arrows.
QAT Options

Click Image to Zoom

The order of the icons becomes important when you are using keyboard shortcuts to access the commands.  And I highly recommend this as a much faster way to execute commands in Excel, versus using the mouse.  You can also use the Options window (above) to add and remove commands from the toolbar.

So what icons should I add to the Quick Access Toolbar?

This will depend on what you use Excel for and which commands you use most often.  If you are doing lots of data entry and manipulation you might want to have the “Paste Values” and “Format Painter” commands at the top of your list.  Reporting and analyzing, you may want some charting and page layout commands.  The key is to have the commands you use most often located closest to the left because the keyboard shortcuts are easier to press with your thumb and index finger.

Move the QAT

The toolbar can be place above or below the ribbon by clicking the down arrow to the right of the QAT and selecting Show Below the Ribbon or Show Above the Ribbon.

Move QAT

I prefer to have it above because it reduces the total vertical height of the top toolbars, which gives you more spreadsheet real estate.  But you may find that you have so many icons that it fits better below the ribbon.  If you are a heavy mouse user (vs. keyboard shortcuts) then it is also easier to navigate to the QAT if it is below the ribbon.

Checkout my recommendations on commonly used commands for the Quick Access Toolbar.

[print_link]

Please share
Jon Acampora
 

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

Click Here to Leave a Comment Below 17 comments
Ghost - April 22, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. TlRoZvzm0ZV78TfO

Your automation Ghost!

Reply
Ghost - April 21, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. 6vQR1OOGPH5YXXvi

Your automation Ghost!

Reply
Ghost - April 20, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. 8WOYeTRQ4vdKrRv9

Your automation Ghost!

Reply
Ghost - April 19, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. pOGnm0M42xYIT3vQ

Your automation Ghost!

Reply
Ghost - April 18, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. 7XFXFrfHiGH88Ysi

Your automation Ghost!

Reply
Ghost - April 17, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. TncWHFzSPH9GnzAZ

Your automation Ghost!

Reply
Ghost - April 16, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. TiSSQIHk928B8NTJ

Your automation Ghost!

Reply
Ghost - April 15, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. KFZ57x13ED0w8Tr4

Your automation Ghost!

Reply
Ghost - April 14, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. rOBxG78pEteiD0xs

Your automation Ghost!

Reply
Ghost - April 12, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. YaAvxaImNEyUSlKH

Your automation Ghost!

Reply
Ghost - April 11, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. QN2NdBCeKFp0KmhA

Your automation Ghost!

Reply
Ghost - April 10, 2018

Hi Jon!

This is your daily automated comment test! If you see this, great! Everything is working perfectly. You may delete this comment. RsMxRup4UW5DZISE

Your automation Ghost!

Reply
Venus - October 30, 2017

Very helpful!

Reply
Jamie - May 6, 2016

I’ve been on your website for 15 minutes and have already found 3 things tips that will make my daily life in Excel SO much better! Just subscribed to your newsletter and downloaded your Formatting Shortcuts add-in. Definitely bookmarking this site!

Reply
    Jon Acampora - May 6, 2016

    Woohoo! Thanks Jamie! You made my day! I really appreciate the nice feedback and support. Welcome to the Excel Campus community. 🙂

    Reply
Vamsi Krishna - November 19, 2015

I had been searching something like from a long time.. Thank you so much, this would save soooo much of time with for me

Reply

Leave a Reply: