Essbase Ribbon for Profitability and Cost Management Keyboard Equivalents for Excel 2016
Displays the keyboard equivalents for items on the Essbase ribbon for Profitability and Cost Management in Excel 2016.
Table 6-3 Essbase Ribbons for Profitability and Cost Management Keyboard Equivalents for Excel 2016 (assumes Essbase ribbon for Profitability and Cost Management is Alt+Y+2)
Keys | Action |
---|---|
Alt+Y+2+A+Z | Zoom In |
Alt+Y+2+A+Z+N | Zoom In, Next Level |
Alt+Y+2+A+Z+A | Zoom In, All Levels |
Alt+Y+2+A+Z+B | Zoom In, Bottom Level |
Alt+Y+2+A+Z+E | Zoom In, Same Level |
Alt+Y+2+A+Z+L | Zoom In, Sibling Level |
Alt+Y+2+A+Z+G | Zoom In, Same Generation |
Alt+Y+2+A+Z+F | Zoom In, Formulas |
Alt+Y+2+A+U | Zoom Out |
Alt+Y+2+A+T | Pivot |
Alt+Y+2+A+T+P | Pivot, Pivot |
Alt+Y+2+A+T+T | Pivot, Pivot to POV |
Alt+Y+2+A+K | Keep Only |
Alt+Y+2+A+O | Remove Only |
Alt+Y+2+Y+I | Member Selection |
Alt+Y+2+A+E | Member Information |
Alt+Y+2+A+P | Preserve Format |
Alt+Y+2+A+A | Change Alias |
Alt+Y+2+A+D | Data Perspective |
Alt+Y+2+A+S | Smart Slice |
Alt+Y+2+A+C | Cascade |
Alt+Y+2+A+C+S | Cascade, Same Workbook |
Alt+Y+2+A+C+N | Cascade, New Workbook |
Alt+Y+2+A+C+D | Cascade, Different Workbooks |
Alt+Y+2+I | Insert Attributes |
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 |
Alt+Y+2+D+W | View Comments |
Alt+Y+2+D+C | Calculate |
Alt+Y+2+D+Z | Visualize |
Alt+Y+2+D+Z+E | Visualize, Visualize in Excel |
Alt+Y+2+D+D | Drill-through |
Alt+Y+2+J | Linked Objects |
Alt+Y+2+D+U | Adjust |
Alt+Y+2+D+S | Submit Data |
Alt+Y+2+D+S+B | Submit Data, Submit Data |
Alt+Y+2+D+S+W | Submit Data Without Refresh |
Alt+Y+2+D+S+R | Submit Data Range |
Alt+Y+2+Q+Q | Query |
Alt+Y+2+Q+Q+Q | Query, Query Designer |
Alt+Y+2+Q+Q+R | Query, Run Report |
Alt+Y+2+Q+Q+D | Query, Data Filter |
Alt+Y+2+Q+Q+S | Query, Smart Query |
Alt+Y+2+Q+E | Query, Execute MDX |