Mashhura Jahan
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.
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.
Now, you will see the Quick Access Toolbar is showing.
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.
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.
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.
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.
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.
- 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.
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.
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.
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.
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.
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.
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.
