This tutorial provides a comprehensive guide to customizing the Quick Access Toolbar (QAT) in Excel 2010, 2013, 2016, 2019, 2021, and 365. Learn how to easily access frequently used commands with just a click.

Understanding the Quick Access Toolbar

The QAT is a customizable toolbar at the top of the Excel window, providing quick access to frequently used commands regardless of the active ribbon tab. It offers a dropdown menu with default commands and allows adding custom commands. While there's no limit to the number of commands, screen size may limit visibility.

Locating the Quick Access Toolbar

The QAT is typically located above the ribbon in the upper-left corner of the Excel window. Its position can be changed to below the ribbon.

Customizing the Quick Access Toolbar

The QAT initially contains "Save," "Undo," and "Redo." This section details how to personalize it:

Customization Options:

• Adding Commands: Add commands from the predefined list, directly from the ribbon (right-click, "Add to Quick Access Toolbar"), or from commands not found on the ribbon ("Commands Not in the Ribbon" option).
• Removing Commands: Right-click a command and select "Remove from Quick Access Toolbar," or use the "Remove" button in the customization window.
• Rearranging Commands: Use the "Move Up" and "Move Down" arrows in the customization window to reorder commands.
• Grouping Commands: While true grouping isn't possible, separators can be added to visually separate command sets.
• Adding Macros: Add custom macros for quick access.
• Workbook-Specific Customization: Customize the QAT for a specific workbook; these customizations are added to, not replacing, the global settings.
• Moving the QAT: Move the QAT between above and below the ribbon.
• Resetting the QAT: Restore the QAT to its default settings.
• Exporting and Importing QAT Settings: Save and load QAT customizations (including ribbon customizations) from a file. Note that importing replaces existing settings.

Accessing the Customization Window:

There are three ways to access the "Customize Quick Access Toolbar" window:

1. File > Options > Quick Access Toolbar
2. Right-click the ribbon and select "Customize Quick Access Toolbar…"
3. Click the QAT's down arrow and select "More Commands"

Detailed Steps (with images):

The tutorial provides detailed, illustrated steps for each customization option, including adding commands from various sources, removing commands, rearranging commands, adding separators, adding macros, customizing for specific workbooks, moving the QAT, resetting the QAT, and exporting/importing QAT settings. (Images are omitted here due to the limitations of this response format, but they are present in the original input.)

Conclusion:

Mastering the QAT enhances Excel efficiency. This guide empowers users to personalize their Excel experience for optimal workflow.

The above is the detailed content of Quick Access Toolbar in Excel: how to customize, move and reset. For more information, please follow other related articles on the PHP Chinese website!