Table 20 lists the keyboard equivalents on data provider ribbons. Table 21 lists the keyboard equivalents for items only on the Essbase, Planning Ad Hoc, HFM Ad Hoc, Enterprise Ad Hoc and OBIEE ribbons. Exceptions are noted in parentheses.
Table 20. 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 21. Essbase, OBIEE, 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 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 |
| View Qualified Name | Alt+Y+A+N |
| 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 |
| Vizualize (Essbase only) | Alt+Y+D+V |
| Vizualize, Vizualize in HVE (Essbase only) | Alt+Y+D+V+H |
| Vizualize, Visualize in Excel (Essbase and OBI EE only) | Alt+Y+D+V+E |
| Drill-through | Alt+Y+D+D |
| Adjust | Alt+Y+D+U |
| Submit Data | Alt+Y+D+B |