Tab and Group idMso's

If this is all new for you read the information on this page first : Change the Ribbon, 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 : Ribbon Control idMso's

Tab idMso's of the Excel 365 Ribbon

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.

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

  • TabHome
  • TabInsert
  • TabDrawInk
  • TabPageLayoutExcel
  • TabFormulas
  • TabData
  • TabReview
  • TabView
  • TabDeveloper

Hide tab on the Mac Excel 365 for Mac Ribbon


To hide for example the Draw tab you can use the RibbonX below in your file


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

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

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

Example to 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.

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


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

Problems with groups in RibbonX in the Mac Excel 365 for Mac Ribbon

In the example files you can download on the Ribbon Start page you see that I show you that you can add built-in groups to your own custom tab. In Excel for Windows there is no problem but in Mac Excel there are a lot of groups that you can't add to your custom tab. For example if you check the Home tab the first four groups you can't add to a custom tab. If you test the RibbonX below you will notice that your custom tab named Favorite Groups not show you the first four groups but only the last four. And the idMso is correct because you can hide the group.


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

<tab id="customTab" label="Favorite Groups" insertAfterMso="TabHome">

<group idMso="GroupClipboard" />
<group idMso="GroupFont" />
<group idMso="GroupAlignmentExcel" />
<group idMso="GroupNumber" />
<group idMso="GroupStyles" />
<group idMso="GroupCells" />
<group idMso="GroupEditingExcel"/>
<group idMso="GroupIdeas" />

</tab>

</tabs>
</ribbon>
</customUI>
10-February-2021
Web design by Will Woodgate