QAT disappears

[Dan Wilson]

Good day. I am running Excel out of Office 365 (updated) on Windows 10. Recently, Microsoft sent an update and since then the Quick Access Toolbar (QAT) keeps disappearing from the top of my worksheets. I can get it back by clicking on the three dots in the upper right-hand corner, but then Rows 1 through 5 are covered. I have searched the Options, but cannot find how to keep the QAT on the screen. Any help is appreciated.
Thank you,
Dan Wilson...

 

[Domenic]

I have Microsoft 365, but I don't have those three dots in the upper right-hand corner.

In any case, try this and see if it helps.

First go to the Quick Access Toolbar dialog box (File >> Options >> Quick Access Toolbar).

If "Show Quick Access Toolbar" is already selected, de-selected it and click on OK. Then go back, select it, and click on OK again.

If it's not already selected, then select it and click on OK.

Does this help?

 

[Alex Blakenburg]

Do you by any chance have Auto-Hide Ribbon selected ?

 

[Dan Wilson]

Good day Domenic and Alex. Thank you both for responding.
I created a new post because I did not know if adding to the existing post would be seen. Thank you for defining that. I found the problem. When I click on the empty bar at the top of the screen and the QAT is displayed, there is a blank spot at the right side of the QAT with an arrow in it. Clicking on that arrow brought up the option to "Always Show Ribbon". After I clicked on that instead of "Hide Quick Access Toolbar" all is well. Domenic, the three dots are next to the Red "X" at the top, right corner of the screen when the QAT is hidden. I think it's a Windows function.

Thank you both for the rescue.
Dan Wilson...

 

[Alex Blakenburg]

Interesting.
I am running 365 Family and in that it still shows as: Auto-hide Ribbon, Show Tabs & Show Tabs and Commands, as in my screen shot above.
On the MS site my set up is documented under Office 2013 - Office 2019, despite me running 365.
Show or hide the ribbon in Office (Office 2013 - Office 2019)

The options you are describing sit under Newer Versions
Show or hide the ribbon in Office (Newer_Versions)

Thanks for the feedback and glad we could help.
@Domenic's post encouraged me to take a look


Newer Versions

 

[Dan Wilson]

Interesting.
I am running 365 Family and in that it still shows as: Auto-hide Ribbon, Show Tabs & Show Tabs and Commands, as in my screen shot above.
On the MS site my set up is documented under Office 2013 - Office 2019, despite me running 365.
Show or hide the ribbon in Office (Office 2013 - Office 2019)

The options you are describing sit under Newer Versions
Show or hide the ribbon in Office (Newer_Versions)

Thanks for the feedback and glad we could help.
@Domenic's post encouraged me to take a look


Newer Versions

Good day Alex. I'm not sure I fully understand the problem with the different versions, but my problem is fixed. I also found that choosing "Full Window" caused the same problem. Thanks for the help.
Dan Wilson...