Microsoft Office Development and Consultancy

Excel

What is the Quick Access Toolbar ?

This is a customizable toolbar which can be used to contain your most frequently used commands.

This toolbar is independent of the tabs and is accessible from any tab.

This toolbar is often abbreviated to QAT.

By default the toolbar displays three commands: Save, Undo and Repeat.

What is the Customize Quick Access Toolbar menu ?

At the far right of this toolbar is a small black arrow.

Clicking on this arrow will display the "Customize Quick Access Toolbar" menu

Above or Below the Ribbon ?

There are only two places you can put this toolbar, either above or below the ribbon.

You have the option of displaying it above or below the Ribbon.

If you would prefer your quick access toolbar below the ribbon.

Display the Customise Quick Access Toolbar menu and select "Show Below the Ribbon".

or right click on any command and select "Show Quick Access Toolbar Below the Ribbon".

or from the Options dialog box by selecting (File > Options)(Quick Access Toolbar, "Show Quick Access Toolbar below the Ribbon".

If you put this toolbar above the ribbon then you can see more worksheet.

If you put this toolbar below the ribbon then it is more accessible.

Adding and Removing Commands

The quickest way to add (or remove) a command from this toolbar is to

Display the Customise Quick Access Toolbar menu and tick and untick certain commands

or right click any command on any tab and select "Add to Quick Access Toolbar".

Customizing the Toolbar

Display the Customise Quick Access Toolbar menu and select "More Commands"

or right click on any command and select "Customize Quick Access Toolbar"

or from the Options dialog box by selecting (File > Options)(Quick Access Toolbar)

In Excel 2007 this is (Office > Excel)(Customise tab)

For more details about how to add and remove commands from this toolbar please refer to the Quick Access Toolbar - Customize page.

Local XML File

C:\Documents and Settings\"user name"\Local Settings\Application Data\Microsoft\Office\Excel.qat

Things to Remember

There is no more quick drag and drop with the Alt key

You cannot display the Quick Access Toolbar on multiple lines.

You cannot increase the size of the buttons representing the commands by an option in Microsoft Office. The only way to increase the size of the buttons is to lower the screen resolution you use.