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