How to Add Quick Access Toolbar to Microsoft Excel

Quick Access Toolbar is a toolbar that allows you to access commands quickly and you can customize the commands you use frequently. The things you can add to the Quick Access Toolbar are Command Buttons, tools that are not visible on the Ribbon and macros that you create. The following tutorial 5 How to add Quick Access Toolbar in Excel including how to remove the icon on the Quick Access Toolbar and move the layout of the Quick Access Toolbar.


By default the Quick Access Toolbar provides the following commands

Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

  • The Button with the Disk Icon is used to save the document
  • The Button with the Icon to the left is Undo
  • The button with the Icon to the right is Redo
  • The Drop Down button is a Quick Access Toolbar customization button

Here are the steps to add the Quick Access Toolbar button

A. How to Add Quick Access Toolbar with Drop Down

  1. Click the Drop Down button on the Quick Access Toolbar

  2. If the desired command is in the list, then click the command until a check mark appears

    Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

  3. If the command is not in the list, then click “More Commands” so that the following dialog box appears

    Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

  4. For example, the “Insert Equation” command will be added to the Insert Menu

    1. Choose Choose Command From “Insert Tab”

    2. Select “Insert Equation” in Options

    3. Click Add

    4. Click OK

      Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

  5. Then “Insert Equation” is added to the Quick Access Toolbar


B. How to Add Quick Access Toolbar with Ribbon

This method is the easiest way to add the Quick Access Toolbar.

  1. For example, the “Paste” command will be added in the Home Menu

    Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

  2. You Just right click on the icon and select Add to Quick Access Toolbar

    Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

  3. Then the icon is displayed on the Quick Access Toolbar

    Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel


C. How to Easily Remove Icons on the Quick Access Toolbar

To delete a command on the Quick Access Toolbar, right-click the command icon to be deleted on the Quick Access Toolbar and select Remove from Quick Access Toolbar.

Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel


D. How to Remove Icon in Quick Access Toolbar with More Command

You can also use the more command chat box like the first method.

  1. Click the Drop Down button on the Quick Access Toolbar

  2. Select More Commands

    Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

  3. For example, the paste icon will be removed in the Quick Access Toolbar

    1. In the right column select “Paste”
    1. Click Remove so the command is missing in the column
    1. Click OK
  4. Then the icon was successfully removed


E. How to Move the Quick Access Toolbar above or below the Ribbon

You can move the Quick Access Toolbar layout, you can click it Drop Down then select “Show Below the Ribbon” to move under the Ribbon and “Show Above the Ribbon” to put it back on the Ribbon.

Quick Access Toolbar is a toolbar that allows you to access commands 5 Ways to Add Quick Access Toolbar to Excel

source: https://www.advernesia.com

Someone who has an aloof personality, without knowing the outside world only through the online world.

  • Facebook
  • WhatsApp
  • Instagram