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