How to customize the Quick Access Toolbar

The Quick Access Toolbar is a customizable toolbar independent of the tab on the ribbon that is currently displayed in Microsoft Excel.

It is usually located in the title bar of the Excel window, but it can also be configured to display below the ribbon.

It will look something like this on a new installation:

Quick Access Toolbar

You can see often used commands Save, Undo and Redo already on the toolbar.

If you want to remove those, or more likely, add some commands you often use on the toolbar, you can do that by going to File, than Options, and then Quick Access Toolbar.

Alternatively, you can also select additional commands, or go to More Commands option, in the toolbar menu:

Quick Access Toolbar - More Commands

You have multiple “sources” for your commands, and we will here go with All Commands:

Quick Access Toolbar - Customize the Quick Access Toolbar

You can Add and Remove commands with the help of the Add and Remove buttons, respectively.

You can rearrange commands with the help of the Move Up and Move Down buttons.

Quick Access Toolbar - Customize the Quick Access Toolbar, Add, Remove, Rearrange

Here, I’m adding Select Visible Cells command – I like to have that command at hand because I often filter data.

I’m also adding Refresh All and Edit Links to Files commands – I like to have those commands at hand because I’m often connecting my files to databases and other workbooks.

Once expanded, the Quick Access Toolbar looks like this:

Quick Access Toolbar expanded

Notice that the Redo command is grayed out – there is nothing to Redo in this worksheet.

However, all other commands are available, as this workbook can be saved, changes can be undone, I can select only visible cells, refresh the data I’m connecting to or edit link to the file I’m linking to.

Leave a Reply

Your email address will not be published. Required fields are marked *