Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The ribbon in Excel 2010 appears when I click on Home or Insert or one of the other tabs, but disappears again when I go back to editing my document. I'd like it to always be visible - how can I get it back so that it stays there?

Not sure whether the correct term for it would be "minimized", "hidden" or something else, but it's gone until I click a tab heading.

share|improve this question
I commend you for editing to match the MS Office spelling.. it hurt me too to use a 'z' ;) – Bob Apr 27 '12 at 14:42
up vote 8 down vote accepted

Right click on one of the tab headings and uncheck Minimize the Ribbon.

Screenshot of menu option
Click for full size

share|improve this answer
For folks that like keyboard shortcuts this is also controlable via the combo 'Ctrl + F1' – edusysadmin Apr 27 '12 at 18:30

In addition to @Bob's answer, there's a little icon in the upper-right corner. It's to the left of the question mark in this picture:

enter image description here

share|improve this answer

If using VBA code, insert this line to hide it:

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

To unhide it, use:

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
share|improve this answer
Remember to properly format your question. Use a right angle bracket > before each line of a block quote, and indent code blocks with four spaces – bwDraco Nov 29 '14 at 5:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.