The Quick-access Toolbar

Contact Us or call 1-877-932-8228
The Quick-access Toolbar

The Quick-access Toolbar

The Quick Access Toolbar is a small toolbar which includes commonly used commands and is always accessible. By default, the Quick Access Toolbar is located in the top left corner of Microsoft Excel. By default, the Quick Access Toolbar includes three commands:

  1. Save. Click Save to save your workbook.
  2. Undo. Click Undo to undo the action you last performed.
    1. Click the drop-down arrow to the right of Undo to undo multiple actions at the same time.
  3. Redo. Click Redo to repeat the action you last performed.

Adding Common Commands

To add commonly used commands to the Quick Access Toolbar:

  1. Click the drop-down 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 drop-down 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 drop-down arrow on the far right of the Quick Access Toolbar.
  2. Select Show Below the Ribbon.
  3. To move it back, click the drop-down arrow again and select Show Above the Ribbon.
Next