• 0

That Damned Ribbon!


Question

OK, I upgraded to Excel 2007 because I needed more than 64000 rows of data, OK, not because I wanted to have every last useful menu item hidden from me and a complete time-waster of a ribbon spewed across the top of the screen, OK? The ribbon is nothing more than an exploded toolbar/drop-down menu in any case and how can it tell the context of what I want to do? I can never find any of the uesful features I need and it's driving me insane... well, at least it drove me to consult this forum. I have a copy of a utility that uses the Windows 2000 toolbars, but I cannot install it on my PC at work.

I really need help with these:

Where is the HELP button?

Why are my VBA projects missing?

Where are my Macros?

Hell, for that matter, where are the Excel 2007 Macros?

How do I get rid of the ribbon and set up my own customised toolbars?

What's happened to the colour pallet? How do I get the real one back without all these new colours that are making me feel queasy? Especially the pastels?

Many Thanks

Comments/Observations

Everything was fine until Windows 95. Up until then, a computer knew it's place and programmers knew their place. A computer could do nothing without user input and did nothing until it was told to, and only did what it was told. Now we have all this so-called context-sensitive, reactive, pre-emptive, predictive nonsense trying to guess what I want instead of making it easy for me to tell it what I want. Computers finally have a mind of their own. Seattle has created a monster!

Cheers

baldasacoot

Link to comment
https://www.neowin.net/forum/topic/638030-that-damned-ribbon/
Share on other sites

Recommended Posts

  • 0

Help - F1 or question mark next to minimize button in top right corner.

To get Developer tab, click the Orb (big round button with Office logo in top left corner), then Excel options button, under Popular tab select Show Developer tab in the Ribbon (will reveal in all Office apps). That will take care of what you need.

You can't get rid of ribbon. There is a 3rd part application which is supposedly emulating menus like in old versions. I am not aware how does it perform nor if menus are exactly like in old versions.

I think you can customize the Ribbon by editing some XML files. You should Google it though. I read about ribbon customization while Office was in beta.

Don't know about colors ATM.

Good luck.

Edit: Page Layout Colours? You can make your own color schemes easily.

  • 0

Thank God for that!!!!

I thought I was the only one who was having problems with the ribbon! All the reviews kept banging on about marvellous it is and how it made you more productive - I spend most of my time going insane trying to find basic commands to do the simplest stuff. Definitely thinking about going back to Office 2003 :yes:

  • 0

Thanks for that - just a shame that it should be needed - wasn't the Ribbon designed to ensure easy access to all the commands rather than the nested tables of old? Probably just me being old and not being l33t enuff for teh nu office!! :D

  • 0
I find the ribbon helps people who have never used office before but anyone who used it for over 200hours will be confused and lost

I've used previous versions of Office for over 200 hours. I did find the ribbon confusing at first, but I got used to it after about an hour of use. It's pretty good.

  • 0

You're welcome. You're not alone. I've been using Office for a year now and hate the ribbon. It is confusing. I can do work in previous versions without even looking at the cursor. Finding specific command sometimes can be a bit frustrating. However, MS really did good work trying to make transition to go as smooth as possible. There are videos that explain how the Ribbon works. There is also a guide which lets you choose command in 2003 and it automatically shows you where that option is located in 2007. All is available from office.microsoft.com. It helped me a lot. I got used to it a bit, but still prefer the classic system. Needless to say that I hate when ribbon is used in other applications (zip utilities, defragmentation utilities, CAD software...)

  • 0

Well, I've used Office for over 10,000 hours, since Word 6.0 and Access 2.0, and I've endured many upgrades and I can tell you now, unequivocally and with complete certainty:

The Ribbon is Rubbish.

I've used the ribbon for about an hour and I can't even print, print preview, save as, change the borders, format a cell, or even find the Help menu. That's a steeper learning curve than flying an Apache helicopter! Half of the menus have disappeared. What's the point of it all? Thank God I still have 2003 on my machine.

In fact, I find that recent versions of Office are anti-productive, with all that crap popping up, interrupting me, telling me it looks like a number but it's formatted as text, "OH! You look like you're writing a letter! Would you like some help!", and "I can paste the data in any one of many numerous formats!", changing the case of letters when it''s meant to be PhD and it's supposed to be MDa etc, causing me to go back and change it, reformatting cells I've just formatted because IT thinks I don't know what I'm doing, all in all causing me to use three times the mouse clicks just to get back to point zero. The Ribbon is just the Ultimate Evolution of this anti-productivity: the "Alien Meets Predator" of the software world.

Anyone who claims it helps "productivity" must either be:

1 a completely novice new user who knows no better

2 a Microsoft employee in Lurk Mode

3 a Microsoft wannabe

4 someone who's getting their nose and tongue a little too close to the chocolate starfish of Bill Gate's puckered ring piece. :)

Has no one heard of customising your toolbars? You know, where you get the normal toolbars for Formatting, Borders and Shading, Drawing etc and remove the buttons you never use and add the ones you do. Voila! No need to search for anything at all until you need to do something you've never done before. I had dozens of complex, fifteen page Macros linked to toolbar buttons and now I can't even find them! And now I hear that you can't even edit the Ribbon without hacking some control file?

Anyway, thanks for everyone who's trying to help.

I can't go back to 2003 because I need a million rows of data, which I read was possible in Excel 2007. Actually, I need two million or more, but there you go (and no, I don't need a database for this, I need the data in a spreadsheet).

I can see the Help button now, but where is the Help menu? The one that used to be on the Toolbar?

I still can't find my Macros. What is the Developer? Is that where the Macros etc will be?

How am I supposed to know that that Orb thing does anything?

How am I supposed to know that the Developer tools are "Popular"? What a stupid filing system! Do they file Michael Jackson CDs under "P" for Pervert rather than "J" for Jackson?

By the colour pallette, I mean the colours for Borders and Shading (Oh, yeah, couldn't find that for ages, either). The one that has the nice colour set has been replaced with something that has horrible, dirty, dayglo or fluorescent versions of real world colours. I want the old ones back.

Anyway, keep it coming, if I can't find the equivalents of 2003 in 2007 I'll have to insist the IT department allow me to install that 3rd party toolbar utility. I don't bank on being successful with that.

Thanks

Baldasacoot

  • 0

I have to admit I hate the Ribbon as much as the next person who has spent hundreds of hours in Excel. I don't use it as extensively as I used to before - note I load my million by million tables in db and manipulate results using queries which are extracted to Excel and further processed by code. I'd be inclined to suggest the same thing I've already done, order a two good books for Excel 2007 - I find the 'Bible' series to be most helpful and then specifics I get off Amazon after reading what other folks bought and what they thought of it.

  • 0
Where is the HELP button?

Top right hand corner - same as in Office 2003

Why are my VBA projects missing?

Where are my Macros?

Hell, for that matter, where are the Excel 2007 Macros?

Did you install VBA when you installed Excel (it's not automatic anymore!)

How do I get rid of the ribbon and set up my own customised toolbars?

There are some add-ins, as others have suggested.

What's happened to the colour pallet? How do I get the real one back without all these new colours that are making me feel queasy? Especially the pastels?

The colour pallet was enhanced, you can customise this (the same as you could in Office 2003).

The number of toolbars in Excel 2003 was getting to be unmanageable - I have counted 129 in my installation! The ribbon does "take care" of this problem but it's not ideal...

I know that the ribbon takes a lot of getting used to, but it's not going anywhere for the foreseeable future.

  • 0

Did you also stick with Windows 3.1? :s

Do you also return a car because it handles differently :p

"omg - change, LETS KILL IT :o"

Everything takes time, once you learn where stuff is in new office, its much better than the old interface - I use features I didnt even know was there now :)

  • 0

The ribbon is awesome, sorry you are having so much trouble adjusting. It took me awhile too but once I got the hang of it I realized it is easier and more intuitive than using a pull-down menu.

Everything that was under the menus is in the ribbon. If you can't find it, click on 'Help' and type in what you're looking for. The Help System is pretty good, it will show you where everything is.

We're glad to help but complaining to us won't change anything. You might want to offer Microsoft *constructive* feedback on your trouble with the new Office, as they are the only ones who can officially do something about it.

  • 0

I have used Office 2007 *ever since* November 19th, 2005 as I was a tech beta tester. I have gotten SO USED to the 2007 version that I just upgraded it on top of 2003.

  • 0
Please... Just because Microsoft come up with some bull**** new feature so they can take your money again it doesn't mean everybody has to like it. You don't think they implemented it for the good of Man did you?

oh are you anti-microsoft too? every MS invention has to be evil and horrible, regardless of its actual merits right?

  • 0

Where is the HELP button?

helpbtnvv2.png

Why are my VBA projects missing?

Where are my Macros?

Hell, for that matter, where are the Excel 2007 Macros?

With the help of your newfound friend, the Help button, search for:

  • Developer Toolbar
  • Trusted Locations

How do I get rid of the ribbon and set up my own customised toolbars?

I have no clue how you can get rid of the ribbon, but you can set up your own "mini-toolbar".

toolbaraj0.png

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • That lens of history will burn if you hold it at the right angle... Warn users too late: Shame, Microsoft! That extremely minor update to an obscure Control Panel widget required 2 years of warning. Warn users too early: Shame, Microsoft! We've got better things to do. Pipeline and process be damned, we'll just always be disappointed, eh?
    • Microsoft Paint used to be my favorite Windows app as a kid, and it's still pretty good by Usama Jawad I have been using Windows since the early 2000s, when I was around 10 years old or so. I vaguely remember playing around with Windows 98 and Windows 2000, but that may have been on school PCs which had old operating systems installed. My main OS on the home PC, and the one I recall spending most time with, was Windows XP. At that time, I used the home PC to create Word and PowerPoint documents for school, but a lot of the time, I simply used it to play games. My dad would bring game discs which we would try and install on the PC, sometimes unsuccessfully, and sometimes, we would rely on flash games in the browser, like Bubble Trouble on Miniclip. However, the problem with the latter approach was the internet speed. On a good day, our dial-up internet would offer us speeds of 56 kbps, but on most days, it was closer to 33 kbps. This did not facilitate online gaming as I would often have to wait minutes for a game to load or "draw" on the screen, and trying to download pirated games wasn't simple either. I remember getting tired of waiting for online games to load and just downloading simulator games from the Big Fish Games website instead, only to be disappointed after finding out that I was just being given access to trial versions of the title, and I needed to fork out money to pay for the full version. All of this is to say that it wasn't very easy to find entertainment options on the home PC when I was a kid, due to a number of reasons, mostly outside of my control. This situation pushed me towards a rather unconventional ally: Microsoft Paint. Whenever the internet wasn't working as good as I expected, I would simply spin up Paint and draw complete rubbish on the canvas. Of course, that wasn't always the intention, but it usually happened when I messed up drawing a straight line or something, and then I would give up on that particular piece and simply draw a random collection of objects. Microsoft Paint was extremely accessible and easy to use. Even if you weren't an artist, you could quickly understand the tools at your disposal and how to leverage them on a canvas. The absolute breadth on offer ensured that each painting was truly unique, as you could utilize various combinations of tools like the pencil, paint, spray paint, and more to truly personalize your creation. Since I wasn't particularly good at drawing both on digital screen or a physical screen, I remember that my main style of art would be to insert a bunch of randomly intersecting lines and then fill them with random colors through the paint can. I have trying to replicate that art style in the latest version of Paint below, and as you can see, it's truly Pablo Picasso-esque. The human imagination truly knows no bounds Microsoft Paint kept me occupied for hours and was my best friend when video games on the home PC were inaccessible for one reason or the other. There was no academic or professional reason for which I would need to use Paint, but I still loved using it in my personal time, even if what I created wasn't worth being shown to anyone. It was simply fun. Fast-forward to today, and the situation is mostly the same. Now that I am almost 29 years old, and I still have no reason to use Microsoft Paint in a professional capacity. In fact, I don't even use it in a personal capacity, except to dabble with it from time to time, just to see if core functionalities are still intact. And I'm happy to say that I think Microsoft Paint still offers the same accessibility and inviting experience that it did to me a couple of decades ago, even though its UX has been refreshed and it's been integrated with Copilot features. Interestingly, things could have been a lot different, had Microsoft had its way. Microsoft Paint was marked for deprecation with the Windows 10 Fall Creators Update in 2017, and even began displaying a product retirement alert, urging customers to shift to Paint 3D instead. Fortunately, after consumer backlash, Microsoft reversed course on this decision, and Paint continues to be a native app inside Windows installations that can also be updated quite frequently through the Microsoft Store. Instead, Paint 3D ended up on the chopping block, which is for the better, I think. I have intermittently played around with Microsoft's refreshed Paint experience in the past few years, and I do think it has received worthwhile upgrades. the UI and the UX has been modernized while retaining core functionality, and the app is still fairly easy to use. It doesn't meet any of my use-cases, but I've never really had any use-cases ever, as described previously. Of course, the elephant in the room is the Copilot integration. Personally, I believe that this is one place where Copilot does make sense, environmental concerns aside. I know that a lot of creatives use AI to generate images, and while some may be using professional alternatives, Paint still offers a decent casual experience, with the power of Copilot. Of course, you do need to have a valid Microsoft 365 Copilot license and available credits to use it, but even if you don't, you still get the big Copilot button in the toolbar, unfortunately. All in all, I am glad that Microsoft Paint continues to be a native feature in Windows 11, and a piece of software that has evolved to meet modern needs without cutting off its own roots. It's just an iconic piece of Windows history that was an essential part of my childhood, and while I don't use it anymore, I'm just glad it is still there.
    • 2TB WD_Black SN7100 PCIe Gen4 NVMe SSD drops to its lowest price in over three months by Fiza Ali Amazon is currently offering the 2TB WD_Black SN7100 internal solid-state drive at its lowest price in over three months, so you may want to check it out, if you have been considering a storage upgrade, before the deal dries up (purchase link is toward the end of the article). Featuring a PCIe Gen 4.0 interface and M.2 2280 form factor, the SN7100 promises to deliver sequential read speeds of up to 7,250MB/s and sequential write speeds reaching 6,900MB/s, offering as much as a 35% improvement in performance compared with the previous generation. It also achieves random read speeds of 1,000,000 IOPS and random write speeds of 1,400,000 IOPS. The drive uses Western Digital’s TLC 3D NAND technology for reliable performance and is further supported by a five-year limited warranty. It also offers strong endurance, rated at up to 1,200TBW, making it suitable for demanding workloads such as gaming, content creation, and high-speed recording. Moreover, its DRAM-less architecture claims to improve power efficiency (the SSD relies on system memory for caching via HMB), while the WD_Black Dashboard software enables users to monitor drive health, install firmware updates, and activate Game Mode for potentially better performance. Finally, it operates within an operating temperature range of 0°C to 85°C, and can withstand storage temperatures from -40°C to 85°C. 2TB WD_Black SN7100 PCIe Gen4 NVMe SSD: $242.96 (Amazon US) Check this deal out if you want a 4TB option. Good to know This Amazon deal is U.S. specific, and not available in other regions unless specified. We only use first-party seller links (at the time of article publishing); ensure that you purchase from a first-party seller link only. Check out Today's Deals on Amazon | or our recent tech deals. Become a Prime member (for Students or SNAP) via Neowin Get Prime Access - Prime for half price (for qualifying Medicaid, EBT, SNAP) Subscribe to Prime Video, Audible Plus, Music Unlimited or Kindle Unlimited via Neowin As an Amazon Associate, we earn from qualifying purchases.
    • Hopefully this will fix the issue of no sound I have since last months stupid, and non-removable, Microsoft Corporation AudioProcessingObject Driver Update (1.0.3.56670)
    • It IS confusing! What channel are you in on each device? I'm guessing your 16GB device is on Experimental (formerly known as Dev) and your 128GB is on Beta.
  • Recent Achievements

    • Week One Done
      Supreme Spray LV earned a badge
      Week One Done
    • One Month Later
      Genuinetonerink- Dubai earned a badge
      One Month Later
    • Week One Done
      Genuinetonerink- Dubai earned a badge
      Week One Done
    • One Year In
      hhgygy earned a badge
      One Year In
    • Week One Done
      AMV earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      514
    2. 2
      +Edouard
      163
    3. 3
      PsYcHoKiLLa
      87
    4. 4
      Steven P.
      74
    5. 5
      Michael Scrip
      73
  • Tell a friend

    Love Neowin? Tell a friend!