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