Table 7-2 Essbase and Ad Hoc Ribbon Keyboard Equivalents for Excel 2016 (assumes Essbase or ad hoc ribbon is Alt+Y+2)
Keys | Action |
---|---|
Alt+Y+2+A+Z | Zoom In (Essbase, Oracle Analytics Cloud - Essbase, and HFM) |
Alt+Y+2+Y+3 | Zoom in (Planning) |
Alt+Y+2+A+Z+N | Zoom In, Next Level (Essbase, Oracle Analytics Cloud - Essbase, and HFM) |
Alt+Y+2+Y+3+N | Zoom In, Next Level (Planning) |
Alt+Y+2+A+Z+A | Zoom In, All Levels (Essbase, Oracle Analytics Cloud - Essbase, and HFM) |
Alt+Y+2+Y+3+A | Zoom In, All Levels (Planning) |
Alt+Y+2+A+Z+B | Zoom In, Bottom Level (Essbase, Oracle Analytics Cloud - Essbase, and HFM) |
Alt+Y+2+Y+3+B | Zoom In, Bottom Level (Planning) |
Alt+Y+2+A+Z+E | Zoom In, Same Level (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+A+Z+L | Zoom In, Sibling Level (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+A+Z+G | Zoom In, Same Generation (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+A+Z+F | Zoom In, Formulas (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+A+U | Zoom Out (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+4 | Zoom Out (Planning) |
Alt+Y+2+A+T | Pivot (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+5 | Pivot (Planning) |
Alt+Y+2+A+T+P | Pivot, Pivot (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+5+P | Pivot, Pivot (Planning) |
Alt+Y+2+A+T+T | Pivot, Pivot to POV (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+5+T | Pivot, Pivot to POV (Planning) |
Alt+Y+2+A+K | Keep Only (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+6 | Keep Only (Planning) |
Alt+Y+2+A+O | Remove Only (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+7 | Remove Only (Planning) |
Alt+Y+2+Y+7 | Member Selection |
Alt+Y+2+A+Q | Query (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+9 | Query (Planning) |
Alt+Y+2+A+Q+Q | Query, Query Designer (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+9+Q | Query, Query Designer (Planning) |
Alt+Y+2+A+Q+R | Query, Run Report (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+9+R | Query, Run Report (Planning) |
Alt+Y+2+A+Q+E | Query, Execute MDX (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+A+Q+D | Query, Data Filter (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+9+D | Query, Data Filter (Planning) |
Alt+Y+2+A+E | Member Information (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+A+P | Preserve Format (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+Y+A | Preserve Format (Planning) |
Alt+Y+2+A+A | Change Alias (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+Y+B | Change Alias (Planning) |
Alt+Y+2+A+D | Data Perspective (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+A+S | Smart Slice (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+C | Smart Slice (Planning) |
Alt+Y+2+Y+D | Save Ad Hoc Grid (Planning) |
Alt+Y+2+Y+E | Save As Smart Form (Planning) |
Alt+Y+2+A+C | Cascade (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+F | Cascade (Planning) |
Alt+Y+2+A+C+S | Cascade, Same Workbook (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+F+S | Cascade, Same Workbook (Planning) |
Alt+Y+2+A+C+N | Cascade, New Workbook (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+F+N | Cascade, New Workbook (Planning) |
Alt+Y+2+A+C+D | Cascade, Different Workbooks (Essbase, Oracle Analytics Cloud - Essbase, HFM) |
Alt+Y+2+Y+F+D | Cascade, Different Workbooks (Planning) |
Alt+Y+2+I | Insert Attributes (Essbase, Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud) |
Alt+Y+2+D+R | Refresh |
Alt+Y+2+D+R+R | Refresh, Refresh |
Alt+Y+2+D+R+S | Refresh, Refresh All Worksheets |
Alt+Y+2+D+O | POV (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+Y+G | POV (Planning) |
Alt+Y+2+Y+3 | POV (HFM) |
Alt+Y+2+D+A | Cell Actions (Planning) |
Alt+Y+2+D+A+E | Cell Actions, Comments (Planning) |
Alt+Y+2+D+A+P | Cell Actions, Supporting Details (Planning) |
Alt+Y+2+D+A+T | Cell Actions, Attachment (Planning) |
Alt+Y+2+D+A+H | Cell Actions, History (Planning) |
Alt+Y+2+D+W | View Comments (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+D+C | Calculate |
Alt+Y+2+D+C+B | Calculate, Business Rules (Planning) |
Alt+Y+2+D+C+U | Calculate, Rules on Form (Planning) |
Alt+Y+2+D+C+C | Calculate, Calculate (HFM) |
Alt+Y+2+D+C+F | Calculate, Force Calculate (HFM) |
Alt+Y+2+D+C+T | Calculate, Translate (HFM) |
Alt+Y+2+D+C+R | Calculate, Force Translate (HFM) |
Alt+Y+2+Y+4 | Consolidate (HFM) |
Alt+Y+2+Y+4+N | Consolidate, Consolidate (HFM) |
Alt+Y+2+Y+4+S | Consolidate, Consolidate All (HFM) |
Alt+Y+2+Y+4+L | Consolidate, Consolidate All With Data (HFM) |
Alt+Y+2+Y+4+A | Consolidate, Calculate Contribution (HFM) |
Alt+Y+2+Y+4+O | Consolidate, Force Calculate Contribution (HFM) |
Alt+Y+2+D+Z | Visualize |
Alt+Y+2+D+Z+E | Visualize, Visualize in Excel (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+N | Entity Details (HFM) |
Alt+Y+2+T | Create Journal (HFM) |
Alt+Y+2+D+D | Drill-through (except Oracle Analytics Cloud - Essbase) |
Alt+Y+2+J | Linked Objects (Essbase, Oracle Analytics Cloud - Essbase) |
Alt+Y+2+D+U | Adjust |
Alt+Y+2+D+U+J | Adjust, Adjust (Planning) |
Alt+Y+2+D+U+G | Adjust, Grid Spread (Planning) |
Alt+Y+2+D+U+A | Adjust, Mass Allocate (Planning) |
Alt+Y+2+D+S+B | Submit Data |
Alt+Y+2+D+S+W | Submit Data Without Refresh |
Alt+Y+2+D+S+R | Submit Data Range |
Alt+Y+2+D+M | More (Planning) |
Alt+Y+2+Y+H | Approvals (Planning) |
Alt+Y+2+Y+I | Copy Version (Planning) |