Duplicate groups on the View 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 View tab, you can use the Custom UI Editor then to see/copy the XML.


Name : GroupWorkbookViews

<!-- Add Workbook Views group -->
<group id="DupWorkbookViews" label="Workbook Views" 
		insertBeforeMso="GroupWorkbookViews" > 
	<toggleButton idMso="ViewNormalViewExcel" size="large" />
	<toggleButton idMso="ViewPageLayoutView" size="large" />
	<toggleButton idMso="ViewPageBreakPreviewView" size="large" />
	<separator id="VWV1" /> 
	<button idMso="ViewCustomViews" size="large" />
	<toggleButton idMso="ViewFullScreenView" size="large" />
</group> 


Name = GroupViewShowHide

<!-- Add Show/Hide group -->
<group id="DupShowHide" label="Show/Hide" insertBeforeMso="GroupViewShowHide" > 
	<checkBox idMso="ViewRulerExcel" />
	<checkBox idMso="GridlinesExcel" />
	<checkBox idMso="ViewMessageBar" />
	<checkBox idMso="ViewFormulaBar" />
	<checkBox idMso="ViewHeadings" />
</group> 


Name = GroupZoom

<!-- Add Zoom group -->
<group id="DupZoom" label="Zoom" insertBeforeMso="GroupZoom" > 
	<button idMso="ZoomDialog" size="large" />
	<button idMso="ZoomCurrent100" size="large" />
	<button idMso="ZoomToSelection" size="large" />
</group> 


Name = GroupWindow

<!-- Add Window group -->
<group id="DupWindow" label="Window" insertBeforeMso="GroupWindow" > 
	<button idMso="WindowNew" size="large" />
	<button idMso="WindowsArrangeAll" size="large" />
	<gallery idMso="ViewFreezePanesGallery" size="large" />
	<toggleButton idMso="WindowSplitToggle" />
	<button idMso="WindowHide" />
	<button idMso="WindowUnhide" />
	<separator id="VW1" /> 
	<toggleButton idMso="ViewSideBySide" />
	<toggleButton idMso="WindowSideBySideSynchronousScrolling" />
	<button idMso="WindowResetPosition" />
	<separator id="VW2" /> 
	<button idMso="WindowSaveWorkspace" size="large" />
	<menu idMso="WindowSwitchWindowsMenuExcel" size="large" />
</group> 


Name = GroupMacros

<!-- Add Macros group -->
<group id="DupMacros" label="Macros" insertBeforeMso="GroupMacros" > 
	<splitButton idMso="MenuMacros" size="large" />
</group>