Adding commands to the Quick Access Toolbar

Excel 365 2016 2013 2010
Suppose you'd like to add a couple more commands to the Quick Access toolbar. Perhaps you miss the menu in earlier versions of Excel that let you quickly switch between open Excel windows. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.

To add command to the Quick Access toolbar, follow these steps:

   1.    In the right of the Quick Access toolbar, click the tiny arrow button to open the drop-down menu:

By checking the commands on this menu, you can add their icons to the Quick Access toolbar. Trouble is, the commands shows that the two commands you want to add aren't even on the menu, so:

Quick Access in Excel 2007

   2.    Near the bottom of the menu, click More Commands.

The Excel Options dialog box opens, showing the Customize... options. The list box on the right shows the commands that are currently shown on the Quick Access toolbar. The box on the left contains commands that you can add to the Quick Access toolbar.

Excel 2007 Options

The Choose commands from drop-down menu above the left box reads Popular Commands. Evidently, the Switch Windows and AutoSum commands aren't popular enough to make the cut, because they aren't on the list. Fortunately, you can use the Choose commands from menu to display more commands.

   3.    From the Choose commands from drop-down menu, choose All Commands.


The All Commands list is pretty lengthy, giving you an idea of just how many different commands Excel has to offer. That's why the Choose commands from menu also lets you narrow down your choices by choosing commands from specific ribbon tabs. (The major tabs are listed closer to the top, and the submenu tabs, like those for chart tools and table tools, are listed near the bottom.)

   4.    Scroll down the All Commands list to select AutoSum, and then click the Add button between the two list boxes to add the command to the box with the Quick Access toolbar commands.


You can use the Add button to add a command to the Quick Access toolbar list, or you can just double-click a command.

   5.    Scroll down to select Switch Windows, and then double-click to add the command to the Quick Access toolbar box.

Press S to jump down to the commands that begin with S. That makes it a shorter scroll to get to the Switch Windows command. Now that you've filled the list with your desired commands, it's time to arrange them to your liking.

   6.    In the Customize Quick Access toolbar list box, select a command, and then use the up and down arrow buttons on the right to arrange them in an order that works best for you.

To make it easier to find your new commands, you can add one or two separators described in the previous tip. For example, you may want to group the related Save, Undo and Redo commands together:


   7.    Click OK to close the Excel Options box and admire your newly configured Quick Access toolbar:

Quick Access Toolbar Excel 2007

For even greater time savings, you can use keyboard shortcuts to run the commands on the Quick Access toolbar. The commands are numbered from the left to the right, so you can choose them with the Alt key and the number:

Shortcut keys Quick Access Toolbar Excel 2007

Note: You can add a command to the Quick Access toolbar from the ribbon by right-clicking the button and choosing Add to Quick Access Toolbar:


Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.