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