How To Customize
The Quick Access Toolbar in Excel

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

The Quick Access Toolbar is easy to overlook.

But by customizing it to your liking, you can access some of your most often-used commands faster than ever.

If you use the same buttons in the Ribbon on a regular basis, the Quick Access Toolbar can save you a lot of time!

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

What is the Quick Access Toolbar?

The Quick Access Toolbar is located above the Ribbon:

quick-access-toolbar

By default, it contains SaveUndo, and Redo buttons.

It’s not very exciting yet, but we’ll make it much more useful in a moment.

Kasper Langmann, Co-founder of Spreadsheeto

Customizing the
Quick Access Toolbar

Many people don’t realize that you can customize the Quick Access Toolbar with more than just the basic buttons.

In fact, you can add almost any command you want.

That even includes commands that aren’t in the Ribbon.

Kasper Langmann, Co-founder of Spreadsheeto

Take a look at all these buttons:

customized-toolbar

Adding your own is easy!

Click the downward-facing arrow at the end of the Quick Access Toolbar to get started.

customize-toolbar

From there, you’ll see a list of commonly used options that you can add to the toolbar.

choose-toolbar-options

Click on any of the commands to add that particular command to the toolbar.

(Here, we’ve clicked the Spelling option).

spelling-toolbar

That’s all there is to it!

You can add tons of new buttons for the things you use most often.

If you don’t see the function you want in the list, however, there are tons more hidden away in a menu.

Click More Commands… at the bottom of the list:

customize-toolbar-more-commands

Now you’ll see a new menu that gives you hundreds of options.

When you first open the menu, you’ll be seeing popular commands.

customize-popular-commands

But you can click the dropdown arrow to select Commands Not in the RibbonAll CommandsMacros, or select from a number of smaller groups.

Each one will result in a different list of commands you can add to the Quick Access Toolbar.

To add a command, find it in the list, then select it and click the Add >> button.

add-command-toolbar

You’ll now see it displayed in the right-hand list, and when you click OK, it will display in the Quick Access Toolbar.

Want to remove a button from the toolbar? Select it in the right-hand list and click the << Remove button.

To reorder the items, click one and use the up and down arrows to the right of the list to move it up (to the left) or down (to the right).

up-down-toolbar

With these simple options, you can fully customize the Quick Access Toolbar to contain all the commands you use most often.

Open up a blank Excel document and try customizing your own Quick Access Toolbar!

Kasper Langmann, Co-founder of Spreadsheeto

Moving the Quick Access Toolbar

The Quick Access Toolbar is great at the top of the window, but if you find yourself using it constantly, you may want it below the Ribbon.

It’s easy to do that. Click the downward-facing arrow at the end of the toolbar and select Show Below the Ribbon.

toolbar-below

Now the Quick Access Toolbar will be displayed below the Ribbon where you can click your commands even faster.

toolbar-below-ribbon

Save time on
commonly used commands

The Quick Access Toolbar does exactly what it sounds like: gives you quick access to the commands you use often.

By customizing it with the commands you use most, you’ll be able to save time each time you run those commands.