How to Show Quick Access Toolbar in Excel (5 Easy Ways)

If you are working with Excel and find your Quick Access Toolbar is not showing then this article will be helpful for you. In this article, I will explain how to show Quick Access Toolbar in Excel in 5 easy and effective ways.


Download Practice Workbook


What Is Quick Access Toolbar?

The Quick Access Toolbar is a small customizable toolbar that is located at the top of the application window. Mainly it contains a set of commands that are used frequently. Independent of the ribbon tab that is now open, these commands can be accessed from practically anywhere in the application.

The Quick Access Toolbar contains a drop-down menu where you will find a set of default commands. You can add or hide a command from there. It also has an option to add your own command.


5 Easy Ways to Show Quick Access Toolbar in Excel

Here, in the following image, you can see that the Quick Access Toolbar is not showing in the excel workbook. I will explain how to show Quick Access Toolbar in Excel in 5 easy methods.

5 Easy Ways to Show Quick Access Toolbar in Excel


1. Using Any Tab from Ribbon to Show Quick Access Toolbar in Excel

In this first method, I will show you how you can show Quick Access Toolbar in Excel by using any tab from the ribbon.

Let’s see the steps.

Steps:

  • Firstly, Right-click on any Tab from the Ribbon.
  • Secondly, select Show Quick Access Toolbar.

Using Any Tab from Ribbon to Show Quick Access Toolbar in Excel

Now, you will see the Quick Access Toolbar is showing.

Using Any Tab from Ribbon to Show Quick Access Toolbar in Excel

Read More: [Fixed!] Quick Access Toolbar in Excel Missing


2. Use of Any Command to Show Quick Access Toolbar in Excel

Here, I will explain how to show Quick Access Toolbar in Excel by the use of any command. Let’s see the steps.

Steps:

  • Firstly, Right-click on any command.
  • Secondly, select Show Quick Access Toolbar.

Now, you will see the Quick Access Toolbar is showing in your Excel workbook.

Use of Any Command to Show Quick Access Toolbar in Excel


3. Employing Ribbon Display Options

In this method, I will Employ the Ribbon Display Options to show Quick Access Toolbar in Excel. Let’s see the steps.

Steps:

  • Firstly, select the marked button in the lower right corner of the Ribbon. This button is for the Ribbon Display Options.

Here, a drop-down menu will appear.

  • Secondly, select Show Quick Access Toolbar from the drop-down option.

Employing the Ribbon Display Options

Now, you will see the Quick Access Toolbar is showing in Excel.

Read More: How to Add a Macro to Your Quick Access Toolbar in Excel


4. Applying Excel Options to Show Quick Access Toolbar in Excel

In this method, I will show you how to show Quick Access Toolbar in Excel by applying Excel Options.

Let’s see the steps.

Steps:

  • Firstly, go to the File tab.

  • Secondly, select Options.

Applying Excel Options to Show Quick Access Toolbar in Excel

Here, you will see a dialog box named Excel Options will appear.

  • Firstly, select the Quick Access Toolbar.
  • Secondly, select Show Quick Access Toolbar.
  • Thirdly, select OK.

Applying Excel Options to Show Quick Access Toolbar in Excel

Now, you will see the Quick Access Toolbar is showing in Excel.


5. Using Keyboard Shortcut to Show Quick Access Toolbar in Excel

In this method, I will show you how you can use the keyboard shortcut to show Quick Access Toolbar.

Let’s see the steps.

Steps:

  • Firstly, press ALT+Z on your keyboard.

Now, you will see ZR will appear on the button for Ribbon Display Options. This means you have to press R now to open the drop-down menu for Ribbon Display Options.

Using Keyboard Shortcut to Show Quick Access Toolbar in Excel

  • Secondly, press R on your keyboard.

Here, you will see a drop-down menu appear.

  • Thirdly, press S to select Show Quick Access Toolbar.

Finally, you will see the Quick Access Toolbar is showing.

Using Keyboard Shortcut to Show Quick Access Toolbar in Excel

Read More: How to Remove Quick Access Toolbar in Excel (3 Easy Ways)


Customizing Quick Access Toolbar in Excel

In this section, I will explain how to customize Quick Access Toolbar in Excel. Let’s see the steps.

Steps:

To begin with, I will show you how you can add commands to your Quick Access Toolbar.

  • Firstly, select the drop-down option in your Quick Access Toolbar.

Now, a drop-down menu will appear.

  • Secondly, select the command you want in your Quick Access Toolbar. Here, I selected the Print Preview and Print command from the drop-down menu. You can select more than one command also.

How to Customize Quick Access Toolbar in Excel

Here, you can see the Print Preview and Print command is added to the Quick Access Toolbar.

Now, I will show you how you can add commands to your Quick Access Toolbar that are not showing in the drop-down menu.

  • Firstly, select the drop-down option in your Quick Access Toolbar.

Here, a drop-down menu will appear.

  • Secondly, select More Commands.

How to Customize Quick Access Toolbar in Excel

Now, you will see a dialog box will appear.

  • Firstly, select the command you want in your Quick Access Toolbar. Here, I selected the Save As command.
  • Secondly, select ADD.

  • Finally, select OK.

How to Customize Quick Access Toolbar in Excel

Here, you can see the Save As command is now added to the Quick Access Toolbar.

At this point, I will show you how you can change the position of your Quick Access Toolbar.

  • Firstly, select the drop-down option in your Quick Access Toolbar.

Now, a drop-down menu will appear.

  • Secondly, select Show Below the Ribbon from the drop-down menu.

How to Customize Quick Access Toolbar in Excel

Here, you can see the Quick Access Toolbar is showing below the Ribbon.


How to Hide Quick Access Toolbar in Excel

In this part, I will explain how to hide Quick Access Toolbar in Excel. Let’s see the steps.

Steps:

  • Firstly, select the drop-down option in your Quick Access Toolbar.

Now, a drop-down menu will appear.

  • Secondly, select Hide Quick Access Toolbar from the drop-down menu.

How to Hide Quick Access Toolbar in Excel

Now, you can see the Quick Access Toolbar is not showing anymore.


Things to Remember

  • There is no maximum limit for adding commands to your Quick Access Toolbar. But, depending on the size of your screen you may not be able to see all of them at the same time.

Conclusion

To conclude, in this article I tried to cover how to show Quick Access Toolbar in Excel. Here, I explained 5 different ways of doing it.  I hope this was helpful for you. To get more articles like this visit ExcelDemy. If you have any questions please, let me know in the comment section below.


Related Articles

Mashhura Jahan

Mashhura Jahan

Hey! Welcome to my profile. Currently, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo