Table 5-2 Planning Ad Hoc Ribbon Keyboard Equivalents for Excel 2010 (assumes Planning Ad Hoc 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+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+8 | Query |
| Alt+Y+1+Y+8+Q | Query, Query Designer |
| Alt+Y+1+Y+8+R | Query, Run Report |
| Alt+Y+1+Y+8+D | Query, Data Filter |
| Alt+Y+1+Y+9 | Preserve Format |
| Alt+Y+1+Y+A | Change Alias |
| Alt+Y+1+Y+B | Smart Slice |
| Alt+Y+1+Y+C | Save Ad Hoc Grid |
| Alt+Y+1+Y+D | Save As Smart Form |
| 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+D+R | Refresh |
| Alt+Y+1+D+R+R | Refresh, Refresh |
| Alt+Y+1+D+R+S | Refresh, Refresh All Worksheets |
| Alt+Y+1+D+O | Display or Hide POV |
| Alt+Y+1+D+A | Cell Actions |
| Alt+Y+1+D+A+E | Cell Actions, Comments |
| Alt+Y+1+D+A+P | Cell Actions, Supporting Details |
| Alt+Y+1+D+A+T | Cell Actions, Attachment |
| Alt+Y+1+D+A+H | Cell Actions, History |
| Alt+Y+1+D+C | Calculate |
| Alt+Y+1+D+C+B | Calculate, Business Rules |
| Alt+Y+1+D+C+U | Calculate, Rules on Form |
| Alt+Y+1+D+U | Adjust |
| Alt+Y+1+D+U+J | Adjust, Adjust |
| Alt+Y+1+D+U+G | Adjust, Grid Spread |
| Alt+Y+1+D+U+A | Adjust, Mass Allocate |
| Alt+Y+1+D+D | Drill-through |
| Alt+Y+1+D+Z | Visualize |
| 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+Z+3 | Workflow |
| Alt+Y+1+Z+3+Y+1 | Workflow, Approvals |
| Alt+Y+1+Z+3+Y+2 | Workflow, Copy Version |