Duplicate groups on the Page Layout tab on the ribbon
Ron de Bruin (last update 6-Aug-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 Page Layout tab, you can use the Custom UI Editor then to see/copy the XML.


Name : GroupThemesExcel

<!-- Add Themes group -->
<group id="DupThemes" label="Themes" insertBeforeMso="GroupThemesExcel" > 
	<gallery idMso="ThemesGallery" size="large" />
	<gallery idMso="ThemeColorsGallery" />
	<gallery idMso="ThemeFontsGallery" />
	<gallery idMso="ThemeEffectsGallery" />
</group> 


Name = GroupPageSetup

<!-- Add Page Setup group -->
<group id="DupPageSetup" label="Page Setup" insertBeforeMso="GroupPageSetup" > 
	<gallery idMso="PageMarginsGallery" size="large" />
	<gallery idMso="PageOrientationGallery" size="large" />
	<gallery idMso="PageSizeGallery" size="large" />
	<menu idMso="PrintAreaMenu" size="large" />
	<menu idMso="PageBreakMenu" size="large" />
	<button idMso="SheetBackground" size="large" />
	<button idMso="PrintTitles" size="large" />

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


Name = GroupPageLayoutScaleToFit

<!-- Add Scale to Fit group -->
<group id="DupScaleToFit" label="Scale to Fit" 
	insertBeforeMso="GroupPageLayoutScaleToFit" > 
	<comboBox idMso="PageScaleToFitWidth"  />
	<comboBox idMso="PageScaleToFitHeight"  />
	<control idMso="PageScaleToFitScale"  />

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


Name = GroupPageLayoutSheetOptions

<!-- Add Sheet Options group -->
<group id="DupSheetOptions" label="Sheet Options" 
	insertBeforeMso="GroupPageLayoutSheetOptions" > 
	<labelControl id="PS1" label="Gridlines"/>
	<checkBox idMso="ViewSheetGridlines"  /> 
	<checkBox idMso="SheetPrintGridlines"  />
	<separator id="PSSeparator1" /> 
	<labelControl id="PS2" label="Headings"/>
	<checkBox idMso="ViewSheetHeadings"  /> 
	<checkBox idMso="SheetPrintHeadings"  /> 

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


Name = GroupArrange

<!-- Add Arrange group -->
<group id="DupArrange" label="Arrange" insertBeforeMso="GroupArrange" > 
	<splitButton idMso="ObjectBringToFrontMenu" size="large" />
	<splitButton idMso="ObjectSendToBackMenu" size="large" />
	<toggleButton idMso="SelectionPane" size="large" />
	<menu idMso="ObjectAlignMenu" size="large" />
	<menu idMso="ObjectsGroupMenu" size="large" />
	<gallery idMso="ObjectRotateGallery" size="large" />
</group>