From Table or Range Monkey
Article Overview One of the things we have been asking the Excel team to do for a long time is give us the ability to
Menu
The Monkey Tools ribbon was designed with one goal in mind – to make you more efficient when building queries and/or data models. A big part of that was building a central ribbon tab which would minimize tab-switching in order to get your job done. But what if you want to customize or personalize the Monkey Tools tab?
While we are pretty happy with all the commands we’ve added for you, there is one group that we could not include in the default Monkey Tools tab layout – the Calculations group from the Power Pivot ribbon. (There is a long and technical story to this, but suffice it to say that Microsoft has not provided a way for us to reference this tab programmatically.)
Given how useful the New Measure and Manage Measures buttons are, we want to customize the Monkey Tools tab to show these. Of course, you may also have other commands that you use frequently… Regardless of which commands they are, this article will show you how you can add groups and buttons to personalize the Monkey Tools tab.
Unfortunately, you are not able to add items into our existing ribbon groups. The good news though, is that you can add a custom group to our ribbon tab, and add whatever controls you like to it.
To make this happen, start by right clicking any ribbon tab and choosing Customize the Ribbon… This will launch you into an Excel Options screen, where you will need to take the following steps:
Once you have your new group set up, you can then add as many commands to that group as you like. Let’s now add the Measures and KPIs buttons from the Power Pivot tab to our custom group.
After clicking OK to save the results, you should now be able to see your new custom group displayed on the Monkey Tools tab:
You are not restricted to one custom group per ribbon tab. If you want to customize your ribbon tab to add even more useful commands, go nuts! In fact, you can even add new ribbon tabs through that same interface in order to build your own custom tabs from scratch. This doesn’t require Monkey Tools, it is a standard feature in Microsoft Office.
Article Overview One of the things we have been asking the Excel team to do for a long time is give us the ability to
Why Customize the Monkey Tools Tab? The Monkey Tools ribbon was designed with one goal in mind – to make you more efficient when building
Article Overview If you’ve worked with Excel for any length of time, chances are pretty good that you have some favourite Power Queries, DAX Measures,
Process Overview The most likely reason you are at this page is because you have been directed here after logging a bug report, and we
Article Overview While we hope that Monkey Tools installs easily and keeps running, the reality is that software is a complicated thing, and sometimes things
Copyright Excelguru Consulting Inc.