Excel Ribbon

Tramari10

New Member
Joined
Jan 6, 2020
Messages
7
Office Version
  1. 365
Platform
  1. Windows
No matter what I seem to do I cannot get the Excel Ribbon to expand. I gave tried shortcut keys, alt keys. The triangle on the top right. There is no ellipsie to show all. I went to file hoping to go to options but there is no options. I tried right clicking on tabs and right clicking on the ribbon that is there and it still wont expand. I definately need an expert. If you know tge answer please help.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Not sure what you're asking for. If your ribbon is collapsed, all you need to do is right click beside one of the tab labels (in this pic, just beside Help) and choose from the menu to expand (not collapse).

1730849050384.png
 
Upvote 0
Thanks for your response but i get nothing when i try to right click beside help. Absolutely nothing happens at all. I tried to upload pictures taken on my phone but the files are too large
 
Upvote 0
Is the "Collapse the ribbon automatically" box checked under Gerneral tab of the Options menu?
 
Upvote 0
Hi, Hopefully you can see what I am working with. The first pic is what I have. The second pic is what I am trying to get. I dont understand why I cant find or get access to reset this ribbon.
 

Attachments

  • 20241105_194307.jpg
    20241105_194307.jpg
    45.1 KB · Views: 10
  • 20241105_194705.jpg
    20241105_194705.jpg
    111 KB · Views: 8
Upvote 0
Unfortunately, neither of those help because they are not pictures of the Excel application.
 
Upvote 0
I enlarged one image and I believe they both are Excel ( I can see that the filename is xls based), but one looks like a really old version that resembles commandbars and menus. I know that if an Access file contains legacy commandbars, they are relegated to the QAT and are available there. Perhaps the same is true for Excel. What I don't know is what the effect is if you have legacy commandbars and hide the ribbon. That may be what is going on here. I think I would copy the file and play with the ribbon options in settings (e.g. looking to ensure the ribbon is not hidden). Or I'd look to see if there is any xml being loaded that replaces the ribbon with something else.
 
Upvote 0
The 1st image looks like Google Sheets, not Excel & Sheets just has a tool bar, rather than a Ribbon.
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,150
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top