30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / Quick Access Toolbar in Excel
By Puneet Gogia (Microsoft MVP)

Quick Access Toolbar in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

i
Version note
In older versions of Excel (2019 and earlier), the Quick Access Toolbar is always visible and can’t be turned off. In Microsoft 365, the 2021 visual refresh hid the toolbar by default and moved Undo and Redo to the Home tab. Microsoft has since turned it back on by default (with AutoSave, Save, Undo, and Redo), and you can show or hide it anytime by right-clicking the ribbon.

KEY POINTS

The idea of using the quick access toolbar is to have all the commands that you frequently use in one place so that you don’t need to move from tab to tab to find those commands.

  • On the quick access toolbar, you can add options that you use frequently to access them easily.
  • You can change its position from the title bar to below the ribbon.
  • It is activated by default. In Excel 2019 and earlier, you can’t hide it, but in Microsoft 365, you can hide it and show it again.

And in this tutorial, we will be exploring everything about the quick access toolbar. So, let’s get started.

What Is the Quick Access Toolbar

The Quick Access Toolbar is a thin bar that can hold buttons for the commands. By default, it is located on the left side of the title bar and is always visible, regardless of which ribbon tab is active. You can add and remove buttons from the quick access toolbar and change its position as well.

Below is the default quick access toolbar that you can see on opening the Excel application for the first time.

default-quick-access-toolbar

It is a fixed toolbar that can’t be free-floating, and commands on the Quick Access Toolbar appear as small icons without any text (except the AutoSave switch). In Microsoft 365, when the toolbar is below the ribbon, you can also show the command names (more on this in the tips below).

This tutorial is a part of our Basic Excel Skills, and if you want to sharpen your existing Excel Skills, check out these Excel Tips and Tricks.

Default Buttons on the Quick Access Toolbar

Even before you customize it and add buttons for your favorite commands, it has default buttons:

Buttons-on-Quick-Access-Toolbar
  • AutoSave: It is a switch that you can turn on to save a workbook stored on OneDrive or SharePoint in real time. That means Excel saves your changes every few seconds so that you won’t lose data.
  • Save: This button saves the active workbook, or works as “Save As” if the active workbook is not saved yet.
  • Undo: This button undoes the effect of the last action.
  • Redo: This button reverses the effect of the last undo.

What If the Quick Access Toolbar Is Not Available

The quick access toolbar is visible in the Excel window by default. But when you are using Excel in full-screen mode, it is hidden, and to display it (temporarily), you need to click on the title bar or press the Alt key.

Quick-access-toolbar-not-available

In Microsoft 365, there’s one more reason: the toolbar can be turned off. To bring it back, right-click anywhere on the ribbon and select Show Quick Access Toolbar. In the same way, you can hide it with Hide Quick Access Toolbar, from the right-click menu or from the toolbar’s own drop-down.

And if you see only a few of your buttons, the rest may be hiding behind the small arrow at the end of the toolbar (More Controls). This happens when the toolbar runs out of space on the title bar. Move it below the ribbon (tip 2 below) to see all of them.

Customizing the Quick Access Toolbar

One of the most significant advantages of the quick access toolbar is that you can customize it in so many ways. On the right side of the QAT, you have a small drop-down, and when you click on this drop-down, you’ll find options to customize it.

customizing-the-quick-access-toolbar

In this drop-down, you have a list of some of the basic commands that you can add. You simply need to select the option that you want to add, and it will add a new button to the QAT.

basic-commands

Below that list, you have a button to add more commands (we will discuss it in a few seconds), and in the end, there’s a button to show the quick access toolbar below the ribbon.

button-to-add-more-commands

Add More Commands to the Quick Access Toolbar

Once you click on More Commands, it takes you to the Excel Options, where you have a whole bunch of options to customize the quick access toolbar. You can also get here from File ➜ Options ➜ Quick Access Toolbar.

7-add-more-commands-to-quick-access-toolbar
  1. On the left side, you have the commands to select from.
  2. And on the right side, you have the list of the commands that are already on the quick access toolbar.

Steps to customize the quick access toolbar

  1. Open the dropdown “Choose Commands from” and select the tab from where you want to add the command.
    steps-to-customize-quick-access-toolbar
  2. After that, select the command that you want to add and click on the “Add” button. The moment you click on the Add button, you’ll get that command in the quick access toolbar commands list.
    click-on-the-add-button
  3. In the end, click OK, and you will have the new command that you have just added on the quick access toolbar.
    click-ok

I’m sure you have seen that there are a lot of options in the “Choose commands from” drop-down that you can add to the quick access toolbar.

dropdown-that-you-can-add-to-the-quick-access-toolbar

These lists hold all the commands that you have in Excel, but they are categorized under different groups.

  • Popular Commands: Here, you can find the popular commands that Excel has, and most of these are frequently used commands.
  • Commands Not in the Ribbon: It is a list of commands that are not listed in the ribbon, but you can add them to the quick access toolbar.
  • All Commands: It is a complete list of commands that Excel offers you to use.

To make it easy for you to find a command that you want to add to the quick access toolbar, you also have tab-wise commands that you can select, along with Macros (the macros in your open workbooks) and File Tab (commands like Save As and Print Preview).

The other way to add a command to the quick access toolbar is to go to that command’s button on the ribbon, right-click on it, and select “Add to Quick Access Toolbar”.

12-commands-button-and-the-ribbon

And this will add a button on the quick access toolbar for the command you have selected.

install-the-add-a-button

You can do the same with a whole group of the ribbon. Right-click on the group name (like Font or Alignment on the Home tab) and select “Add to Quick Access Toolbar”. It adds one button that opens the complete group as a drop-down.

Remove Buttons from the Quick Access Toolbar

If you want to remove an option from the quick access toolbar, just right-click on that button and select “Remove from Quick Access Toolbar“.

remove-buttons-from-the-quick-access-toolbar

The second way is to open the More Commands dialog box, select the command, and click on the Remove button.

more-commands-dialog-box

And you can also untick the commands that are listed in the drop-down menu.

untick-commands

Rearranging the Icons

From the Excel options, you can rearrange the icons that you have on the quick access toolbar. When you select a button, it activates the up and down arrows (Move Up and Move Down) on the right side of the list, and you can use these arrow buttons to rearrange the selected command’s button.

rearranging-the-icons

To keep related buttons together, add a <Separator> from the top of the Popular Commands list and move it between them with the same arrows. It puts a thin line between two sets of buttons.

Tips for Using the Quick Access Toolbar Like a PRO

Below are some of the tips that you can learn to use the quick access toolbar at its best.

Check Out: 100 Excel Tips and Tricks

1. Customize QAT for a Single Workbook

When you customize the quick access toolbar, the changes apply to the entire Excel application. But there is also an option to have different customizations for different workbooks. In the Excel Options, you can select the option from the drop-down above the list on the right.

  • For all documents (default)
  • For a workbook (it shows the workbook’s name).
option-to-have-different-customizations

This drop-down shows all the open workbooks that you can select and apply the customization to. The buttons you add this way are saved in that workbook and show up only when it’s active, after the buttons you have for all documents.

2. Move the Quick Access Toolbar to the Bottom of the Ribbon

As the quick access toolbar is on the title bar, it has less space to add more commands. But you can also move it below the ribbon, which gives it the most space to add commands.

move-the-quick-access-toolbar-to-the-bottom-of-the-ribbon

For this, you simply need to click on the drop-down that you have and select “Show Below the Ribbon”. To move it back, select “Show Above the Ribbon” from the same drop-down.

show-below-the-ribbon

You can also do this while customizing the quick access toolbar from the Excel Options. In older versions, there is a small box (Show Quick Access Toolbar below the Ribbon) that you need to tick. In Microsoft 365, use the Toolbar Position drop-down instead.

customizing-the-quick-access-toolbar-from-the-excel-options

3. Undo and Redo Drop-Down

Usually, for undo and redo, you need to press the shortcut key (Ctrl + Z and Ctrl + Y) again and again, but with the buttons that you have on the quick access toolbar, you can undo and redo up to the last 100 activities.

Simply click on the drop-down and select the activity up to which you want to undo or redo.

undo-and-redo-drop-down

4. Spell Check Button on the Quick Access Toolbar

You can also add the spell check button (Spelling) to the toolbar, which can be handy if you want to check your worksheet for spelling mistakes.

spell-check-button-on-the-quick-access-toolbar

It’s there in the Popular Commands list.

popular-commands-list

5. Reset the Quick Access Toolbar Buttons

If you want to go back to the default settings and remove all the customization that you have made to the quick access toolbar, go to More Commands ➜ Reset ➜ Reset only Quick Access Toolbar.

reset-the-quick-access-toolbar-buttons

There’s one thing that you need to take care of: once you reset the settings for the quick access toolbar, you cannot restore them. So, if you might want them back, export them first (tip 8 below).

6. Add Quick Print to the QAT

If you do a lot of printing, then you can add a quick print button to the quick access toolbar. It’s like a one-click print command: it prints the active sheet to the default printer with the current settings, without opening the Print screen.

add-quick-print-to-the-qat

You can add it from the Popular Commands list.

quick-print

7. Run Macros from the QAT

You can also run macros from the quick access toolbar by adding a button and assigning a macro from the list to it. You just need to select Macros from Choose commands from, then select the macro you want to add, and in the end, click on the Add button.

run-macros-from-qat

You can also select an icon and a display name for the command with the Modify button.

command-from-the-modify-button

If you want the button to work in every workbook, save the macro in your Personal Macro Workbook. When the macro is in a normal workbook, Excel needs that workbook to run it, and it tries to open it when you click the button.

8. Import and Export Settings

You can also import and export the customization that you have done to the quick access toolbar using the Import/Export button (File ➜ Options ➜ Quick Access Toolbar).

import-and-export-settings
  1. Import Customization File: It asks you to locate the customization file to load. And when you load a customization file, it replaces all the previous settings and customizations you have on the Excel ribbon and quick access toolbar.
  2. Export All Customizations: It prompts you to enter a filename and location for the file to export.

The one problem with the import and export option is that you cannot export and import the customization for the quick access toolbar alone. The file holds the ribbon customizations too. This is also the way to copy your quick access toolbar to another computer.

9. Other Useful Buttons You Can Add to the Quick Access Toolbar

Below are some of the useful commands that you can add to the quick access toolbar:

  1. Fill Series (Add Serial Number in Excel)
  2. Strikethrough
  3. Copy
  4. Paste
  5. Visual Basic Editor
  6. Auto Filter
  7. New Note
  8. AutoFormat
  9. Double Underline
  10. Subscript
  11. Superscript

There’s no Quick Access Toolbar in Excel Online (Excel Web Version).

10. Show Command Labels on the Quick Access Toolbar

In Microsoft 365, you can show the name of each command next to its icon. First of all, move the toolbar below the ribbon (tip 2), as labels only work there. After that, click on the toolbar’s drop-down and select Show Command Labels. To go back to icons only, select Hide Command Labels.

Labels make the buttons easier to find, but they take more space, so fewer buttons fit in one row.

Quick Access Toolbar in Excel for Mac

Excel for Mac also has a quick access toolbar at the top of the window, with Save, Undo and Redo by default. But you customize it in a different place:

  1. First of all, go to Excel ➜ Preferences (Excel ➜ Settings in newer versions of macOS) and click on Ribbon & Toolbar.
  2. After that, open the Quick Access Toolbar tab at the top of the dialog box.
  3. Now, select a command from the list on the left and click on the right arrow to add it. To remove one, select it on the right and click on the left arrow.
  4. In the end, click Save. The new buttons show up at the end of the toolbar.

On a Mac, you don’t have the Alt key shortcuts for the toolbar buttons that you have on Windows (see below).

What You Can’t Do with the Quick Access Toolbar

Microsoft lists a few limits of the toolbar, and it’s good to know them before you spend time on it:

  • Bigger buttons: You can’t change the size of the buttons. The only way is to lower your screen resolution.
  • More rows: The toolbar can’t show its buttons on more than one line. Buttons that don’t fit go behind the More Controls arrow at the end.
  • List items: You can add only commands, not the items of a list, like a single cell style or one indent value.
  • Floating toolbar: You can’t drag it around the window. It’s either above or below the ribbon.

The Way I Use the Excel Quick Access Toolbar

I have all the commands that I frequently use on the quick access toolbar. I have set the Excel ribbon to show only the tab names, and the quick access toolbar is below the ribbon.

the-way-i-use-excel-quick-access-toolbar

In this way, I can save a lot of space for the worksheet view, and the quick access toolbar has a lot more area to add more command buttons.

Keyboard Shortcuts for the Quick Access Toolbar

You can also use a keyboard shortcut to use buttons on the quick access toolbar. When you press ALT, Excel shows you all the keyboard shortcuts (KeyTips) for the quick access toolbar.

quick-access-toolbar-keyboard-shortcuts

As you can see in the above snapshot, commands on the quick access toolbar are assigned numbers for shortcut keys.

Excel Keyboard Shortcuts

For example, the shortcut Alt + 1 executes the first command on the Quick Access Toolbar, and after the ninth command, the shortcuts change to 09, 08, and so on.

After the 18th command, the shortcuts change to 0A, 0B, and so on, and after Alt+0Z, Excel stops assigning shortcuts.

This also means the order of the buttons matters. Keep the commands you use most at the start of the toolbar, so they get the one-key shortcuts from Alt + 1 to Alt + 9. You can press the keys one after the other: press Alt, let it go, and then press the number.

Frequently asked questions

Where is the Quick Access Toolbar in Excel?
It sits on the left of the title bar, above the ribbon, and stays visible on every ribbon tab regardless of which tab is active. You can also move it below the ribbon for more space.
Can you hide the Quick Access Toolbar?
In current Microsoft 365, you can show or hide the Quick Access Toolbar from the ribbon display options. In older versions (2019 and earlier), it stays visible and can’t be turned off.
Why is my Quick Access Toolbar missing?
It’s usually hidden in full-screen mode or switched off in the ribbon options. Click the title bar or press Alt to show it temporarily, or re-enable it from the ribbon display menu.
How do I move the Quick Access Toolbar below the ribbon?
Click the small drop-down at the right of the toolbar and choose Show Below the Ribbon. You can also tick the same option in Excel Options while customizing it.
Does Excel Online have a Quick Access Toolbar?
No. The web version of Excel doesn’t include a Quick Access Toolbar.
How do I reset the Quick Access Toolbar?
Go to More Commands ➜ Reset ➜ Reset only Quick Access Toolbar. Note that once you reset it, the customization can’t be restored.
Can I show text labels on the Quick Access Toolbar buttons?
Yes, in Microsoft 365. Move the toolbar below the ribbon, then click its drop-down and choose Show Command Labels. Labels aren’t available when the toolbar is above the ribbon, and older versions show icons only.
How do I copy my Quick Access Toolbar to another computer?
Go to File ➜ Options ➜ Quick Access Toolbar ➜ Import/Export ➜ Export all customizations and save the file. On the other computer, use Import customization file. It replaces that computer’s ribbon and toolbar customizations.
Can I add a macro button to the Quick Access Toolbar?
Yes. In More Commands, choose Macros from Choose commands from, select the macro, click Add, and use Modify to pick an icon. Save the macro in the Personal Macro Workbook so the button works in every workbook.
Does Excel for Mac have a Quick Access Toolbar?
Yes. Customize it from Excel ➜ Preferences ➜ Ribbon & Toolbar ➜ Quick Access Toolbar. The Alt key shortcuts for its buttons are Windows only.
PG
Puneet Gogia Microsoft MVP
Puneet is a Microsoft Excel MVP with 15+ years of experience teaching Excel. He founded ExcelChamps to help people go from spreadsheet basics to advanced formulas, Power Query, and automation — through clear, practical tutorials used by over a million readers a month.
More about Puneet →
Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel