Toolbar On Excel

The Toolbar on Excel is an area in the Excel window’s upper right corner above the ribbon where we can add different features for quick access. Also known as the Quick Access Toolbar, we can choose the frequently used tools to be displayed.

For example, the image depicts the values, and we will arrange the values in descending order using the Toolbar in Excel.

The steps to use the Toolbar are as follows:

Click the “Customize Quick Access Toolbar” option drop-down on the Title Bar, and select the “Sort Descending” option, as shown below.
The “Sort Largest to Smallest” button appears on the top of the Excel Ribbon.
Now, select cell range A2:A6, and click the “Sort Largest to Smallest” button, as shown below.

We get the output, i.e., the values sorted in descending order, large to small values, as shown below.

What Is Quick Access Toolbar in Excel?

The Quick Access Toolbar in Excel displays the frequently used features like save, undo, redo, etc., for quick usage, just with a click, as easy as their respective shortcuts.
We can insert the toolbar, as per our convenience, on the top or bottom of the Excel ribbon.
There are some default options already available on the Quick Access Toolbar, and we can select/deselect the same. However, if we require other options, we can customize using the add or remove options in the Excel Options window.
We can also reset it to default settings to undo all the toolbar customizations.
If we want to use our personal customized or saved toolbar features from one computer to another, we must use the “Import/Export” option in the Excel Options window.

We can use the Toolbar in Excel as follows:

We can shift the toolbar’s location to the top or bottom of the ribbon, hide it, or add extra features or frequently used commands.
We can even add and remove commands. Frequent commands like “Save,” “Open,” “Redo,” “New,” “Undo,” & “Email” are easily added to the toolbar.
We can select the commands not listed in the toolbar from the three categories, including “Popular Commands,” “All Commands,” and “Commands Not Listed” on the ribbon.

We will consider specific examples for the following Quick Access Excel Toolbar options,

Adding Features to the Toolbar.
Deleting Features from the Toolbar.
Moving the Toolbar on the Ribbon.
Modifying the Sequence of Commands and Resetting to Default Settings.
Customize Excel Toolbar.
Exporting and Importing of Quick Access Toolbar.

We can add features to the toolbar is done in three methods, namely:

Adding commands located on the ribbon.
Adding features through the “More Commands” option.
Adding the elements presented on the different tabs directly to the toolbar.

Method #1 – Adding commands located on the ribbon

Click the “Customize Quick Access Toolbar” option drop-down, and select the required options, as shown below.

Toolbar on Excel - Adding commands located on ribbon

Method #2 – Adding features through the “More Commands” option

Click the “Customize Quick Access Toolbar” option drop-down, and select the “More Commands…” option, as shown below.

Adding features through more commands option - 1

The “Excel Options” window opens.

On the left side, choose the “Quick Access Toolbar” option.
Then, on the right side, select the required commands from the “Choose Commands from:” category, and click the “Add” option to add the feature to the toolbar. Added features will be seen under the “Customize Quick Access Toolbar:” category.
Finally, click “OK”, and the features will get added to the Excel ribbon for easy access.

Adding features through more commands option - 2

First, right-click on any feature we want on the Excel ribbon, and choose the “Add to Quick Access Toolbar” option.

As shown in the image below, the center and right alignment commands are added to the toolbar with this option.

Toolbar on Excel - Adding the elements presented on different tabs directly to the toolbar

The steps to deleting features from the Toolbar are,

Step 1: Click the “Customize Quick Access Toolbar” option drop-down, and select the “More Commands…” option, as shown below.

Toolbar on Excel - Deleting features from the toolbar - Step 1

Step 2: The “Excel Options” window opens.
- On the left side, choose the “Quick Access Toolbar” option.
- Then, on the right side, select the required commands from the “Choose Commands from:” category, and click the “Remove” option to delete the feature from the toolbar. Added features will be removed from the “Customize Quick Access Toolbar:” category.
- Finally, click “OK”, and the features will be deleted from the excel ribbon.

Deleting features from the toolbar - Step 2

Click the “Customize Quick Access Toolbar” option drop-down, and select the “Show below the Ribbon” option, as shown below.

Toolbar on Excel - Moving the toolbar on the ribbon - Step 1

The Toolbar is moved from above the Ribbon to below the Ribbon, as shown in the below image.

Moving the toolbar on the ribbon - Step 2

#4 – Modifying the Sequence of Commands and Resetting to Default Settings

The steps to modify the sequence of commands and reset to default settings are,

Step 1: Click the “Customize Quick Access Toolbar” option drop-down, and select the “More Commands…” option, as shown below.

Toolbar on Excel - Modifying the Sequence of Commands and Resetting to Default Settings - Step 1

Step 2: The “Excel Options” window opens.
- On the left side, choose the “Quick Access Toolbar” option.
- Then, on the right side, click the “Customize Quick Access Toolbar:” category drop-down, and select the “For all documents (default)” option.
- Finally, click “OK” to get the default settings.

Modifying the Sequence of Commands and Resetting to Default Settings - Step 2

The steps to customize the Excel toolbar are,

Step 1: Click the “Customize Quick Access Toolbar” option drop-down, and select the “More Commands…” option, as shown below.

Step 2: The “Excel Options” window opens.
- On the left side, choose the “Quick Access Toolbar” option.
- Then, on the right side, under the “Customize the Quick Access Toolbar:” category, we can “add”, “remove”, “reset”, “change the location of the toolbar”, “modify”, and “alter the features”.
- Finally, click “OK” for the features to get added to the excel ribbon for easy access.

The steps to export and import of Quick Access Toolbar are,

Step 1: Click the “Customize Quick Access Toolbar” option drop-down, and select the “More Commands…” option, as shown below.

Excel Toolbar - Exporting an Importing of Quick Access Toolbar - Step 1

Step 2: The “Excel Options” window opens.
- On the left side, choose the “Quick Access Toolbar” option.
- On the right side below, click the “Import/Export” button drop-down. We will get options to import or export the Quick Access Toolbar customization done on our computer and to use it on another computer, and vice versa.
- Finally, click “OK”, as shown below.

Exporting an Importing of Quick Access Toolbar - Step 2

Important Things To Note

We cannot change the size of the toolbar buttons, but we can change the screen’s resolution.
The commands like indent and spacing are not added to the toolbar.
We can add as many Quick Access Tools, but only some commands are visible as per the screen size.

Frequently Asked Questions (FAQs)

1. What is the purpose of Toolbar on Excel?

The Toolbar on Excel is where we add some commands or tools associated with Excel for quick access. By default, it is present above the Excel Ribbon with different tools.

2. How to use Quick Access Toolbar on Excel?

Let us understand the usage of the Quick Access Toolbar on Excel with an example.

For example, the image depicts the values, and we will arrange the values in ascending order using the Toolbar in Excel.

Excel Toolbar - FAQ 2

The steps to arrange the values are as follows:

• Step 1: Click the “Customize Quick Access Toolbar” option drop-down on the Title Bar, and select the “Sort Ascending” option, as shown below.

FAQ 2 - Step 1

• Step 2: The “Sort Smallest to Largest” button appears on the top of the Excel Ribbon.

Now, select cell range A2:A6, and click the “Sort Smallest to Largest” button, as shown below.

FAQ 2 - Step 2a

We get the output, i.e., the values sorted in ascending order, small to large values, as shown below.

FAQ 2 - Step 2b

3. Where to find Toolbar on Excel?

One can activate the Toolbar on Excel using the following steps:
1) Select the cells containing data.
2) Click the “Customize Quick Access Toolbar” arrow button above the Excel Ribbon.
3) The “Customize Quick Access Toolbar” opens with a list of commands.

Excel Toolbar - FAQ 3

Download Template

This article must help understand the formulas and examples of the Toolbar on Excel. You can download the template here to use it instantly.

Toolbar On Excel Download

Table of contents

Key Takeaways

Method #1 – Adding commands located on the ribbon

Method #2 – Adding features through the “More Commands” option

#4 – Modifying the Sequence of Commands and Resetting to Default Settings