We frequently encounter a frustrating problem in Microsoft Excel when the Quick Access Toolbar is missing. This problem has been reported by several Excel users. If you are dealing with a similar problem, this article will be helpful. In this article, we are going to learn 3 simple solutions to fix the issue of the Quick Access Toolbar in Excel Missing.
Download Practice Workbook
What Is Quick Access Toolbar?
Quick Access Toolbar (QAT) is quite a handy feature of Excel. Everything you can see on the Ribbon, you can add to the Quick Access Toolbar. It is located on the top left side of your worksheet as marked in the following image.
3 Solutions If Quick Access Toolbar Goes Missing in Excel
In this portion of the article, we will discuss 3 suitable solutions if we face the issue of the Quick Access Toolbar in Excel Missing. In the following dataset, we have the Monthly Sales Data of a company.
If in our Excel file the Quick Access Toolbar is missing, then it will look like the image given below.
Not to mention that we have used Microsoft Excel 365 version for this article, you can use any other version according to your convenience.
Solution 01: Using Title Bar
Using the Title Bar is one of the easiest solutions to fix the issue of the Quick Access Toolbar Is Missing in Excel. Let’s follow the steps mentioned below.
Steps:
- Firstly, right-click on the indicated region of the following image.
As a result, several options will be available to you as shown below.
- Following that, choose the Show Quick Access Toolbar option.
Consequently, you will see that the Quick Access Toolbar has reappeared as shown in the picture demonstrated below.
Read More: How to Remove Quick Access Toolbar in Excel (3 Easy Ways)
Solution 02: Utilizing Show Ribbon Option
Another efficient solution to reappear the Quick Access Toolbar is to utilize the Show Ribbon option. You can do this by following the steps discussed below.
Steps:
- Firstly, navigate to the upper right corner of the Ribbon tab and you will find a drop-down menu as marked in the following image. Click on that.
Consequently, the Show Ribbon drop-down will be open on your worksheet.
- After that, select the Show Quick Access Toolbar option.
There you go! Now you will see that the Quick Acess Toolbar is reappeared on your worksheet as marked in the image given below.
Read More: How to Add a Macro to Your Quick Access Toolbar in Excel
Solution 03: Using Excel Options Feature
Excel Options has tons of customization options. And it has a dedicated tab only to customize the Quick Access Toolbar. Let’s follow the steps demonstrated below to make the Quick Access Toolbar visible again.
Steps:
- Firstly, go to the File tab from the Ribbon.
As a result, you will see the following image on your screen.
- Following that, click on the Options tab.
Subsequently, the Excel Options dialogue box will open as shown in the picture below.
Note: You can also use the keyboard shortcut ALT + F + T to directly open the Excel Options dialogue box from your worksheet.
- Now, click on the Quick Access Toolbar tab.
- Then, check the box of the Show Quick Access Toolbar.
- Finally, click OK.
Consequently, you will see that the Quick Access Toolbar is added to your worksheet as shown in the following image.
Conclusion
Finally, we have to the end of the article. I sincerely hope that this article was able to guide you to fix the issue of the Quick Access Toolbar in Excel Missing. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!