Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Tab and Group 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 tabs and groups with RibbonX you must know the idMso of it, below you can find all the tab and group idMso's of the Excel 2016 for Mac Ribbon. If you also want to know the idMso's of the controls visit this page : Control idMso's of the Mac Excel 2016 Ribbon

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

 

Example file

Download example file : With the RibbonX below to find the idMso's names of the built-in tabs/groups in the Mac Excel 2016 Ribbon, updated 19-Nov-2016

 

Tab idMso's of the Excel 2016 for Mac Ribbon

There are 8 tabs in the Mac Excel Ribbon that can be visible, below are the idMso's of the 8 tabs.

  1. TabHome
  2. TabInsert
  3. TabPageLayoutExcel
  4. TabFormulas
  5. TabData
  6. TabReview
  7. TabView
  8. TabDeveloper

 

Group idMso's of the Excel 2016 for Mac Ribbon

You can find RibbonX below that hide each group in the Ribbon of Mac Excel 2016. This example shows you the names of each group. Normal if you want to hide everything you can also hide complete tabs or use StartFromScratch in the RibbonX but for learning the group names I choose for this example. You can also download a file with the RibbonX below in the Example file section on top of this page.

The only one I can't find on this moment is the Document group on the Review tab

If you find the name please let me know so I can update the page

<!-- Hide all Built-in groups in Mac Excel 2016-->
<!-- You can find the idMso for each group in the Ribbonx below-->

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


<!-- 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="GroupOfficeExtension" 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>


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


<!-- Set visible to false for all groups on the Formulas 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>


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


<!-- Set visible to false for all groups on the Review tab-->
<tab idMso="TabReview">
<group idMso="GroupProofing" visible="false"/>
<!-- Document group is not working with GroupAccessibility-->
<group idMso="GroupAccessibility" visible="false"/>
<group idMso="GroupDocumentExcel" visible="false"/> 
<group idMso="GroupComments" visible="false"/>
<group idMso="GroupChangesExcel" visible="false"/>
<group idMso="GroupRightsManagement" visible="false"/>   
</tab>


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


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


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