Essbase Ribbon for Profitability and Cost Management Keyboard Equivalents for Excel 2019

Displays the keyboard equivalents for items on the Essbase ribbon for Profitability and Cost Management in Excel 2019.

Table 7-3 Essbase Ribbons for Profitability and Cost Management Keyboard Equivalents for Excel 2019 (assumes Essbase ribbon for Profitability and Cost Management is Alt+Y+2)

Keys	Action
Alt+Y+2+Y+1	Zoom In
Alt+Y+2+Y+1+N	Zoom In, Next Level
Alt+Y+2+Y+1+A	Zoom In, All Levels
Alt+Y+2+Y+1+B	Zoom In, Bottom Level
Alt+Y+2+Y+1+E	Zoom In, Same Level
Alt+Y+2+Y+1+L	Zoom In, Sibling Level
Alt+Y+2+Y+1+G	Zoom In, Same Generation
Alt+Y+2+Y+1+F	Zoom In, Formulas
Alt+Y+2+Y+2	Zoom Out
Alt+Y+2+Y+3	Pivot
Alt+Y+2+Y+3+P	Pivot, Pivot
Alt+Y+2+Y+3+T	Pivot, Pivot to POV
Alt+Y+2+Y+4	Keep Only
Alt+Y+2+Y+5	Remove Only
Alt+Y+2+Y+6	Member Selection
Alt+Y+2+Y+7	Cell Information
Alt+Y+2+Y+8	Preserve Format
Alt+Y+2+Y+9	Change Alias
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+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