Sign up for a free trial of our self-paced courses.

Introduction to Microsoft Excel 2013 Tutorial

The Quick Access Toolbar

In this lesson, you will learn how to work with the Quick Access Toolbar.

Lesson Goals

  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.

Adding Common Commands

To add commonly used commands to the Quick Access Toolbar:

  1. Click the dropdown arrow on the far right of the Quick Access Toolbar.
  2. Select a command from the list that appears:

Adding Additional Commands with the Customize Dialog Box

To add additional commands to the Quick Access Toolbar:

  1. Click the dropdown arrow on the far right of the Quick Access Toolbar.
  2. Select More Commands... towards the bottom of the list that appears:
  3. Select a command from the list circled below and click Add > >.
  4. Click OK to make your changes.

Adding Ribbon Commands or Groups

If you find yourself using the same commands or group of commands frequently, you can quickly add them to the Quick Access Toolbar:

  1. Right click on the command or on the group name.
  2. Select Add to Quick Access Toolbar:

Placement

You can choose to keep the Quick Access Toolbar in the top left corner of Microsoft Excel or move it below the Ribbon. To move the Quick Access Toolbar below the Ribbon:

  1. Click the dropdown arrow on the far right of the Quick Access Toolbar.
  2. Select Show Below the Ribbon.
  3. To move it back, click the dropdown arrow again and select Show Above the Ribbon.