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.

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:

- 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.

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.

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.

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.

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.

- On the left side, you have the commands to select from.
- 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
- Open the dropdown “Choose Commands from” and select the tab from where you want to add the command.

- 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.

- In the end, click OK, and you will have the new command that you have just added on the quick access toolbar.

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.

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”.

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

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“.

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

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

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.

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).

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.

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.

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.

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.

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.

It’s there in the 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.

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.

You can add it from the Popular Commands list.

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.

You can also select an icon and a display name for the command with 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 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.
- 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:
- Fill Series (Add Serial Number in Excel)
- Strikethrough
- Copy
- Paste
- Visual Basic Editor
- Auto Filter
- New Note
- AutoFormat
- Double Underline
- Subscript
- 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:
- First of all, go to Excel ➜ Preferences (Excel ➜ Settings in newer versions of macOS) and click on Ribbon & Toolbar.
- After that, open the Quick Access Toolbar tab at the top of the dialog box.
- 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.
- 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.

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.

As you can see in the above snapshot, commands on the quick access toolbar are assigned numbers for shortcut keys.
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?
Can you hide the Quick Access Toolbar?
Why is my Quick Access Toolbar missing?
How do I move the Quick Access Toolbar below the ribbon?
Does Excel Online have a Quick Access Toolbar?
How do I reset the Quick Access Toolbar?
Can I show text labels on the Quick Access Toolbar buttons?
How do I copy my Quick Access Toolbar to another computer?
Can I add a macro button to the Quick Access Toolbar?
Does Excel for Mac have a Quick Access Toolbar?
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.