Essbase Ribbon Keyboard Equivalents for Excel 2010

Displays the keyboard equivalents for items on the Essbase ribbon for Excel 2010.

Table 4-10 Essbase Ribbon Keyboard Equivalents for Excel 2010 (assumes Essbase ribbon is Alt+Y+1)

Keys Action
Alt+Y+1+Y+2 Zoom In
Alt+Y+1+Y+2+N Zoom In, Next Level
Alt+Y+1+Y+2+A Zoom In, All Levels
Alt+Y+1+Y+2+B Zoom In, Bottom Level
Alt+Y+1+Y+2+E Zoom In, Same Level
Alt+Y+1+Y+2+L Zoom In, Sibling Level
Alt+Y+1+Y+2+G Zoom In, Same Generation
Alt+Y+1+Y+2+F Zoom In, Formulas
Alt+Y+1+Y+3 Zoom Out
Alt+Y+1+Y+4 Pivot
Alt+Y+1+Y+4+P Pivot, Pivot
Alt+Y+1+Y+4+T Pivot, Pivot to POV
Alt+Y+1+Y+5 Keep Only
Alt+Y+1+Y+6 Remove Only
Alt+Y+1+Y+7 Member Selection
Alt+Y+1+Y+9 Member Information
Alt+Y+1+Y+A Preserve Format
Alt+Y+1+Y+B Change Alias
Alt+Y+1+Y+C Data Perspective
Alt+Y+1+Y+D Smart Slice
Alt+Y+1+Y+E Cascade
Alt+Y+1+Y+E+S Cascade, Same Workbook
Alt+Y+1+Y+E+N Cascade, New Workbook
Alt+Y+1+Y+E+D Cascade, Different Workbooks
Alt+Y+1+I Insert Attributes
Alt+Y+1+P Insert Properties
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+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 Manage and Execute Queries