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


Name : GroupFunctionLibrary

<!-- Add Function Library group -->
<group id="DupFunctionLibrary" label=" Function Library" 
		insertBeforeMso="GroupFunctionLibrary" > 
	<button idMso="FunctionWizard" size="large" />
	<separator id="FF1" /> 
	<splitButton idMso="AutoSumMenu" size="large" />
	<gallery idMso="FunctionsRecentlyUsedtInsertGallery" size="large" />
	<gallery idMso="FunctionsFinancialInsertGallery" size="large" />
	<gallery idMso="FunctionsLogicalInsertGallery" size="large" />
	<gallery idMso="FunctionsTextInsertGallery" size="large" />
	<gallery idMso="FunctionsDateTimeInsertGallery" size="large" />
	<gallery idMso="FunctionsLookupReferenceInsertGallery" size="large" />
	<gallery idMso="FunctionsMathTrigInsertGallery" size="large" />
	<menu idMso="FormulaMoreFunctionsMenu" size="large" />
</group> 


Name = GroupNamedCells

<!-- Add Defined Names group -->
<group id="DupDefinedNames" label="Defined Names" 
		insertBeforeMso="GroupNamedCells" > 
	<button idMso="NameManager" size="large" />
	<splitButton idMso="NameDefineMenu" />
	<gallery idMso="NameUseInFormula" />
	<button idMso="NameCreateFromSelection" />
</group> 


Name = GroupFormulaAuditing

<!-- Add FormulaAuditing group -->
<group id="DupFormulaAuditing" label="Formula Auditing" 
		insertBeforeMso="GroupFormulaAuditing" > 
	<button idMso="TracePrecedents" />
	<button idMso="TraceDependents" />
	<splitButton idMso="TraceRemoveArrowsMenu" />
	<toggleButton idMso="ShowFormulas" />
	<splitButton idMso="ErrorCheckingMenu" />
	<button idMso="FormulaEvaluate" />
	<separator id="FFA1" /> 
	<toggleButton idMso="WatchWindow" size="large" />
</group> 


Name = GroupCalculation


<!-- Add Calculation Options group -->
<group id="DupCalculation" label="Calculation" 
		insertBeforeMso="GroupCalculation" > 
	<menu idMso="CalculationOptionsMenu" size="large" /> 
	<button idMso="CalculateNow"  />
	<button idMso="CalculateSheet"  /> 
</group>