Quick Access Toolbar in Excel

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.

Excel 365 Update

  • Visible by Default: Unlike Excel 2016, Excel 365 shows the Quick Access Toolbar (QAT) by default, providing immediate access to commonly used functions.
  • Customization Carries Over: Users familiar with customizing the QAT in Excel 2016 can continue to do so in Excel 365. Add frequently used commands for a personalized experience.
  • Core Functionality Remains:┬áThe core functionality of adding, removing, and rearranging commands on the QAT remains unchanged from Excel 2016.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.