Share via

Restore Excel 2007 Ribbon to Default

Anonymous
2016-05-08T16:49:52+00:00

I want to return the ribbon in Excel 2007 to default.

Mine looks like this: 

I prefer it looks like this: 

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-05-08T20:50:11+00:00

You have not done anything to alter the Ribbon.  You cannot do anything to alter the Ribbon.  It makes its own decisions.  It is always in its "default" setting.  It makes the most of the space available to it [the combination of window size & display resolution].

This is the Excel 2007 Ribbon on my 1366x768 computer, window maximised

This is the Excel 2007 Ribbon on my 1920x1200 computer, window maximised

Both Excel 2007s have exactly the same Excel Options.  There is no difference between them other than the monitor they work with.

This is the Excel 2007 Ribbon on my 1920x1200 computer in a window that is smaller than maximised

The only way to alter an Office 2007 Ribbon's contents to suit your preferences is by building a CustomUI as an add-in. 

If you ever upgrade to Office 2016 then you will find that the Ribbon can be Customised in Excel Options - you can see that entry on the left in Bernard's screenshot.  Here is a shot of its dialog.

You can change which Ribbon tabs appear and you can change which controls appear on each tab [these choices were first introduced with Office 2013, I believe].  But if, like me, you want to hang on to Office 2007 until it falls out of support next year, then the Ribbon is a law unto itself as far as we are concerned.

And that other post about setting Options - you are correct about our Options being set up differently and that post was also irrelevant; the poster thought you wanted to change the display theme and that is not relevant to your actual question.  As Excel 2007 users, we can change Excel Options, Popular, Colour scheme between Blue, Silver & Black.  Your present Colour scheme is Black and the Colour scheme of the Excel in the screenshots you added are Blue.  Excel 2016 has more choices when it comes to colour schemes.  But as I say, this is not the point of your question.

Was this answer helpful?

1 person found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-08T19:36:57+00:00

    In both examples, the window was on maximize. One was a screenshot from my Excel 2007 workbook, where I cannot "close" the Cell Styles. And one is from a screen shot of the default set-up for Excel 2007. I merely cropped the photos for an easier visual. 

    I must have once done something to expand Cell Styles and I'd like to contract it so it looks like the others. 

    I want the default setting which looks like this: 

    Note this is a screenshot from a video, but you will see Excel is maximized.

    Mine presently looks like this:

    As you can see it is maximzed. I must have done something to expand Cell Styles. There has to be a way to restore it to a default. 

    Thanks.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-05-08T19:06:50+00:00

    The Excel 2007 Ribbon expands to make as much use as possible of the available window size. 

    In the second diagram, the window is too small for the full Ribbon to display so it has automatically [and using rules that are not accessible by the user] hidden some parts of itself to leave what it considers to be the most useful parts of the Ribbon visible.

    To change this permanently, you would have to study enough VBA to develop a CustomUI add-in.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-05-08T18:48:12+00:00

    Go to File | Options | General and change value as shown in screenshot below. This is for Excel 2016 but Excel 2007 was very similar.

    best wishes

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-05-08T18:45:13+00:00

    Re:  "prefer it looks like this"

    I do too.  In xl2010, the only way I've found is to reduce the Excel window size.

    With my 27" monitor, leaving about 3 inches (across) of the desktop showing, does the trick.

    '---

    Jim Cone

    Portland, Oregon USA

    https://goo.gl/IUQUN2 (Dropbox)

    Was this answer helpful?

    0 comments