The Quick Access Toolbar In Excel

The quick access toolbar in Excel provides a selection of the more commonly used commands in one convenient place – the top left corner of the workspace (above the file tab).

The Quick Access Toolbar In Excel 2010

The beauty of the quick access toolbar is that it’s available whichever tab you’re using. By default, the toolbar contains the following commands, but you can add more:

  • Save
  • Undo
  • Redo

Add Commands To The Quick Access Toolbar

There are two different ways to add commands to the quick access toolbar. The first way involves using the Customize Quick Access Toolbar button, to the right of the toolbar. When we click that, we get this menu:

Customize The Quick Access Toolbar In Excel

In this panel, we can see that the commands that already appear in the toolbar have a tick next to them. To add others, just select them one at a time by clicking on them. To remove one, click on it again to remove the tick. This menu displays only a small selection of the commands that are available for display on the quick access toolbar, though.

Any command you see on the ribbon can be added to the quick access toolbar, which brings us to the second method. Find the command on the ribbon that you want to add, right click on it and select Add to Quick Access Toolbar.

Add To Quick Access Toolbar
For example, many people find that they use the Merge & Center command all the time and it makes sense to have quick and easy access to it from any tab. Just add it to the quick access toolbar!

To remove it again, you can right click on the command in the toolbar and select Remove from Quick Access Toolbar.

Remove From Quick Access Toolbar

There are other controls you can use on the quick access toolbar. For example, if you click on the Customize Quick Access Toolbar button (see above), you can choose to display it below the ribbon. But why on earth would you want to do that?? Another example of Microsoft providing a “feature” that has no benefit whatsoever, but hey we digress.