Computer Club

"Excel 2010 Quick Access Toolbar (QAT) - Adding and Removing Commands"

To add a command to the QAT

• Select the Ribbon tab that contains the command you want to add.
• Right-click the command and click Add to Quick Access Toolbar in the menu that appears.

To quickly add some commands to the QAT

• Click the arrow to the right of the quick access toolbar and choose a command from the menu.





• The default 3 commands that appear on the QAT have the 'tick' beside the command.

To add an entire Ribbon command group to the QAT

• Just right-click an area in the command group name (for example, Paragraph in the Home tab) and choose Add to Quick Access Toolbar.

To remove a command (including the default commands) from the QAT

• Right-click the command you want to remove from the QAT.
• Choose Remove from Quick Access Toolbar in the menu that appears.

You can access commands on the Excel 2010 Quick Access toolbar using the keyboard. Press the Alt key and then a number key that represents the KeyTip for the command you want to access.

For example, Alt + 1 will save the worksheet.