[Fixed!] Quick Access Toolbar in Excel Missing

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.

quick access toolbar in excel missing


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.

quick access toolbar in excel missing

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.

quick access toolbar in excel missing Using Title Bar

As a result, several options will be available to you as shown below.

quick access toolbar in excel missing Using Title Bar

Consequently, you will see that the Quick Access Toolbar has reappeared as shown in the picture demonstrated below.

quick access toolbar in excel missing Using Title Bar

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.

quick access toolbar in excel missing Utilizing Show Ribbon Option

Consequently, the Show Ribbon drop-down will be open on your worksheet.

  • After that, select the Show Quick Access Toolbar option.

quick access toolbar in excel missing Utilizing Show Ribbon 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.

quick access toolbar in excel missing Utilizing Show Ribbon Option

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.

excel file open but not visible Using Excel Options Feature

As a result, you will see the following image on your screen.

  • Following that, click on the Options tab.

excel file open but not visible Using Excel Options Feature

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.

excel file open but not visible Using Excel Options Feature

Consequently, you will see that the Quick Access Toolbar is added to your worksheet as shown in the following image.

excel file open but not visible Using Excel Options Feature


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!


Related Articles

Zahid Hasan

Zahid Hasan

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

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