Alt A G on Mac: Group menu in Excel
To open the Group menu with Alt A G in Excel on a Mac, install LightningXL, tap Option, then type A, G. The same keys as Windows, with the same result.
⌥Option
AData
GGroup
Step by step
Install LightningXL
Download LightningXL, then follow the instructions. Setup takes about two minutes.
Select what to act on
Click a cell, or select the range the command should apply to.
Tap Option, then type A G
Tap ⌥ on its own to show the key tips, then A for Data, G for Group. That opens the Group menu; the next key tips show the items in it.
What Alt A G does
Alt A G opens the Group menu on the Data tab of Excel. Type one more key to pick an item:
Related shortcuts
The rest of the Data tab in Excel:
- ⌥AM Remove Duplicates
- ⌥AV Data Validation
- ⌥AN Consolidate
- ⌥AW What-If Analysis
- ⌥AU Ungroup
- ⌥AB Subtotal
- ⌥AJ Show Detail
- ⌥AH Hide Detail
Every Windows shortcut you know, on your Mac
Alt key tips for the Excel, Word and PowerPoint ribbons, plus 100+ of the most common modeling shortcuts.
Coming Soon
7-day free trial · No card required