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