Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Control idMso's of the Mac Excel 2016 Ribbon

If this is all new for you read the information on this page first : Change the Ribbon in Mac Excel 2016, you will also find example files on that page.

If you want to hide, disable, add or do other things with controls with RibbonX you must know the idMso of it, below you can find allmost all the control idMso's of the Excel 2016 for Mac Ribbon. Note : Not all controls in the Mac Excel 2016 Ribbon have a idMso.

Visit this page for the information that Microsoft have published : https://msdn.microsoft.com/en-us/library/office/mt654022.aspx

 

Example files

Download dmg file : With files with the RibbonX below to find the idMso Names of each control in the Mac Excel Ribbon

 

idMso Names of each control in the Mac Excel Ribbon

The RibbonX below will hide each built-in group on the Ribbon and duplicate it as a example. This way you can find the idMso of each Tab, group and control below.

 

Home tab

<!-- Hide all Built-in groups on the Home tab in Mac Excel 2016 -->
<!-- Duplicate every group that is on the Home tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the Home tab-->
<tab idMso="TabHome"> 
<group idMso="GroupClipboard" visible="false"/> 
<group idMso="GroupFont" visible="false"/> 
<group idMso="GroupAlignmentExcel" visible="false"/> 
<group idMso="GroupNumber" visible="false"/> 
<group idMso="GroupStyles" visible="false"/> 
<group idMso="GroupCells" visible="false"/> 
<group idMso="GroupEditingExcel" 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" >
	<!-- No idMso for Paste on this moment-->
	<!-- <splitButton idMso="PasteMenu" size="large" /> -->
	<button idMso="Cut"/>
	<splitButton idMso="CopySplitButton"/>
	<control idMso="FormatPainter"/> 
</group> 


<!-- Add Font group -->
<group id="DupFont" label="Font" insertBeforeMso="GroupFont" >  
	<box id="HF1" boxStyle="horizontal"> 
	<control 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>
</group> 


<!-- 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"/>
</group> 


<!-- 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>
</group> 


<!-- 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> 


<!-- 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> 


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


</tab> 
</tabs> 
</ribbon> 
</customUI>

 

Insert tab

<!-- Hide all Built-in groups on the Insert tab in Mac Excel 2016 -->
<!-- Duplicate every group that is on the Insert tab -->
<!-- Note there are a lot of missing idMso's on this tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the Insert tab-->
<tab idMso="TabInsert"> 
<group idMso="GroupInsertTablesExcel" visible="false"/> 
<group idMso="GroupInsertIllustrations" visible="false"/> 
<group idMso="GroupInsertChartsExcel" visible="false"/>
<group idMso="GroupSparklinesInsert" visible="false"/>
<group idMso="GroupSlicerInsert" visible="false"/> 
<group idMso="GroupInsertLinks" visible="false"/> 
<group idMso="GroupComments" visible="false"/> 
<group idMso="GroupInsertText" visible="false"/>
<group idMso="GroupInsertSymbols" visible="false"/> 
</tab>


<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabInsert"> 


<!-- Add Tables group -->
<!-- There is no idMso for Recommended PivotTables -->
<group id="DupTables" label="Tables" insertBeforeMso="GroupInsertTablesExcel" > 
	<button idMso="PivotTableInsert" size="large" />
	<button idMso="TableInsertExcel" size="large" />
</group> 


<!-- Add Illustrations group -->
<!-- No idMso for Pictures, add Picture from file instead-->
<group id="DupIllustrations" label="Illustrations" insertBeforeMso="GroupInsertIllustrations" > 
	<button idMso="PictureInsertFromFile" size="large" />
	<gallery idMso="ShapesInsertGallery" size="large" />
	<menu idMso="SmartArtInsert" size="large" />
</group> 


<!-- Add Charts group -->
<!-- Two missing controls in the Charts group -->
<group id="DupCharts" label="Charts" insertBeforeMso="GroupInsertChartsExcel" > 
<buttonGroup id="ICButtonGroup1"> 
	<gallery idMso="ChartTypeColumnInsertGallery" />
	<gallery idMso="ChartTypeBarInsertGallery"  />
	<gallery idMso="ChartTypePieInsertGallery"  />
</buttonGroup> 

<buttonGroup id="ICButtonGroup2"> 
	<gallery idMso="ChartTypeLineInsertGallery" />
	<gallery idMso="ChartTypeXYScatterInsertGallery"  />
</buttonGroup> 
</group> 


<!-- Sparklines group, there is no idMso of the control on it -->


<!-- Add Filters group -->
<group id="DupFilters" label="Filters" insertBeforeMso="GroupSlicerInsert" > 
	<button idMso="SlicerInsert" size="large" />
</group> 


<!-- Add Comments group -->
<group id="DupComments" label="Comments" insertBeforeMso="GroupComments" > 
	<button idMso="ReviewNewComment" size="large" />
</group> 


<!-- Add Links group -->
<group id="DupLinks" label="Links" insertBeforeMso="GroupInsertLinks" > 
	<button idMso="HyperlinkInsert" size="large" /> 
</group> 


<!-- Add Text group -->
<group id="DupText" label="Text" insertBeforeMso="GroupInsertText" > 
	<toggleButton idMso="TextBoxInsertExcel" size="large" />
	<button idMso="HeaderFooterInsert" size="large" />
	<gallery idMso="WordArtInsertGallery" size="large" />
	<button idMso="OleObjectctInsert" size="large" />
</group> 


<!-- Add Symbols group -->
<!-- There is no idMso for Symbol -->
<group id="DupSymbols" label="Symbols" insertBeforeMso="GroupInsertSymbols" > 
	<gallery idMso="InsertBuildingBlocksEquationsGallery" size="large" />
</group> 


</tab> 
</tabs> 
</ribbon> 
</customUI>

 

Page Layout tab

<!-- Hide all Built-in groups on the Page Layout tab in Mac Excel 2016 -->
<!-- Duplicate every group that is on the Page Layout tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the Page Layout tab-->
<tab idMso="TabPageLayoutExcel"> 
<group idMso="GroupThemesExcel" visible="false"/> 
<group idMso="GroupPageSetup" visible="false"/> 
<group idMso="GroupPageLayoutScaleToFit" visible="false"/> 
<group idMso="GroupPageLayoutSheetOptions" visible="false"/> 
</tab>


<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabPageLayoutExcel"> 


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


<!-- 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" />
	<!-- Printtitles do not open the PageSetup dialog-->
	<button idMso="PrintTitles" size="large" />
	<!-- no idMso for Page Setup, but Printtitles opens the same dialog-->
</group> 


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


<!-- 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"  /> 
</group> 


</tab> 
</tabs> 
</ribbon> 
</customUI>

 

Formulas tab

<!-- Hide all Built-in groups on the Formulas tab in Mac Excel 2016-->
<!-- Duplicate every group that is on the Formulas tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the Data tab-->
<tab idMso="TabFormulas"> 
<group idMso="GroupFunctionLibrary" visible="false"/> 
<group idMso="GroupNamedCells" visible="false"/> 
<group idMso="GroupFormulaAuditing" visible="false"/> 
<group idMso="GroupCalculation" visible="false"/> 
</tab>


<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabFormulas"> 


<!-- 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> 


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


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


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


</tab> 
</tabs> 
</ribbon> 
</customUI>

 

Data tab

<!-- Hide all Built-in groups on the Data tab in Mac Excel 2016-->
<!-- Duplicate every group that is on the Data tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the Data tab-->
<tab idMso="TabData"> 
<group idMso="GroupGetExternalData" visible="false"/> 
<group idMso="GroupConnections" visible="false"/> 
<group idMso="GroupSortFilter" visible="false"/> 
<group idMso="GroupDataTools" visible="false"/>
<group idMso="GroupOutline" visible="false"/> 
</tab>


<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabData"> 


<!-- Add Get External Data group -->
<group id="DupGetExternalData" label="Get External Data*" insertBeforeMso="GroupGetExternalData" > 
<!-- Missing 3 controls on the Get External Data tab-->
	<button idMso="GetExternalDataFromText" size="large" />
</group> 


<!-- Add Connections group -->
<group id="DupConnections" label="Connections" insertBeforeMso="GroupConnections" > 
	<splitButton idMso="RefreshAllMenu" size="large" />
	<button idMso="Connections" />
	<button idMso="DataRangeProperties" />
	<button idMso="EditLinks" />
</group> 


<!-- Add Sort & Filter group -->
<group id="DupSortFilter" label="Sort &amp;&amp; Filter" insertBeforeMso="GroupSortFilter" >
	<button idMso="SortAscendingExcel" showLabel="false" />
	<button idMso="SortDescendingExcel" showLabel="false" />
	<button idMso="SortDialog" size="large" />
	<separator id="DS1" /> 
	<toggleButton idMso="Filter" size="large" />
	<button idMso="SortClear" />
	<button idMso="FilterReapply" />
	<button idMso="AdvancedFilterDialog" />
</group> 


<!-- Add Data Tools Options group -->
<group id="DupDataTools" label="Data Tools" insertBeforeMso="GroupDataTools" > 
	<button idMso="ConvertTextToTable" size="large" />
	<button idMso="RemoveDuplicates" size="large" /> 
	<splitButton idMso="DataValidationMenu" size="large" /> 
	<button idMso="Consolidate" size="large" />
	<menu idMso="WhatIfAnalysisMenu" size="large" />  
</group> 


<!-- Add Outline group -->
<group id="DupOutline" label="Outline" insertBeforeMso="GroupOutline" > 
	<splitButton idMso="OutlineGroupMenu" size="large" /> 
	<splitButton idMso="OutlineUngroupMenu" size="large" /> 
	<button idMso="OutlineSubtotals" size="large" /> 
	<button idMso="OutlineShowDetail" /> 
	<button idMso="OutlineHideDetail" /> 
</group> 


</tab> 
</tabs> 
</ribbon> 
</customUI>

 

Review tab

<!-- Hide all Built-in groups on the Review tab in Mac Excel 2016 -->
<!-- Duplicate every group that is on the Review tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the Review tab-->
<tab idMso="TabReview"> 
<group idMso="GroupProofing" visible="false"/>
<group idMso="GroupComments" visible="false"/>
<group idMso="GroupChangesExcel" visible="false"/>
<group idMso="GroupRightsManagement" visible="false"/>   
</tab>


<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabReview"> 


<!-- Add Proofing group -->
<group id="DupProofing" label="Proofing*" insertBeforeMso="GroupProofing" > 
	<button idMso="Spelling" size="large" />
	<button idMso="Thesaurus" size="large" />
</group> 


<!-- Add Comments group -->
<group id="DupComments" label="Comments" insertBeforeMso="GroupComments" > 
	<button idMso="ReviewNewComment" size="large" />
	<button idMso="ReviewDeleteComment" size="large" />
	<button idMso="ReviewPreviousComment" size="large" />
	<button idMso="ReviewNextComment" size="large" />
	<button idMso="ReviewShowOrHideComment" />
	<toggleButton idMso="ReviewShowAllComments" />
</group> 


<!-- Add Changes group -->
<group id="DupChanges" label="Changes" insertBeforeMso="GroupChangesExcel" > 
	<button idMso="SheetProtect" size="large" />
	<toggleButton idMso="ReviewRestrictEditing" size="large" />	
	<button idMso="ReviewShareWorkbook" size="large" />
	<button idMso="ReviewProtectAndShareWorkbook" />
	<menu idMso="ReviewTrackChangesMenu" />
</group> 


<!-- Add Permission group -->
<group id="DupPermission" label="Permission" insertBeforeMso="GroupRightsManagement" > 
	<menu idMso="FilePermissionRestrictMenu" />
</group> 


</tab> 
</tabs> 
</ribbon> 
</customUI>

 

View tab

<!-- Hide all Built-in groups on the View tab in Excel Mac 2016 -->
<!-- Duplicate every group that is on the View tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the View tab-->
<tab idMso="TabView"> 
<group idMso="GroupWorkbookViews" visible="false"/> 
<group idMso="GroupViewShowHide" visible="false"/> 
<group idMso="GroupZoom" visible="false"/> 
<group idMso="GroupWindow" visible="false"/>
<group idMso="GroupMacros" visible="false"/> 
</tab>


<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabView"> 


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


<!-- Add Show group -->
<group id="DupShowHide" label="Show" insertBeforeMso="GroupViewShowHide" > 
	<box id="SH1" boxStyle="horizontal"> 
	<checkBox idMso="ViewRulerExcel" />
	<checkBox idMso="ViewFormulaBar" />
	</box>

	<box id="SH2" boxStyle="horizontal"> 
	<checkBox idMso="GridlinesExcel" />
	<checkBox idMso="ViewHeadings" />
	</box> 
</group> 


<!-- Add Zoom group -->
<group id="DupZoom" label="Zoom" insertBeforeMso="GroupZoom" > 
	<control idMso="ZoomClassic" />	
	<button idMso="ZoomCurrent100" />
</group> 


<!-- Add Window group -->
<group id="DupWindow" label="Window" insertBeforeMso="GroupWindow" >
<!-- Two missing idMso's in the Window group -->
	<toggleButton idMso="FreezePanes" size="large" /> 
	<control idMso="WindowSplitToggle" size="large" />
</group> 


<!-- Add Macros group -->
<group id="DupMacros" label="Macros" insertBeforeMso="GroupMacros" > 
	<button idMso="MacroPlay" size="large" />
	<button idMso="MacroRecord" size="large" />
</group> 


</tab> 
</tabs> 
</ribbon> 
</customUI>

 

Developer tab

<!-- Hide all Built-in groups on the Developer tab in Mac Excel 2016-->
<!-- Duplicate every group that is on the Developer tab -->

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon> 
<tabs>

<!-- Set visible to false for all groups on the Developer tab-->
<tab idMso="TabDeveloper"> 
<group idMso="GroupCodeEditor" visible="false"/>
<group idMso="GroupCode" visible="false"/>
<group idMso="GroupAddins" visible="false"/> 
<group idMso="GroupControls" visible="false"/>  
</tab>


<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabDeveloper"> 


<!-- Add Code Editor group -->
<group id="DupCodeEditor" label="Code Editor" insertBeforeMso="GroupCodeEditor" > 
	<button idMso="VisualBasic" size="large" />
</group> 


<!-- Add Code group -->
<group id="DupCode" label="Code" insertBeforeMso="GroupCode" > 
	<button idMso="MacroPlay" size="large" />
	<button idMso="MacroRecord" size="large" />
</group> 


<!-- Add Add-ins group -->
<group id="DupAddins" label="Add-ins" insertBeforeMso="GroupAddins" > 
	<button idMso="AddInManager" size="large" />
</group> 


<!-- Add Controls group -->
<group id="DupControls" label="Controls" insertBeforeMso="GroupControls" > 
	<button idMso="FormControlButton" size="large" />
	<button idMso="FormControlGroupBox" size="large" />
	<button idMso="FormControlComboBox" size="large" />
	<button idMso="FormControlLabel" size="large" />
	<button idMso="FormControlCheckBox" size="large" />
	<button idMso="FormControlScrollBar" size="large" />
	<button idMso="FormControlListBox" size="large" />
	<button idMso="FormControlRadioButton" size="large" />
	<button idMso="FormControlSpinner" size="large" />
</group> 


</tab> 
</tabs> 
</ribbon> 
</customUI>