Table 7-1 Data Provider Ribbon Keyboard Equivalents for Excel 2016 (assumes provider ribbon is Alt+Y+2)
| Keys | Action |
|---|---|
| Alt+Y+2+Y+3 | Analyze (Planning) |
| Alt+Y+2+D+R | Refresh |
| Alt+Y+2+D+R+R | Refresh, Refresh |
| Alt+Y+2+D+R+S | Refresh, Refresh All Worksheets |
| Alt+Y+2+Y+4 | POV (Planning) |
| Alt+Y+2+D+O | POV (HFM) |
| Alt+Y+2+D+D | Drill-through |
| Alt+Y+2+A+M | Add Member |
| Alt+Y+2+D+B | Submit Data |
| Alt+Y+2+D+A | Cell Actions (Planning) |
| Alt+Y+2+D+A+E | Cell Actions, Comments (Planning) |
| Alt+Y+2+D+A+P | Cell Actions, Supporting Detail (Planning) |
| Alt+Y+2+D+A+T | Cell Actions, Attachment (Planning) |
| Alt+Y+2+D+A+H | Cell Actions, History |
| Alt+Y+2+D+L | Lock (Planning) |
| Alt+Y+2+D+C | Calculate |
| Alt+Y+2+D+C+B | Calculate, Business Rules (Planning) |
| Alt+Y+2+D+C+U | Calculate, Rules on Form (Planning) |
| Alt+Y+2+D+C+C | Calculate, Calculate (HFM) |
| Alt+Y+2+D+C+F | Calculate, Force Calculate (HFM) |
| Alt+Y+2+D+C+T | Calculate, Translate (HFM) |
| Alt+Y+2+D+C+R | Calculate, Force Translate (HFM) |
| Alt+Y+2+D+C | Consolidate (HFM) |
| Alt+Y+2+D+C+N | Consolidate, Consolidate (HFM) |
| Alt+Y+2+Y+C+S | Consolidate, Consolidate All (HFM) |
| Alt+Y+2+Y+C+L | Consolidate, Consolidate All With Data (HFM) |
| Alt+Y+2+Y+C+A | Consolidate, Calculate Contribution (HFM) |
| Alt+Y+2+Y+C+O | Consolidate, Force Calculate Contribution (HFM) |
| Alt+Y+2+D+E | Cell Comments (HFM) |
| Alt+Y+2+D+U | Adjust |
| Alt+Y+2+D+U+J | Adjust, Adjust (Planning) |
| Alt+Y+2+D+U+G | Adjust, Grid Spread (Planning) |
| Alt+Y+2+D+U+A | Adjust, Mass Allocate (Planning) |
| Alt+Y+2+D+D | Drill-through |
| Alt+Y+2+I | Instructions (HFM) |
| Alt+Y+2+N | Entity Details (HFM) |
| Alt+Y+2+T | Create Journal (HFM) |
| Alt+Y+2+D+M | More (Planning) |
| Alt+Y+2+D+M+J | More, Job Console (Planning) |
| Alt+Y+2+D+M+M | More, Member Formula (Planning) |
| Alt+Y+2+D+M+I | More, Instructions (Planning) |
| Alt+Y+2+D+M+F | More, Offline (Planning) |
| Alt+Y+2+D+M+F+T | More, Offline, Take Offline (Planning) |
| Alt+Y+2+D+M+F+Y | More, Offline, Sync Back to Server (Planning) |
| Alt+Y+2+D+M+F+R | More, Offline, Refresh Offline Definition (Planning) |
| Alt+Y+2+S | Save Formatting (Planning) |
| Alt+Y+2+C | Clear Formatting (Planning) |
| Alt+Y+2+A | Apply Formatting (Planning) |
| Alt+Y+2+A+N | Apply Formatting, None (Planning) |
| Alt+Y+2+A+Y | Apply Formatting, Cell styles (Planning) |
| Alt+Y+2+A+C | Apply Formatting, Custom styles (Planning) |
| Alt+Y+2+A+A | Apply Formatting, Custom and cell styles (Planning) |
| Alt+Y+2+Y+5 | Approvals (Planning) |
| Alt+Y+2+Y+6 | Copy Version (Planning) |