Table 4-1 Planning Ribbon Keyboard Equivalents for Excel 2007 (assumes provider ribbon is Alt+Y)
Keys | Action |
---|---|
Alt+Y+Y | Analyze |
Alt+Y+D+R | Refresh |
Alt+Y+D+R+R | Refresh, Refresh |
Alt+Y+D+R+S | Refresh, Refresh All Worksheets |
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+L | Lock |
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+B | Submit Data |
Alt+Y+D+M | More |
Alt+Y+D+M+J | More, Job Console |
Alt+Y+D+M+M | More, Member Formula |
Alt+Y+D+M+I | More, Instructions |
Alt+Y+D+M+F | More, Offline (Planning on-premise only) |
Alt+Y+D+M+F+T | More, Offline, Take Offline (Planning on-premise only) |
Alt+Y+D+M+F+Y | More, Offline, Sync Back to Server (Planning on-premise only) |
Alt+Y+D+M+F+R | More, Offline, Refresh Offline Definition (Planning on-premise only) |
Alt+Y+S | Save Formatting |
Alt+Y+C | Clear Formatting |
Alt+Y+A | Apply Formatting |
Alt+Y+A+N | Apply Formatting, None |
Alt+Y+A+Y | Apply Formatting, Cell styles |
Alt+Y+A+C | Apply Formatting, Custom styles |
Alt+Y+A+A | Apply Formatting, Custom and cell styles |
Alt+Y+W+P | Approvals |
Alt+Y+W+V | Copy Version |