Table 23 lists the keyboard equivalents on data provider ribbons. Table 24 lists the keyboard equivalents for items only on the Essbase, Planning Ad Hoc, HFM Ad Hoc, and Enterprise Ad Hoc ribbons. Exceptions are noted in parentheses.
Table 23. Data Provider Ribbon Keyboard Equivalents for Excel
| Ribbon Item | Key |
|---|---|
| Analyze (Planning only) | Alt+Y+Y |
| Refresh | Alt+Y+D+R |
| Refresh, Refresh | Alt+Y+D+R+R |
| Refresh, Refresh All | Alt+Y+D+R+A |
| Drill-through | Alt+Y+D+D |
| Add Member | Alt+Y+A+M |
| Submit Data | Alt+Y+D+B |
| Cell Comments | Alt+Y+D+E |
| Supporting Detail (Planning only) | Alt+Y+D+P |
| Document Attachment (Planning only) | Alt+Y+D+T |
| Lock (Planning only) | Alt+Y+D+L |
| Calculate | Alt+Y+D+C |
| Calculate, Business Rules (Planning only) | Alt+Y+D+C+B |
| Calculate, Rules on Form (Planning only) | Alt+Y+D+C+U |
| Calculate, Calculate | Alt+Y+D+C+D |
| Calculate, Force Calculate (HFM and Enterprise only) | Alt+Y+D+C+F |
| Calculate, Translate (HFM and Enterprise only) | Alt+Y+D+C+T |
| Calculate, Force Translate (HFM and Enterprise only) | Alt+Y+D+C+R |
| Consolidate (HFM and Enterprise only) | Alt+Y+D+O |
| Consolidate, Consolidate (HFM and Enterprise only) | Alt+Y+D+O+N |
| Consolidate, Consolidate All (HFM and Enterprise only) | Alt+Y+D+O+S |
| Consolidate, Calculate Contribution (HFM and Enterprise only) | Alt+Y+D+O+A |
| Consolidate, Force Calculate Contribution (HFM only) | Alt+Y+D+O+O |
| Consolidate, Consoildate All With Data (HFM and Enterprise only) | Alt+Y+D+O+L |
| View Comments | Alt+S+W |
| Adjust | Alt+Y+D+U |
| Adjust, Adjust | Alt+Y+D+U+J |
| Adjust, Grid Spread (Planning only) | Alt+Y+D+U+G |
| Adjust, Mass Allocate (Planning only) | Alt+Y+D+U+A |
| Drill-through | Alt+Y+D+D |
| More (Planning only) | Alt+Y+D+M |
| More, Job Console (Planning only) | Alt+Y+D+M+J |
| More, Member Formula (Planning only) | Alt+Y+D+M+M |
| More, Instructions (Planning only) | Alt+Y+D+M+I |
| More, Offline (Planning only) | Alt+Y+D+M+F |
| More, Offline, Take Offline (Planning only) | Alt+Y+D+M+F+T |
| More, Offline, Sync Back to Server (Planning only) | Alt+Y+D+M+F+Y |
| More, Offline, Refresh Offline Definition (Planning only) | Alt+Y+D+M+F+R |
| Manage Process (Planning only) | Alt+Y+W+P |
| Copy Version (Planning only) | Alt+Y+W+V |
Table 24. Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel
| Ribbon Item | Key |
|---|---|
| Zoom In | Alt+Y+A+Z |
| Zoom In, Next Level | Alt+Y+A+Z+N |
| Zoom In, All Levels | Alt+Y+A+Z+A |
| Zoom In, Bottom Level | Alt+Y+A+Z+B |
| Zoom In, Same Level (Essbase only) | Alt+Y+A+Z+E |
| Zoom In, Sibling Level (Essbase only) | Alt+Y+A+Z+L |
| Zoom In, Same Generation (Essbase only) | Alt+Y+A+Z+G |
| Zoom In, Formulas (Essbase only) | Alt+Y+A+Z+F |
| Zoom Out | Alt+Y+A+U |
| Pivot | Alt+Y+A+T |
| Pivot, Pivot | Alt+Y+A+T+P |
| Pivot Pivot to POV | Alt+Y+A+T+T |
| Keep Only | Alt+Y+A+K |
| Remove Only | Alt+Y+A+O |
| Member Selection | Alt+Y+A+I |
| Query | Alt+Y+A+Q |
| Query, Query Designer | Alt+Y+A+Q+Q |
| Query, Run Report | Alt+Y+A+Q+R |
| Query, Execute MDX (Essbase only) | Alt+Y+A+Q+E |
| Query, Data Filter | Alt+Y+A+Q+D |
| Member Information (Essbase only) | Alt+Y+A+E |
| Preserve Format (except Enterprise Ad Hoc) | Alt+Y+A+P |
| Change Alias (Essbase only) | Alt+Y+A+A |
| Data Perspective (Essbase only) | Alt+Y+A+D |
| Smart Slice (except Enterprise) | Alt+Y+A+S |
| Cascade (except Enterprise Ad Hoc) | Alt+Y+A+C |
| Cascade, Same Workbook (except Enterprise Ad Hoc) | Alt+Y+A+C+S |
| Cascade, New Workbook (except Enterprise Ad Hoc) | Alt+Y+A+C+N |
| Refresh | Alt+Y+D+R |
| Refresh, Refresh | Alt+Y+D+R+R |
| Refresh, Refresh All | Alt+Y+D+R+A |
| POV | Alt+Y+D+P |
| View Comments | Alt+Y+D+W |
| Calculate | Alt+Y+D+C |
| Visualize (Essbase only) | Alt+Y+D+V |
| Visualize, Visualize in Excel (Essbase only) | Alt+Y+D+V+E |
| Drill-through | Alt+Y+D+D |
| Linked Objects (Essbase only) | Alt+Y+J |
| Adjust | Alt+Y+D+U |
| Submit Data | Alt+Y+D+B |