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