To do Alt + D G E on Mac in Excel, install Accelerator Keys, then press Option, then D, then G, then E. It runs the Excel 2003 command Data > Group and Outline > Settings.
If you are looking for the Alt + D G E 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 + E is the legacy shortcut for Data > Group and Outline > Settings. It opens the Settings dialog for outlines. You choose if summary rows are below the detail and if summary columns are to the right of the detail. You can also apply automatic styles.
On your Mac, Accelerator Keys runs Data > Group and Outline > Settings in the Excel menu bar. It works on any ribbon tab and at any window width.
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, then E.