Table 4-2 Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2007 (assumes Essbase or ad hoc ribbon is Alt+Y)
| Keys | Action |
|---|---|
| Alt+Y+A+Z | Zoom In |
| Alt+Y+A+Z+N | Zoom In, Next Level |
| Alt+Y+A+Z+A | Zoom In, All Levels |
| Alt+Y+A+Z+B | Zoom In, Bottom Level |
| Alt+Y+A+Z+E | Zoom In, Same Level (Essbase only) |
| Alt+Y+A+Z+L | Zoom In, Sibling Level (Essbase only) |
| Alt+Y+A+Z+G | Zoom In, Same Generation (Essbase only) |
| Alt+Y+A+Z+F | Zoom In, Formulas (Essbase only) |
| Alt+Y+A+U | Zoom Out |
| Alt+Y+A+T | Pivot |
| Alt+Y+A+T+P | Pivot, Pivot |
| Alt+Y+A+T+T | Pivot, Pivot to POV |
| Alt+Y+A+K | Keep Only |
| Alt+Y+A+O | Remove Only |
| Alt+Y+A+I | Member Selection |
| Alt+Y+A+Q | Query |
| Alt+Y+A+Q+Q | Query, Query Designer |
| Alt+Y+A+Q+R | Query, Run Report |
| Alt+Y+A+Q+E | Query, Execute MDX (Essbase only) |
| Alt+Y+A+Q+D | Query, Data Filter |
| Alt+Y+A+E | Member Information (Essbase only) |
| Alt+Y+A+P | Preserve Format (except Enterprise Ad Hoc) |
| Alt+Y+A+A | Change Alias (Essbase only) |
| Alt+Y+A+D | Data Perspective (Essbase only) |
| Alt+Y+A+S | Smart Slice (except Enterprise) |
| Alt+Y+A+C | Cascade (except Enterprise Ad Hoc) |
| Alt+Y+A+C+S | Cascade, Same Workbook (except Enterprise Ad Hoc) |
| Alt+Y+A+C+N | Cascade, New Workbook (except Enterprise Ad Hoc) |
| Alt+Y+A+C+D | Cascade, Different Workbooks (except Enterprise Ad Hoc) |
| Alt+Y+I | Insert Attributes (Oracle Essbase and Oracle Planning and Budgeting Cloud only) |
| Alt+Y+D+R | Refresh |
| Alt+Y+D+R+R | Refresh, Refresh |
| Alt+Y+D+R+A | Refresh, Refresh All |
| Alt+Y+D+O | POV |
| Alt+Y+D+W | View Comments |
| Alt+Y+D+C | Calculate |
| Alt+Y+D+Z | Visualize (Essbase only) |
| Alt+Y+D+Z+E | Visualize, Visualize in Excel (Essbase only) |
| Alt+Y+N | Entity Details (Financial Management only) |
| Alt+Y+T | Create Journal (Financial Management only) |
| Alt+Y+D+D | Drill-through |
| Alt+Y+J | Linked Objects (Essbase only) |
| Alt+Y+D+U | Adjust |
| Alt+Y+D+S+B | Submit Data |
| Alt+Y+D+S+W | Submit Data Without Refresh |
| Alt+Y+D+S+R | Submit Data Range |