Change built-in groups in the Ribbon
It is not possible to add to or remove controls from
built-in groups in the Ribbon. For example, the
Format Painter button from the Home tab's Clipboard group cannot be removed from this group.
But there is a way around this restriction.
We can hide a built-in group and then duplicate it with RibbonX.
And then we can modify our duplicate group anyway we want.
To do this you have to know how to add RibbonX to a workbook first.
If you not know how to do this follow the steps on this page and then come back.
http://www.rondebruin.nl/ribbon.htm
Let's begin
There are a seven default tabs on the Ribbon and an eighth if you show the Developer tab.
To display the Developer tab in Excel 2007 go to "Office Button >Excel Options...Popular".
and in Excel 2010 go to "File>Options>Customize Ribbon" and check the checkbox
before Developer on the right in the Main Tabs list.
Note: For each Tab there is a different page with RibbonX that rebuild each group on it.
Click on the links in the Tab Name column.
In the RibbonX we must know the names of the main Tabs
If you click on a tab name in the first column you will go to a page where you can see a origenal
screenshot of every group in that tab and you can copy the RibbonX to create this group.
Note: The pages are for Excel 2007 but in the download files you also can see how to do it in Excel 2010.
There are a few changes between Excel 2007 and Excel 2010 in the groups in the main tabs,
there is more info about this in the download section.
Note: You see that not every group looks the same as the original group because there are a
few things that we can't control. For example It is not possible to change the width of a built-in
combobox or to center two rows of controls in a group.
Tab number nine: Add-Ins
This tab only exists when you open an workbook that creates its own menus with VBA code or
use RibbonX that put the controls specific in the Add-ins tab.
The name you must use in RibbonX is : TabAddIns
Example for Excel 2007
As an example of replacing a built in group and then customizing it, we will hide the original
"Clipboard" group on the Home tab and build a new one without the Format Painter control.
In addition we will add the Mail Recipient button that Microsoft has hidden.
The Mail Recipient button sends a selection or worksheet to the body of an email.
You can add a built-in control like we do here or add a custom button that runs a macro.
On my Ribbon page you can find examples of how you can add a custom button.
http://www.rondebruin.nl/ribbon.htm
Excel’s built-in Clipboard group before we replace it with ours:

First we create a new workbook and save it with the name test.xlsx and we close this workbook.
Then we open the file in the UI Editor and paste the RibbonX below in the Office 2007 Custom UI Part.
We enter the following six lines in the UI editor (start and end lines of the XML)
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
</tabs>
</ribbon>
</customUI>
Between these lines we first add RibbonX to hide the built-in Clipboard group.
<!-- Set visible to false for the Clipboard group on the Home tab-->
<tab idMso="TabHome">
<group idMso="GroupClipboard" visible="false"/>
</tab>
Now we click on the Save button in the Custom UI Editor and open the file test.xlsx in Excel.
And if you have done it correctly the Clipboard group is not visible anymore.
The next step is to rebuild the group, you can find the RibbonX to do this on the page for the Home tab above.
But first be sure to close test.xlsx in Excel so the UI editor can change it.
The complete RibbonX looks like this after we delete this line that add the Format Painter control:
<control idMso="FormatPainter"/>
And add this line to add the Mail Recipient control:
<toggleButton idMso="SendCopySendToMailRecipient" />
Tip: Copy and paste the complete RibbonX from this page so indenting is OK in the UI Editor: Example1.txt
If you have done it correctly, the Format Painter button will be replaced by the Mail Recipient like this:

Download for Excel 2007 and 2010
In this Zip file there is one file for each Tab on the Ribbon.
Every file hides all groups on its tab and duplicates them with RibbonX.
Use the Custom UI Editor to see the RibbonX that creates the new groups.
Note: There is RibbonX for Excel 2007 and for Excel 2010 in the files, it will automatic
load the correct RibbonX part if you open the file in Excel 2007 or in Excel 2010.
See the Office 2007 Custom UI Part and Office 2010 Custom UI Part part in the Custom UI Editor.
Download XMLRibbonGroups.zip
What is changed in Excel 2010 ?
Insert tab :
There are three new groups named Sparklines, Filter and Symbols.
The Symbol button from the Text group is moved to the new symbol group now.
Page Layout tab:
The first two splitbuttons in the Arrange group are new ones
(ObjectBringForwardMenu and ObjectSendBackwardMenu)
They swapped the order of the first two items in the two new splitbuttons. The 2007 idMso's names ObjectBringToFrontMenu and ObjectSendToBackMenu are still available in Excel 2010.
Review tab :
The Translate button is removed from the Proofing group and now have his own group on this tab.
Also the idMso is changed from TranslationPane to Translate, but TranslationPane is still working in 2010.
The toggle button Protect Workbook is changed(no arrow on the button) in 2010 and is named ReviewRestrictEditing now,but the old names are still working (in 2007 it is a menu and a toggle button).
View tab :
The checkbox "Message Bar" is removed from the Show/Hide group.
Also the caption of this group is changed now to "Show"
More information
Change the Ribbon in Excel 2007 or Excel 2010
http://www.rondebruin.nl/ribbon.htm
There are more links in the "More Information" part of that page
Format Painter button from the Home tab's Clipboard group cannot be removed from this group.
But there is a way around this restriction.
We can hide a built-in group and then duplicate it with RibbonX.
And then we can modify our duplicate group anyway we want.
To do this you have to know how to add RibbonX to a workbook first.
If you not know how to do this follow the steps on this page and then come back.
http://www.rondebruin.nl/ribbon.htm
Let's begin
There are a seven default tabs on the Ribbon and an eighth if you show the Developer tab.
To display the Developer tab in Excel 2007 go to "Office Button >Excel Options...Popular".
and in Excel 2010 go to "File>Options>Customize Ribbon" and check the checkbox
before Developer on the right in the Main Tabs list.
Note: For each Tab there is a different page with RibbonX that rebuild each group on it.
Click on the links in the Tab Name column.
In the RibbonX we must know the names of the main Tabs
| Tab Name | Name in XML |
| Home | TabHome |
| Insert | TabInsert |
| Page Layout | TabPageLayoutExcel |
| Formulas | TabFormulas |
| Data | TabData |
| Review | TabReview |
| View | TabView |
| Developer | TabDeveloper |
If you click on a tab name in the first column you will go to a page where you can see a origenal
screenshot of every group in that tab and you can copy the RibbonX to create this group.
Note: The pages are for Excel 2007 but in the download files you also can see how to do it in Excel 2010.
There are a few changes between Excel 2007 and Excel 2010 in the groups in the main tabs,
there is more info about this in the download section.
Note: You see that not every group looks the same as the original group because there are a
few things that we can't control. For example It is not possible to change the width of a built-in
combobox or to center two rows of controls in a group.
Tab number nine: Add-Ins
This tab only exists when you open an workbook that creates its own menus with VBA code or
use RibbonX that put the controls specific in the Add-ins tab.
The name you must use in RibbonX is : TabAddIns
Example for Excel 2007
As an example of replacing a built in group and then customizing it, we will hide the original
"Clipboard" group on the Home tab and build a new one without the Format Painter control.
In addition we will add the Mail Recipient button that Microsoft has hidden.
The Mail Recipient button sends a selection or worksheet to the body of an email.
You can add a built-in control like we do here or add a custom button that runs a macro.
On my Ribbon page you can find examples of how you can add a custom button.
http://www.rondebruin.nl/ribbon.htm
Excel’s built-in Clipboard group before we replace it with ours:

First we create a new workbook and save it with the name test.xlsx and we close this workbook.
Then we open the file in the UI Editor and paste the RibbonX below in the Office 2007 Custom UI Part.
We enter the following six lines in the UI editor (start and end lines of the XML)
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
</tabs>
</ribbon>
</customUI>
Between these lines we first add RibbonX to hide the built-in Clipboard group.
<!-- Set visible to false for the Clipboard group on the Home tab-->
<tab idMso="TabHome">
<group idMso="GroupClipboard" visible="false"/>
</tab>
Now we click on the Save button in the Custom UI Editor and open the file test.xlsx in Excel.
And if you have done it correctly the Clipboard group is not visible anymore.
The next step is to rebuild the group, you can find the RibbonX to do this on the page for the Home tab above.
But first be sure to close test.xlsx in Excel so the UI editor can change it.
The complete RibbonX looks like this after we delete this line that add the Format Painter control:
<control idMso="FormatPainter"/>
And add this line to add the Mail Recipient control:
<toggleButton idMso="SendCopySendToMailRecipient" />
Tip: Copy and paste the complete RibbonX from this page so indenting is OK in the UI Editor: Example1.txt
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon> <tabs> <!-- Set visible to false for the Clipboard group on the Home tab--> <tab idMso="TabHome"> <group idMso="GroupClipboard" visible="false"/> </tab> <!-- Point to the Built-in tab to the ribbon --> <tab idMso="TabHome"> <!-- Add Clipboard group --> <group id="DupClipboard" label="Clipboard" insertBeforeMso="GroupClipboard" > <splitButton idMso="PasteMenu" size="large" /> <button idMso="Cut"/> <button idMso="Copy"/> <toggleButton idMso="SendCopySendToMailRecipient" /> <dialogBoxLauncher> <button idMso="ShowClipboard" /> </dialogBoxLauncher> </group> </tab> </tabs> </ribbon> </customUI>Now we click the Save button in the Custom UI Editor and open the file test.xlsx in Excel.
If you have done it correctly, the Format Painter button will be replaced by the Mail Recipient like this:

Download for Excel 2007 and 2010
In this Zip file there is one file for each Tab on the Ribbon.
Every file hides all groups on its tab and duplicates them with RibbonX.
Use the Custom UI Editor to see the RibbonX that creates the new groups.
Note: There is RibbonX for Excel 2007 and for Excel 2010 in the files, it will automatic
load the correct RibbonX part if you open the file in Excel 2007 or in Excel 2010.
See the Office 2007 Custom UI Part and Office 2010 Custom UI Part part in the Custom UI Editor.
Download XMLRibbonGroups.zip
What is changed in Excel 2010 ?
Insert tab :
There are three new groups named Sparklines, Filter and Symbols.
The Symbol button from the Text group is moved to the new symbol group now.
Page Layout tab:
The first two splitbuttons in the Arrange group are new ones
(ObjectBringForwardMenu and ObjectSendBackwardMenu)
They swapped the order of the first two items in the two new splitbuttons. The 2007 idMso's names ObjectBringToFrontMenu and ObjectSendToBackMenu are still available in Excel 2010.
Review tab :
The Translate button is removed from the Proofing group and now have his own group on this tab.
Also the idMso is changed from TranslationPane to Translate, but TranslationPane is still working in 2010.
The toggle button Protect Workbook is changed(no arrow on the button) in 2010 and is named ReviewRestrictEditing now,but the old names are still working (in 2007 it is a menu and a toggle button).
View tab :
The checkbox "Message Bar" is removed from the Show/Hide group.
Also the caption of this group is changed now to "Show"
More information
Change the Ribbon in Excel 2007 or Excel 2010
http://www.rondebruin.nl/ribbon.htm
There are more links in the "More Information" part of that page