"Customize Quick Access Toolbar (QAT) - Adding Commands to the QAT"


Customize Quick Access Toolbar in Excel 2010 - Why and How?

As you continue to work with Excel 2010, you might discover that you use certain command buttons much more often than others. In that case, you can make the button accessible with one click by adding the button to the Quick Access Toolbar.

Once added the command buttons to the Quick Access Toolbar, you can run the commands with a single click, so adding your favorite commands saves time. By default, the Quick Access Toolbar contains three buttons: Save, Undo, and Redo, but you can add any of Excel's hundreds of commands.

Since there is only so much room for the Quick Access Toolbar in Excel's menu bar, consider moving the Quick Access Toolbar below the Ribbon to gain more space for your custom commands. This article will guides you on that.


To customize the quick access toolbar

  • Click the down arrow at the right to the Customize Quick Access Toolbar and from the menu displayed, click More Commands option.
  • customize quick access toolbar options

  • From the Excel Options dialog box displayed, Excel automatically displays the Quick Access Toolbar tab.
  • Click the Choose commands from: drop-down menu and select the appropriate tab that contains the command that you wish to add to the QAT. For example, select the File Tab.
  • Excel options box quick access toolbar

  • You will notices that a list of commands from the File tab appears. Click the command you want to add (for example, click the Open command).
  • Click Add >> button. Excel adds the Open command to the QAT.
  • customize quick access toolbar

  • To remove a command, click it (such as Open command) and then click << Remove button.
  • When finish, click the OK button. Excel adds a button for the command to the Quick Access Toolbar.


To move the quick access toolbar

  • Click the down arrow at the right to the Customize Quick Access Toolbar and from the menu displayed, click Show Below the Ribbon option. The QAT moved to the bottom of the Ribbon.
  • moving the quick access toolbar

  • If you wish to move the toolbar back to the default location, click the down arrow at the right to the Customize Quick Access Toolbar and from the menu displayed, click Show Above the Ribbon option.

Related Topics:

Getting Started with Microsoft Excel 2010

Knowing the Excel 2010 Screen Elements

Understanding the Excel 2010 Ribbon

Customizing Excel 2010 Ribbon by Adding New Tab, Group and Command to It

Adding and Removing Commands From The Quick Access Toolbar



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Customize Quick Access Toolbar info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Resources:

Click on the image to view the details of the training/book.
Excel 2010 formulas ebook
Microsoft Excel 2010 Formulas


Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.