"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.

• 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.

• 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.

• 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.

• 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: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb