How do I bring back the ribbon in Office 2010?

Question

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.

score 8 · Accepted Answer · answered Apr 27 '12 at 07:43

8

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

^{Click for full size}

answered Apr 27 '12 at 07:43

Bob

63,170

score 4 · Answer 2 · answered Apr 27 '12 at 18:12

4

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

answered Apr 27 '12 at 18:12

Doug Glancy

1,839

score 0 · Answer 3 · edited Nov 29 '14 at 05:21

0

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)"

edited Nov 29 '14 at 05:21

bwDraco

46,683

answered Nov 29 '14 at 01:58

Kharon

1

How do I bring back the ribbon in Office 2010?

3 Answers3