Planning Ad Hoc Ribbon Keyboard Equivalents for Excel 2019

Displays the keyboard equivalents for items on the Planning Ad Hoc ribbon for Excel 2019.

Table 7-2 Planning Ad Hoc Ribbon Keyboard Equivalents for Excel 2019 (assumes Planning Ad Hoc ribbon 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+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	Preserve Format
Alt+Y+2+Y+8	Change Alias
Alt+Y+2+Y+9	Smart Slice
Alt+Y+2+Y+A	Save Ad Hoc Grid
Alt+Y+2+Y+B	Save As Smart Form
Alt+Y+2+Y+C	Cascade
Alt+Y+2+Y+C+S	Cascade, Same Workbook
Alt+Y+2+Y+C+N	Cascade, New Workbook
Alt+Y+2+Y+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	Display or Hide POV
Alt+Y+2+D+A	Cell Actions
Alt+Y+2+D+A+E	Cell Actions, Comments
Alt+Y+2+D+A+P	Cell Actions, Supporting Details
Alt+Y+2+D+A+T	Cell Actions, Attachment
Alt+Y+2+D+A+H	Cell Actions, History
Alt+Y+2+D+C	Calculate
Alt+Y+2+D+C+B	Calculate, Business Rules
Alt+Y+2+D+C+U	Calculate, Rules on Form
Alt+Y+2+D+U	Adjust
Alt+Y+2+D+U+J	Adjust, Adjust
Alt+Y+2+D+U+G	Adjust, Grid Spread
Alt+Y+2+D+U+A	Adjust, Mass Allocate
Alt+Y+2+D+D	Drill-through
Alt+Y+2+D+Z	Visualize
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+Y+D	Approvals
Alt+Y+2+Y+E	Copy Version
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