No one ever accused me of being TOO stylish, in any walk of my life. Perhaps thats why I gravitated to Microsoft rather than Apple or Macromedia/Adobe?
Microsofts main stated aim with 2007 was to pull style and presentation front and centre. (some of us might argue that was at the expense of content – but that is a separate rant).
Now Styles in Excel are one of those things that sound good in theory, but are significantly worse than useless in reality. In an isolated world they may work but as soon as you start copying a pasting between workbooks, and who doesn’t (apart from the styles feature team)? then you get a right royal style mess. I was looking at one workbook the other day that had aver 50,000 styles defined in it. It was very unstable.
It was in working with that file though that I noted just how crap the Styles interface is in the ribbon.
Sure, it has the live preview and the styles gallery (well whoop de-chuffing-doo). I spent 20 minutes scouring t’intarwebs trying to find how on earth you might delete a style. Pretty standard procedure right? part of the normal CRUD lifecyle, well the end of it in fairness.
Anyway to delete an existing style you right click on it and choose delete from the right click menu. Hmm, pretty ‘discoverable’ right?
Since when did right clicking a menu item give you commands related to the underlying object rather than options about the menu itself? I’m guessing since the effluent UI?
And what’s with right clicking?
Right click was always a collection of the most contextually useful commands repeated from their usual location. If you wanted to do something unusual then normally the subset on right click would not cover it and you went to the home of those context sensitive commnds to trigger the unusual one.
I still haven’t found the base location of the style-delete functionality. I don’t think there is one. I think the right click concept has changed in the Effluent UI
Collection of most useful commands in the current context
Dumping ground for anything that doesn’t fit our magnificent design
So in summary:
- Styles are still rubbish
- Styles are even harder to delete
- Right clicking the UI is now totally unpredictable, you may get no effect, options about the UI or options about the object to which the UI relates.
- Right click is now the bin for things that don’t fit the woeful UI design
Note on tense:
My use of the past tense for some parts of this should in no way be taken to indicate I have moved on from Excel classic, I havent.
Style misery can be reduced by avoiding copying whole sheets and just copying cell values and formulas, or by just using minimal formatting and let your analysis speak for itself (if it can!).