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