Table 4-2 Planning Ad Hoc Ribbon Keyboard Equivalents for Excel 2007 (assumes Planning Ad Hoc ribbon is Alt+Y)
Keys | Action |
---|---|
Alt+Y+A+Z | Zoom In |
Alt+Y+A+Z+N | Zoom In, Next Level |
Alt+Y+A+Z+A | Zoom In, All Levels |
Alt+Y+A+Z+B | Zoom In, Bottom Level |
Alt+Y+A+U | Zoom Out |
Alt+Y+A+T | Pivot |
Alt+Y+A+T+P | Pivot, Pivot |
Alt+Y+A+T+T | Pivot, Pivot to POV |
Alt+Y+A+K | Keep Only |
Alt+Y+A+O | Remove Only |
Alt+Y+A+I | Member Selection |
Alt+Y+A+Q | Query |
Alt+Y+A+Q+Q | Query, Query Designer |
Alt+Y+A+Q+R | Query, Run Report |
Alt+Y+A+Q+D | Query, Data Filter |
Alt+Y+A+P | Preserve Format |
Alt+Y+A+A | Change Alias |
Alt+Y+A+S+1 | Smart Slice |
Alt+Y+A+S+2 | Save Ad Hoc Grid |
Alt+Y+A+1 | Save As Smart Form |
Alt+Y+A+C | Cascade |
Alt+Y+A+C+S | Cascade, Same Workbook |
Alt+Y+A+C+N | Cascade, New Workbook |
Alt+Y+A+C+D | Cascade, Different Workbooks |
Alt+Y+I | Insert Attributes |
Alt+Y+D+R | Refresh |
Alt+Y+D+R+R | Refresh, Refresh |
Alt+Y+D+R+A | Refresh, Refresh All |
Alt+Y+D+O | Display or Hide POV |
Alt+Y+D+A | Cell Actions |
Alt+Y+D+A+E | Cell Actions, Comments |
Alt+Y+D+A+P | Cell Actions, Supporting Details |
Alt+Y+D+A+T | Cell Actions, Attachment |
Alt+Y+D+A+H | Cell Actions, History |
Alt+Y+D+C | Calculate |
Alt+Y+D+C+B | Calculate, Business Rules |
Alt+Y+D+C+U | Calculate, Rules on Form |
Alt+Y+D+U | Adjust |
Alt+Y+D+U+J | Adjust, Adjust |
Alt+Y+D+U+G | Adjust, Grid Spread |
Alt+Y+D+U+A | Adjust, Mass Allocate |
Alt+Y+D+D | Drill-through |
Alt+Y+D+Z | Visualize |
Alt+Y+D+S | Submit Data |
Alt+Y+D+S+B | Submit Data, Submit Data |
Alt+Y+D+S+W | Submit Data Without Refresh |
Alt+Y+D+S+R | Submit Data Range |
Alt+Y+W+P | Workflow Approvals |
Alt+Y+W+V | Workflow Copy Version |