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