Ribbon is the central point of whatever you do in Excel, the area where most of features and commands available to you reside. Do you feel the ribbon takes up too much of your screen space? No problem, one click of your mouse, and it is hidden. Continue reading
Comments on: How to show, hide and restore missing ribbon in Excel
by Svetlana Cheusheva, updated on
Comments page 2. Total comments: 37
There is no option available to reinstore the ribbon on my oulook webmail, and I need it urgently to add a app specific password to fix a yahoo app. Please advise.
thank u
Everything above the data will just disappear when a file has been opened for more than 20 minutes. It has been so frustrating. There has been no button at the upper right, and I've searched for so long to find the solution. Finally, the Cntl-F1 you mention here worked! Thank you!
I was trying to get my spreadsheet to stay on the Home page. I clicked on "collapse ribbon" and my spreadsheet disappeared. I can see the spreadsheet file but I cannot open it. Could you please help ?
The add-in tab is appearing even after I uninstall the respective adding app.
I checked, no open key available in hkcu. The add-in is coming from excel15.xlb. I can't remove the .club file as it stores other user customisation data related to excel ribbon.
Kindly suggest.
Could you please help. In Excel 2016 the ribbon and menu bar are missing, but the Ribbon Display Options icon is not available to restore them, only the minimize, maximize and close icon are displayed in the top right corner. Tried CTRL + F1 but not this has not worked. Thanks in advance for any help.
You can use the VBA codes to hide the ribbon.?
Dear Svetlana
Could you please guide me about how to sum numbers greater than zero by the months. (i.e. if there are number of months and we have values in them but count the numbers which have value greater than zero in that month).
Regards
Faisal
Faisal.aziz26 @ gmail
Dear Faisal,
You can use the SUMIFS or COUNTIFS function for this, depending on whether you want to add up all non-zero values for a specific month or just count the number of non-zero values for a given month.
An exact formula will depend on how months are input in your data set (dates, numbers representing the months, or month names as text). If you can provide a small sample of your data and an expected result, I will try to help with the formula.
Thanks svetlana.