Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Tab and Group idMso's of the Mac Excel 365 Ribbon

If this is all new for you read the information on this page first : Change the Ribbon in Mac Excel 2016 and up, you will also find a few 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 365 for Mac Ribbon.

If you also want to know the idMso's of the controls visit this page, will update this page also soon for Mac Excel 365 : 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 files

Download example files : The RibbonX in this two files will hide every group on every tab in the Mac Excel 365 Ribbon or hide each tab in the Mac Excel 365 ribbon. This way you can find the idMso's names of the built-in tabs/groups in the Mac Excel 365 Ribbon. You can see the RibbonX also below on this webpage, files updated on 1-Nov-2020

Note: I can't find the idMso for the Analysis group on the Data tab on this moment.

Note: Normal if you want to hide everything you can also use StartFromScratch in the RibbonX but StartFromScratch is not working on the Mac, only in Win Office.

 

Tab idMso's of the Excel 365 for Mac Ribbon

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

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

 

Hide every tab on the Mac Excel 365 for Mac Ribbon

You can find RibbonX below that hide each tab in the Ribbon of Mac Excel 365. This example shows you the names of each tab. You can also download a file with the RibbonX below in the Example file section on top of this page.

<!-- Hide all Built-in Tabs in Mac Excel 365-->
<!-- You can find the idMso for each Tab in the Ribbonx below-->

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

<!-- Set visible to false for the Home tab-->
<tab idMso="TabHome" visible="false"/>  

<!-- Set visible to false for the Insert tab-->
<tab idMso="TabInsert" visible="false"/>   

<!-- Set visible to false for the Draw tab-->
<tab idMso="TabDrawInk" visible="false"/>   

<!-- Set visible to false for the Page Layout tab-->
<tab idMso="TabPageLayoutExcel" visible="false"/>   

<!-- Set visible to false for the Formulas tab-->
<tab idMso="TabFormulas" visible="false"/> 

<!-- Set visible to false for the Data tab-->
<tab idMso="TabData" visible="false"/>   

<!-- Set visible to false for the Review tab-->
<tab idMso="TabReview" visible="false"/>  

<!-- Set visible to false for the View tab-->
<tab idMso="TabView" visible="false"/>   

<!-- Set visible to false for the Developer tab-->
<tab idMso="TabDeveloper" visible="false"/>   

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

 

hide every group on each tab on the Mac Excel 365 for Mac Ribbon

You can find RibbonX below that hide each group on every tab in the Mac Excel 365 ribbon. This example shows you the names of each group. You can also download a file with the RibbonX below in the Example file section on top of this page.

<!-- Hide all Built-in groups in Mac Excel 365-->
<!-- 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"/> 
<group idMso="GroupIdeas" visible="false"/> 
</tab>


<!-- Set visible to false for all groups on the Insert tab-->
<tab idMso="TabInsert"> 
<group idMso="GroupInsertTablesExcel" visible="false"/> 
<group idMso="GroupDataFromPicture" 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="GroupThreadedComments" visible="false"/> 
<group idMso="GroupInsertText" visible="false"/>
<group idMso="GroupInsertSymbols" visible="false"/> 
</tab>


<!-- Set visible to false for all groups on the Draw tab-->
<tab idMso="TabDrawInk"> 
<group idMso="GroupWrite" visible="false"/>
<group idMso="GroupPensOneNote" visible="false"/> 
<group idMso="GroupInkModes" 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="GroupLinkedEntityConvert" visible="false"/> 
<group idMso="GroupSortFilter" visible="false"/> 
<group idMso="GroupDataTools" visible="false"/>
<group idMso="GroupForecast" 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"/>
<group idMso="GroupAccessibility" visible="false"/>
<group idMso="GroupInsights" visible="false"/> 
<group idMso="GroupLanguage" visible="false"/>
<group idMso="GroupThreadedComments" visible="false"/>
<group idMso="GroupCommentsLegacy" visible="false"/>
<group idMso="GroupChangesExcel" visible="false"/>
<group idMso="GroupProtect" visible="false"/>
<group idMso="GroupInk" visible="false"/>   
</tab>


<!-- Set visible to false for all groups on the View tab-->
<tab idMso="TabView"> 
<group idMso="GroupNamedSheetView" visible="false"/> 
<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="GroupCode" visible="false"/>
<group idMso="GroupAddins" visible="false"/> 
<group idMso="GroupControls" visible="false"/> 
</tab>


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