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.

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

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

60,938
25
191
216

4

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

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,821
13
14

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

45,747
43
165
205

answered Nov 29 '14 at 01:58

Kharon

1

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 05:22

How do I bring back the ribbon in Office 2010?

3 Answers3