Essbase Ribbon for Profitability and Cost Management Keyboard Equivalents for Excel 2010
Displays the keyboard equivalents for items on the Essbase ribbon for Profitability and Cost Management in Excel 2010.
Table 4-3 Essbase Ribbon for Profitability and Cost Management Keyboard Equivalents for Excel 2010 (assumes Essbase ribbon for Profitability and Cost Management 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+Y+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+S | Refresh, Refresh All |
Alt+Y+1+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 (not supported by Oracle Analytics Cloud - Essbase) |
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 |