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 theQuick 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 theRibbon. 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.... HighlightFind 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.