To do Alt + D G on Mac in Excel, install Accelerator Keys, then press Option, then D, then G. It opens the Excel 2003 Data > Group and Outline menu. Then press the next letter, such as H for Hide Detail.
If you are looking for the Alt + D G shortcut on Mac Excel, you may know it from Excel 2003, where Alt + D opened the Data menu. Windows Excel still accepts these menu keys. With Accelerator Keys, they work on your Mac too.
Alt + D + G is the legacy shortcut for the Data > Group and Outline menu. From there you group and ungroup rows or columns, show or hide detail, and build or clear an outline.
Excel for Mac keeps the Data menu in the macOS menu bar. Accelerator Keys opens Data > Group and Outline and shows the Windows letter on each item. Then you press the next letter, the same as on Windows. It works on any ribbon tab and at any window width.
| Shortcut | Command | Modern Equivalent |
|---|---|---|
| Alt + D + G + H | Hide Detail | Alt + A + H |
| Alt + D + G + S | Show Detail | Alt + A + J |
| Alt + D + G + G | Group | Alt + A + G + G |
| Alt + D + G + U | Ungroup | Alt + A + U + U |
| Alt + D + G + A | Auto Outline | Alt + A + G + A |
| Alt + D + G + C | Clear Outline | Alt + A + U + C |
| Alt + D + G + E | Outline Settings | — |
Then press the next letter from the table above. Press Esc to close the menu.
No. Excel for Mac’s own KeyTips do not support the legacy Alt + E, Alt + I, Alt + O, and Alt + D menu keys. Accelerator Keys adds them. Press Option, then D, then G.
Press H (Hide Detail), S (Show Detail), G (Group), U (Ungroup), A (Auto Outline), C (Clear Outline), E (Outline Settings).