To do Alt + D G A on Mac in Excel, install Accelerator Keys, then press Option, then D, then G, then A. It runs the Excel 2003 command Data > Group and Outline > Auto Outline. The modern ribbon shortcut is Alt + A + G + A.
If you are looking for the Alt + D G A 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 + A is the legacy shortcut for Data > Group and Outline > Auto Outline. It builds an outline for you. Excel finds the summary rows and columns that use formulas, such as SUM, and groups the detail under them.
| Shortcut | Era | Menu Path |
|---|---|---|
| Alt + D + G + A | Legacy (Excel 2003) | Data > Group and Outline > Auto Outline |
| Alt + A + G + A | Modern (Ribbon) | Data > Group > Auto Outline |
Both shortcuts work with Accelerator Keys.
On your Mac, Accelerator Keys runs Data > Group and Outline > Auto Outline 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 A.
The modern ribbon shortcut is Alt + A + G + A (Data > Group > Auto Outline). Both work on Mac with Accelerator Keys.