I know it’s been forever since I’ve blogged here, and I’m sorry to have to revive this with a rant, butâ€¦
I was writing an article up for how to customize the Office Ribbon in Excel 2010, and thought I’d build a custom Auditing Tab. Using the built in groups is REALLY easy, but there were commands there I didn’t need. So I figured that I’d try to make some custom groups, insert the commands I wanted, and see how it worked. Even better, I know that you can now export the customizations, so I could even share them!
To build a custom Ribbon tab:
- Right click the Ribbon and choose “Customize Ribbon”, or go to FileÃ Excel OptionsÃ Customize Ribbon.
- Click New Tab
- Select the tab and choose Rename
- Go to the “Choose commands from” dropdown and choose Main Tabs
- Find the groups you like, select them and click the Add>> button
To add a new group to a tab, first select the tab then:
- Click New Group
- Select the group and choose Rename
- Drill down to the commands you like (left window), select them and click the Add>> button
Overall it’s not too complicated really.
So here’s the setup I did for my Auditing Tabâ€¦ (I shrunk it so that you only see stuff pertaining to that tab):
As you can see, I created custom Formula Auditing, Other Tools and Sort & Filter groups. (I don’t know why I use the default Sort & Filter as well a custom one, but there you have it. At any rate, it doesn’t change thisâ€¦ the tab looks like crap!
The icons for Trace Precedents, Trace Dependents and Remove Arrows are all large and very blocky looking. Same with the Sort buttons on the custom group. Why is it that they are shown nice and small on the built in group, but not the custom one? And isn’t it interesting how Microsoft broke the 1 or 3 to a row rule with the Sort group? Makes it very obvious here!
If you want the customization file to try this yourself, click here.
Personally, I’m happy enough with the way the built-in groups work, but I think there should have been a bit more control on the sizing of the icons here. It seems that the need for my book (RibbonX â€“ Customizing the Office 2007 Ribbon) isn’t dead yet, but honestly, it should be!