Toolbar on Excel

Toolbar or we can say it as quick access toolbar available in excel on the left topmost side of the excel window, by default it has only a few options such as save, redo and undo but we can customize the toolbar as per our choice and insert any option or button in the toolbar which will help us to reach the commands to use quickly than before.

Excel Toolbar

Excel toolbar (also called Quick Access ToolbarQuick Access ToolbarQuick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. It enables users to save important shortcuts and easily access them when needed.read more) is presented to get access to various commands to perform the operations. It is presented with an option to add or delete commands to it to access them quickly.

Toolbar on Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Toolbar on Excel (wallstreetmojo.com)

How to Use the toolbar in Excel?

Examples to Understand Quick Access Excel Toolbar

Below are the examples of the excel toolbar.

1 – Adding Features to the Toolbar

Adding features or commands to the quick access toolbars is very.  This is done in three ways including adding commands located on the ribbon, adding features through the ‘more commands’ option, and adding the features presented on the different tabs directly to the toolbar.

Method 1

We can add new, open, save, email, quick print, and redo in excel features to the toolbar. For that, select the customize quick access toolbar button and click on the command you want to add to the toolbar.

quick access toolbar in excel example method 1

In the above figure, we can see the tick-marked option present at the toolbar.

Method 2

In this, a user needs to select customize quick access toolbar in excel and select the ‘more commands’ option to add the commands.

quick access toolbar in excel example 2.1

As shown in the below figure of the customize window, the user has to select the commands and click on the add option to add the feature to the toolbar. Added features are displayed on the excel ribbonExcel RibbonThe ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs; it is available at the top of the excel sheet. This option was first introduced in the Microsoft Excel 2007.read more for accessing easily.

quick access toolbar in excel example method 2
Method 3

The user has to just right click on the feature presented on the ribbon and choose to add to a quick access toolbar.

quick access toolbar in excel example method 3.1

As shown in the figure, center, and right align commands are added to the toolbar utilizing this option.

toolbar example method 3.2

#2 – Deleting Features from the Toolbar

To remove commands,

  1. Go to more commands.


    toolbar example 2.1

  2. Select the command that wants to be removed under the customize quick access toolbar option


    toolbar example 2.2

  3. Then click on the remove button to remove the selected command.


    toolbar example 2.3

It is also done by selecting excel options by clicking on the Microsoft office button presented on the top left corner of the window and then going to the customize tab.

#3 – Moving the Toolbar on the Ribbon

If a user wants to shift the toolbar to another location, it is simply done in few steps. The toolbar can be presented below or above the ribbon.

To present the toolbar below the ribbon,

  • Click on customize the quick access toolbar button
toolbar example 3.1
  • Select the options shown below the ribbon
example 3.2
example 3.3

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

example 4

Up and down buttons present on the customize toolbar are used to present the option in the order as per user. A user can discard the changes by clicking on the reset option to get the default settings.

#5 – Customize Excel Toolbar

Customization of the excel toolbar is done to add, remove, reset, changing the location of the toolbar, modifying, and altering the order of the features at a time.

example 5.1

Using the customization option, all operations are performed in a short time on the toolbar

#6 – Exporting and Importing of Quick Access Toolbar

Exporting and importing features are presented in the latest versions of Excel to have the same settings for files used by another computer. To do this,

  • Go to File and select the Options.
example 6.1
  • Then go to a quick access toolbar.
example 6.2
  • Choose the Import/Export option to export customized settings.
example 6.3

Use the same steps to import customization.

Things to Remember

  • Quick Access Toolbar doesn’t have a feature of displaying in multiple lines
  • It is hard to enhance the size of the buttons correspond to the commands. It is done only by changing the resolution of the screen.
  • Another way to add commands to the toolbar is that right-clicking on the ribbon facilitates the option.
  • Contents of several commands such as styles, indent, and spacing are not added to the toolbar, but they are represented in the form of buttons.
  • Keyboard shortcuts are also applied to the commands presented on the toolbar. Pressing ALT key displays the shortcut numbers to utilize the commands more effectively by reducing the time.

Recommended Articles

This has been a guide to Toolbar on Excel. Here we discuss how to add, delete, modify features on the toolbar and how to Customize the Excel Toolbar. You can learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>