Applies ToExcel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 OneNote for Microsoft 365 Project Online Desktop Client Publisher for Microsoft 365 Visio Plan 2 Excel 2024 Outlook 2024 PowerPoint 2024 Access 2024 OneNote 2024 Project Professional 2024 Project Standard 2024 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Project Standard 2021 Publisher 2021 Visio Professional 2021 Visio Standard 2021 OneNote 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Project Standard 2019 Publisher 2019 Visio Professional 2019 Visio Standard 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Access 2016 OneNote 2016 Project Professional 2016 Project Standard 2016 Publisher 2016 Visio Professional 2016 Visio Standard 2016 InfoPath 2013 SharePoint Workspace 2010

The customizable Quick Access Toolbar contains a set of commands that are independent of the currently displayed tab on the ribbon. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar. 

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Notes: 

  • You cannot increase the size of the buttons representing the commands by an option in Microsoft Office. The only way to increase the size of the buttons is to lower the screen resolution you use.

  • You cannot display the Quick Access Toolbar on multiple lines.

  • Only commands can be added to the Quick Access Toolbar. The contents of most lists, such as indent and spacing values and individual styles, which also appear on the ribbon, cannot be added to the Quick Access Toolbar. However, you can Customize the ribbon in Office to personalize the ribbon the way that you want it. For example, you can create custom tabs and custom groups to contain your frequently used commands.

What do you want to do?

Show or hide the Quick Access Toolbar

Right-click in the ribbon and do either of the following:

  • If the Quick Access Toolbar is shown, select Hide Quick Access Toolbar.Image of option to hide the Quick Access Toolbar

  • If the Quick Access Toolbar is hidden, select Show Quick Access Toolbar.Image of option to show the Quick Access Toolbar  

Note: You can also hide the Quick Access Toolbar in the Customize Quick Access Toolbar menu by selecting Hide Quick Access Toolbar

Move the Quick Access Toolbar

Location

The Quick Access Toolbar can be located in one of two places:

  • Above the ribbon, on the title bar (default location)Image of Quick Access Toolbar icon above ribbon

  • Below the ribbon Quick Access Toolbar location below ribbon

Change the location

You can move the location of the Quick Access Toolbar from one location to another.

  1. Select Customize Quick Access Toolbar.

  2. In the list, select Show Below the Ribbon. Quick Access Toolbar drop menu Show above the Toolbar or Show Above the Ribbon.Quick Access drop-down menu Show above the ribbone  

    Notes: 

    • You can set the location commands in Options.

    • Select File > Options > Quick Access Toolbar>Toolbar Position.

Show or Hide command labels on the Quick Access Toolbar

If the Quick Access Toolbar is set below the ribbon, you can show or hide the command labels.  

Important: The Quick Access Toolbar MUST be set below the ribbon to show or hide the command labels.

  1. Select Customize Quick Access Toolbar.

  2. In the list, select either Show Command Labels

Quick Access Toolbar drop-down menu select Show Command Labels or Hide Command Labels.

Quick Access Toolbar drop down select Hide Command Labels  

Add a command to the Quick Access Toolbar

  1. On the ribbon, select the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.

  2. Right-click the command, and then select Add to Quick Access Toolbar on the shortcut menu.Image of drop-down to Customize Quick Access Toolbar to add commands

Add a command to the Quick Access Toolbar that isn’t on the ribbon

  1. Select Customize Quick Access Toolbar > More Commands.Customize Quick Access Toolbar with More Commands highlighted

  2. In the Choose commands from list, select Commands Not in the Ribbon.

  3. Find the command in the list, and then select Add.

Tip: If you can't find the command you want on the Commands Not in the Ribbon list, try setting Choose commands from to All commands.

Remove a command from the Quick Access Toolbar

  1. Right-click the command you want to remove from the Quick Access Toolbar.

  2. Select Remove from Quick Access Toolbar on the shortcut menu.

Change the order of the commands on the Quick Access Toolbar

  1. Right-click the Quick Access Toolbar then select Customize Quick Access Toolbar on the shortcut menu.

  2. Under Customize Quick Access Toolbar, select the command you want to move.

  3. Select the Move Up or Move Down arrow.

Customize the Quick Access Toolbar by using the Options command

You can add, remove, and change the order of the commands on the Quick Access Toolbar by using the Options command.

  1. Select File > Options > Quick Access Toolbar.

  2. Use the Add and Remove buttons to move items between the Customize the657 Access Toolbar list and the Choose command from list..

    Notes: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands. To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form: 

    • Address [Document Location] 

    • Formatting [Paste Formatting]

    • Formulas [Paste Formulas]

    • Values [Paste Values]

    Reset the Quick Access Toolbar to the default settings

  1. Open the Quick Access Toolbar short-cut menu, and then select Customize Quick Access Toolbar.

  2. In the Customize the Quick Access Toolbar window, select Reset > Reset only Quick Access Toolbar Reset and Import Export fields in QAT File Options

Export a customized Quick Access Toolbar

You can export your ribbon and Quick Access Toolbar customizations into a file that can be imported and used by a coworker or on another computer.

  1. Select File > Options > Quick Access Toolbar.

  2. Select Import/Export > Export all customizations.

For more information about how to customize the ribbon, see Customize the ribbon in Office.

Import a customized Quick Access Toolbar

You can import customization files to replace the current layout of the ribbon and Quick Access Toolbar. By being able to import the customization, you can keep Microsoft Office programs looking the same as your coworkers or from computer to computer.

Important: When you import a ribbon customization file, you lose all prior ribbon and Quick Access Toolbar customizations. If you think that you might want to revert to the customization you currently have, you should export them before importing any new customizations.

  1. Select File Options > Quick Access Toolbar.

  2. Select Import/Export > Import customization file.

For more information about how to customize the ribbon, see Customize the ribbon in Office.

When custom groups show a green or blue ball on the Quick Access Toolbar

Icons represent custom groups of commands on the Quick Access Toolbar when an icon is chosen. If a custom group on the Quick Access Toolbar displays a green or blue ball for an icon, it means that an icon has not been selected for that custom group.   You can add an icon for a custom group after the group has already been created and displays on the Quick Access Toolbar.

  1. In the Quick Access Toolbar drop-down, select More Commands.

  2. In the left navigation bar, select Customize Ribbon.

  3. In the Customize the Ribbon column on the right, select the custom group.

  4. Select Rename.

  5. Select an icon.

  6. Select OK > OK.

Note: To create a custom group of commands, refer to Customize the ribbon in Office. 

 

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.