Excel: Quick Access Toolbar

Quick Access Toolbar was created to give users easy access to frequently used options and features. It is located above the ribbon, and like the ribbon it can also be adjusted to your preferences.

 

Changing the position of the Quick Access Toolbar

By default, the toolbar is located above the ribbon. If you want to change its position and move it below, click the Customize Quick Access Toolbar button (it is located to the right of the toolbar) and choose Show Below the Ribbon

 

If you want to restore the Quick Access Toolbar to its original position, select Show Above the Ribbon.

Selecting additional options

After you click the Customize Quick Access Toolbar button, the menu with the list of several different items will appear. Some of them are selected by default (you can unselect them). These are Save, Undo, and Redo. If you want to add additional options, just click one of them, and the new icon will appear in the Quick Access Toolbar.

 

If you want to add some additional options that are not present on the list, click the More Commands position, which is located at the bottom of the menu.

From the menu to the left, click one of the buttons, then click Add. When you click OK, the new items will appear in the toolbar.

 

Removing unnecessary icons

To get rid of the icon from the toolbar, right-click it and from the drop-down menu, select Remove from Quick Access Toolbar.