How to customize quick access toolbar in Excel?

Microsoft Office 2007 launched the ribbon system toolbar for the first time. Like 0ther Microsft products MS Excel also has the Quick Access Toolbar in the ribbon. It plays an important role for the users as it saves time to find frequently used tools. Today, in this content, We will discuss what is Quick Access Toolbar, how to customize the Quick Access Toolbar in excel, and why the Quick Access Toolbar is so important to us.

What is the Quick Access Toolbar?

The Quick Access Toolbar is a narrow bar located above or below the ribbon that can hold the set of commands you use most. This set of commands can be accessed from any part of the application, independent of the ribbon tab that is opened already.

It can be customized easily and has a drop-down menu containing a set of commands that may be displayed or hidden on the screen. As it is customizable, the user can add and remove his desired commands on it. there are no limits f adding a command but the display depends upon the size of the screen.

where is Quick Access Toolbar in Excel?

By default, the location of the Quick Access Toolbar is the upper left corner of Microsoft Excel. It can be also found just below the ribbon in MS Excel. There are no other places for the Quick Access Toolbar in Excel.

How to change the location of the Quick Access Toolbar?

You can change the location of the Quick Access Toolbar between these places. But how?

Take your mouse pointer to the Quick Access Toolbar, there is a small triangle, click on it. A drop-down menu will appear. If your Quick Access Toolbar is located below the ribbon it will show Show above the ribbon. Click on it.

If you already have your Quick Access Toolbar located above the ribbon you can move it to below the ribbon in the same way.

Features of Quick Access Toolbar

Quick Access Toolbar in MS Excel has some exciting features that a user can enjoy.

• The Quick Access Toolbar is customizable.
• It can be located between two places: below and above the ribbon.
• As many commands can be added in the Quick Access Toolbar.
• Order of placing commands can be changed.
• Macros can be included in the Quick Access Toolbar.
• Only command icons are visible but command labels are not visible.
• You cannot change the size of this toolbar without changing the screen resolution.
• The Quick Access Toolbar cannot be shown in multiple lines, it is a single-line toolbar.
• Export and Import custom Quick Access Toolbar.

Read More: What is ribbon in Excel? MS Excel ribbon explained.

How to customize the Quick Access Toolbar in Excel?

You can customize the Quick Access Toolbar in many ways. Among them, the following are the most convenient.

• From the Excel Options
• From Quick Access Toolbar

From the Excel Options

Steps to customize quick access toolbar:

• Go to the File tab, and Click Options.
• Select the Quick Access Toolbar from Excel Options.
• On the right-hand side you will get Customize the Quick Access Toolbar.

From here you add or remove commands with the help of Add and Remove buttons. You can change the location of this toolbar. You can also reset, export, and import.

From the Quick Access Toolbar

Steps to customize quick access toolbar:

• Right-click over any command icon of the Quick Access Toolbar and select Customize Access Toolbar to get customize options.

• Take your mouse pointer to the Quick Access Toolbar, there is a small triangle, click on it. A drop-down menu will appear. Select More Commands to customize the Quick Access Toolbar.

How to add a group to the Quick Access Toolbar

A group is a set of commands and a tab is a set of groups in the ribbon system toolbar. You can add a group to the Quick Access Toolbar. Right-click over any groups and select Add Group to Quick Access Toolbar.

How to add a ribbon button to the Quick Access Toolbar

A command button from the ribbon also can be added to the Quick Access Toolbar. Right-click on any command button of a ribbon group and select Add to Quick Access Toolbar. The command button will be added to the Quick Access Toolbar.

How to remove a command Button from Quick Access Toolbar

Right-click over a command button of the Quick Access Toolbar and select Remove from Quick Access Toolbar to remove it from the toolbar.

How to rearrange the command button on Quick Access Toolbar

You move the sequence of command buttons on the Quick Access toolbar. That is you can move the places of command buttons among each other.

• Open the Customize the Quick Access Toolbar Window.
• Under the Customize Quick Access Toolbar on the right hand select the command that you want to move and click the Move Up or Move down arrow.

How to add Separator to Quick Access Toolbar

You can add separate and make groups of commands together in the Quick Access Toolbar like the above photos. Want to know how to do that?

• Open the Customize the Quick Access Toolbar Window.
• Select Separator and add to the toolbar.
• Using Move Up or Move down arrow place the separator in the place where you want to be placed.

Customize the Quick Access Toolbar for the current workbook only.

You can customize the Quick Access Toolbar for the entire Excel and also for the current workbook. By default, it is set for all workbooks. But if you want to change it to the Current workbook only follow the below instructions:

• Open the Customize the Quick Access Toolbar Window.
• Select the dropdown menu on the right-hand side and select your workbook name to change.

Adding Macros to Quick Access Toolbar

You can also add Macros if you have Macros to the Quick Access Toolbar in the same way.

Export and Import Custom Quick Access Toolbar

You can save your custom Quick Access Toolbar. You can also import that file later. You can also export a customized toolbar to your colleague.

Export custom Quick Access Toolbar

• Open the Customize the Quick Access Toolbar Window.
• Bottom of the Excel options you may find Export all customizations.

Import custom Quick Access Toolbar

• Open the Customize the Quick Access Toolbar Window.
• Bottom of the Excel options you may find the Import Customization file.
• You can browse and import previously exported files.

But there is something to know:

The file that is exported or saved includes a ribbon and Quick Access Toolbar. There is no option to export/import Quick Access Toolbar only.

Why do you need a Quick Access Toolbar?

Did you ever ask yourself why you need the Quick Access Toolbar? Why it is too important for anyone? If not we can discuss it here to give you a topic for brainstorming.

The Quick Access Toolbar allows a user to get all frequently used commands in a row. Sometimes you could not find your required command when needed. If you add those types of commands in Quick Access Toolbar in the future you can find them more easily.

If you think your toolbar and ribbon setup is more convenient you can export and share it with your colleagues.

Dear learners, I hope, I have described the quick access toolbar in Excel in a good manner and this content is helpful to you. If you have any queries I like to invite you to add a comment below. I will try my best to reply to your question. Thanks.