Quick Access Toolbar Functions In Microsoft Excel

Table of Contents[Show]
Quick Access Toolbar Functions In Microsoft Excel

Understanding and Functions of the Excel Quick Access Toolbar

What is the meaning and use and function of the quick access toolbar button in Microsoft Excel? Microsoft Excel provides Quick Access Toolbar or abbreviated as QAT on the top of the excel ribbon on the left. The function of the Quick Access Toolbar is to place command buttons that are often used in Microsoft so that it becomes easier to run these commands. By default the Quick Access Toolbar consists of three buttons, namely, Save (to save the file or document we are working on), Undo (to cancel the last command), and finally Redo.

Understanding and Functions of the Excel Quick Access Toolbar


(To cancel Undo or repeat a canceled command). 

Of course, we can add or reduce the menu icon in the QAT section as needed, such as the Excel Ribbon.

Change the Position of the Quick Access Toolbar

By default the Quick Access Toolbar is located on the ribbon. We can move this position to the bottom of the excel ribbon in the following ways:

Click or select the small triangle icon on the far right to open the Customize Quick Access Toolbar options. Then in the window that appears select Show below the Ribbon.

Change the Position of the Quick Access Toolbar

If you want to return the position of the Quick Access Toolbar back to the top of the ribbon, do this step then select the Show above the Ribbon menu

Quick Access Toolbar back to the top of the ribbon

Add / Remove Menu Icons on the Quick Access Toolbar

To add or remove menu icons on the Excel Quick Access Toolbar, open the Customize Quick Access Toolbar window by clicking on the small triangle icon on the far right of QAT as before.

This section will display several menu options or features that we can select or activate to appear in QAT. A check mark indicates that the menu is active, to disable it, click the menu option. If the menu button that you want to display on the Quick Access Toolbar is in the Customize Quick Access Toolbar window option above, click on the More Commands section to select other menus.

Add / Remove Menu Icons on the Quick Access Toolbar
Add / Remove Menu Icons on the Quick Access Toolbar


In the box on the left, find the menu you want to display on the Quick Access Toolbar then select it and click ADD. If you want to delete the menu icons that appear on the Quick Access Toolbar, select the menu you mean on the right side of the box then click REMOVE. Before leaving, don't forget to bookmark and share this excel tutorial article with the buttons provided below. Greetings Excel Class.

Leave a Comment