Duplicate groups on the Home tab on the ribbon
Ron de Bruin (last update 24-sept-2008)
Go back to the Excel tips page

Go back to the "Change built-in groups in the Ribbon" Page


Note: in the Download section on the example page you can download a file that
rebuild the Home tab, you can use the Custom UI Editor then to see/copy the XML.


Name : GroupClipboard

Note: FormatPainter is a toggleButton but we must use control if we want to add the control.


<!-- Add Clipboard group -->
<group id="DupClipboard" label="Clipboard" insertBeforeMso="GroupClipboard" > 
	<splitButton idMso="PasteMenu" size="large" />
	<button idMso="Cut"/> 
	<button idMso="Copy"/> 
	<control idMso="FormatPainter"/> 

	<dialogBoxLauncher>
	<button  idMso="ShowClipboard" />           
	</dialogBoxLauncher>
</group> 


Name = GroupFont

<!-- Add Font group -->
<group id="DupFont" label="Font" insertBeforeMso="GroupFont" >  
	<box id="HF1" boxStyle="horizontal"> 
	<comboBox idMso="Font"/> 
	<comboBox idMso="FontSize"/> 
	<buttonGroup id="HFButtonGroup1"> 
	<button idMso="FontSizeIncrease"/>
	<button idMso="FontSizeDecrease"/> 
	</buttonGroup> 
	</box> 

	<box id="HF2" boxStyle="horizontal"> 
	<buttonGroup id="HFButtonGroup2"> 
	<toggleButton idMso="Bold"/> 
	<toggleButton idMso="Italic"/> 
	<splitButton idMso="UnderlineGallery"/> 
	</buttonGroup> 
	<buttonGroup id="HFButtonGroup3"> 
	<splitButton idMso="BordersGallery"/>
	</buttonGroup> 
	<buttonGroup id="HFButtonGroup4"> 
	<gallery idMso="CellFillColorPicker"/>
	<gallery idMso="FontColorPicker"/> 
	</buttonGroup> 
	</box>

	<dialogBoxLauncher>
	<button  idMso="FormatCellsFontDialog" />           
	</dialogBoxLauncher>
</group> 


Name = GroupAlignmentExcel

<!-- Add Alignmentgroup -->
<group id="DupAlignment" label="Alignment" insertBeforeMso="GroupAlignmentExcel" >  
	<box id="HA1" boxStyle="horizontal"> 
	<buttonGroup id="HAButtonGroup1"> 
	<toggleButton idMso="AlignTopExcel"/> 
	<toggleButton idMso="AlignMiddleExcel"/> 
	<toggleButton idMso="AlignBottomExcel"/> 
	</buttonGroup> 
	<buttonGroup id="HAButtonGroup2"> 
	<menu idMso="OrientationMenu"/> 
	</buttonGroup> 
	</box> 

	<box id="HA2" boxStyle="horizontal"> 
	<buttonGroup id="HAButtonGroup3"> 
	<toggleButton idMso="AlignLeft"/> 
	<toggleButton idMso="AlignCenter"/> 
	<toggleButton idMso="AlignRight"/> 
	</buttonGroup> 
	<buttonGroup id="HAButtonGroup4"> 
	<button idMso="IndentDecreaseExcel"/>
	<button idMso="IndentIncreaseExcel"/> 
	</buttonGroup> 
	</box>

	<separator id="HASeparator1" />	

	<toggleButton idMso="WrapText"/> 
	<splitButton idMso="MergeCenterMenu"/>

	<dialogBoxLauncher>
	<button  idMso="CellAlignmentOptions" />           
	</dialogBoxLauncher>
</group> 


Name = GroupNumber

<!-- Add Number group -->
<group id="DupNumber" label="Number" insertBeforeMso="GroupNumber" >  
	<comboBox idMso="NumberFormatGallery"/> 
	<box id="HN1" boxStyle="horizontal"> 
	<buttonGroup id="HNButtonGroup1"> 
	<splitButton idMso="AccountingFormatMenu"/> 
	<button idMso="PercentStyle"/> 
	<button idMso="CommaStyle"/> 
	</buttonGroup> 
	<buttonGroup id="HNButtonGroup2"> 
	<button idMso="DecimalsIncrease"/> 
	<button idMso="DecimalsDecrease"/> 
	</buttonGroup> 
	</box>

	<dialogBoxLauncher>
	<button  idMso="FormatCellsNumberDialog" />           
	</dialogBoxLauncher>
</group> 


Name = GroupStyles

<!-- Add Styles group -->
<group id="DupStyles" label="Styles" insertBeforeMso="GroupStyles" >  
	<menu idMso="ConditionalFormattingMenu" size="large" /> 
	<gallery idMso="FormatAsTableGallery" size="large" /> 
	<gallery idMso="CellStylesGallery" size="large" /> 
</group> 


Name = GroupCells

<!-- Add Cells group -->
<group id="DupCells" label="Cells" insertBeforeMso="GroupCells" >  
	<splitButton idMso="InsertCellstMenu" size="large" /> 
	<splitButton idMso="TableDeleteRowsAndColumnsMenu" size="large" /> 
	<menu idMso="FormatCellsMenu" size="large" /> 
</group> 


Name = GroupEditingExcel

<!-- Add Editing group -->
<group id="DupEditing" label="Editing" insertBeforeMso="GroupEditingExcel" >  
	<splitButton idMso="AutoSumMenu"  /> 
	<menu idMso="FillMenu"  /> 
	<menu idMso="ClearMenu" /> 
	<menu idMso="SortFilterMenu" size="large" /> 
	<menu idMso="SelectMenuExcel" size="large" /> 
</group>