MENU
The instructor was extremely organized and knowledgeable about Microsoft Project, and her class has enabled me...More Testimonials »

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.

Customize the Quick Access Toolbar

Duration: 10 to 20 minutes.

In this exercise, you will customize the Quick Access Toolbar.

  1. Add the following commands to the Quick Access Toolbar:
    1. New
    2. Open
    3. Quick Print
    4. Paste
    5. Find
  2. Remove Find from the Quick Access Toolbar.
  3. Move the Quick Access Toolbar below the Ribbon.

Solution:

  1. To add commands to the Quick Access Toolbar:
    1. New: click the drop-down arrow to the right of the Quick Access Toolbar and check New.
    2. Open: click the drop-down arrow to the right of the Quick Access Toolbar and check Open.
    3. Quick Print: click the drop-down arrow to the right of the Quick Access Toolbar and check Quick Print.
    4. Paste: click the drop-down arrow to the right of the Quick Access Toolbar and select More Commands.... Highlight Paste in the left column and click Add > >.
    5. Find: click the drop-down arrow to the right of the Quick Access Toolbar and select More Commands.... Highlight Find in the left column and click Add > >.
  2. To remove Find from the Quick Access Toolbar:
    1. Click the drop-down arrow to the right of the Quick Access Toolbar and select More Commands.... Highlight Find in the right column and click < < Remove.
  3. To move the Quick Access Toolbar below the Ribbon:
    1. Click the drop-down arrow to the right of the Quick Access Toolbar and select Show Below the Ribbon.
    2. Optional: to move the Quick Access Toolbar back above the Ribbon, click the drop-down arrow to the right of the Quick Access Toolbar and select Show Above the Ribbon.

Entering Data in Microsoft Excel Worksheets → ← The Backstage View (The File Menu)

Client Success
  1. Compare Us
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
© Webucator, Inc. All rights reserved. |Toll Free: 1-877-932-8228Toll Free: 1-877-932-8228 |Outside the USA: 315-849-2724|Fax: 315-849-2723