How to Customise the Quick Access Toolbar in Microsoft Excel to Add One-Click Commands

In Microsoft Excel, performing daily tasks like freezing panes, pasting values, applying borders, or sorting datasets often requires repeatedly switching between the Home, Data, View, and Page Layout ribbon tabs. This constant tab-hopping introduces unnecessary friction into financial analysis and data entry workflows. The Quick Access Toolbar (QAT) is a persistent, customizable strip of icons designed to keep your most frequent spreadsheet commands permanently visible with single-click accessibility. Customising your Quick Access Toolbar accelerates your productivity and enables powerful keyboard navigation shortcuts.

What Is the Quick Access Toolbar and Where Is It Located?

The Quick Access Toolbar is an independent ribbon utility located either in the title bar (above the ribbon) or docked immediately below the ribbon. Unlike standard ribbon tabs that collapse or hide contextually, the Quick Access Toolbar remains permanently visible regardless of which Excel tab is active.

Every command pinned to the Quick Access Toolbar automatically receives an Alt shortcut key. Pressing the Alt key on Windows illuminates numeric badges (1, 2, 3, etc.) over each pinned button, enabling lightning-fast keyboard execution without touching the mouse.

Method 1: Add Any Ribbon Button to the Quick Access Toolbar in One Click

The fastest way to add a command you frequently use is directly from Excel’s main interface:

1. Navigate to the ribbon tab holding your desired command (such as Data > Filter or View > Freeze Panes).
2. Right-click directly on the button or icon.
3. From the contextual menu, click Add to Quick Access Toolbar.

The command icon will immediately appear on your Quick Access Toolbar, ready for instant use across all your current and future Excel workbooks.

Method 2: Use the Customise Dialogue for Hidden Commands

Many of Excel’s most useful tools—such as Paste Values, Calculator, AutoFilter, or Document Inspector—are buried deep inside menus or completely missing from the ribbon. You can expose them via the comprehensive customisation dialogue:

1. Click the small downward-pointing arrow (Customize Quick Access Toolbar) located at the end of the toolbar.
2. From the dropdown list, select More Commands… (alternatively, navigate to File > Options > Quick Access Toolbar).
3. In the left column under Choose commands from, switch the dropdown from Popular Commands to Commands Not in the Ribbon or All Commands.
4. Scroll through the alphabetical list to find your target tool (for example, Paste Values or Select Visible Cells).
5. Select the command and click the Add >> button in the centre of the window.
6. To adjust the sequential order of your icons, select an item in the right-hand column and click the Move Up or Move Down arrows.
7. Click OK to confirm your choices.

Positioning the Toolbar Above or Below the Ribbon

Depending on your monitor aspect ratio and aesthetic preference, you can choose where the Quick Access Toolbar docks:

• Show Above the Ribbon: Puts the toolbar inside the top title bar. This conserves vertical screen space for spreadsheet rows, making it ideal for laptop displays.
• Show Below the Ribbon: Docks the toolbar immediately between the formula bar and the ribbon. This provides significantly more horizontal room for dozens of icons and displays full command labels.

To toggle positioning, click the customisation arrow at the end of the toolbar and select Show Below the Ribbon or Show Above the Ribbon.

Top Commands Every Excel User Should Pin to the Quick Access Toolbar

To dramatically accelerate your daily data processing, consider pinning these indispensable commands:

• Paste Values (Alt + 1): Strips complex formulas and formatting instantly, leaving clean raw text and numbers. (Compare this with our guide on how to convert formulas to static values in Microsoft Excel).
• Select Visible Cells (Alt + 2): Prevents copying hidden rows and columns when working with filtered datasets.
• Freeze Panes (Alt + 3): Locks top headers and leading columns without switching to the View tab.
• Filter (Alt + 4): Toggles AutoFilter arrows on and off across active data tables.
• Center Across Selection: Positions header titles across multiple cells without destructive cell merging. (See our guide on how to center text across selection in Excel without merging).

How to Backup and Export Your Quick Access Toolbar Configuration

If you transition between multiple office desktop computers or laptops, you do not have to rebuild your toolbar manually:

1. Open File > Options > Quick Access Toolbar.
2. In the bottom-right corner, click Import/Export.
3. Select Export all customizations.
4. Save the generated Excel Customizations.exportedUI file to your OneDrive or a flash drive.
5. On your secondary machine, open the same menu, click Import/Export, and select Import customization file to mirror your setup instantly.

How to Remove Unwanted Icons from the Toolbar

To declutter your Quick Access Toolbar when you no longer need a pinned tool:

1. Right-click directly on the icon you wish to dismiss.
2. Select Remove from Quick Access Toolbar.

Customising the Quick Access Toolbar in Microsoft Excel transforms your spreadsheet interface into a bespoke, high-efficiency dashboard tailored precisely to your analytical needs.