Table 7-6 TRCS Ribbon Keyboard Equivalents for Excel 2016 (assumes provider ribbon is Alt+Y+2)
Keys | Action |
---|---|
Alt+Y+2+Y5 | Analyze |
Alt+Y+2+DR | Refresh |
Alt+Y+2+DR+R | Refresh, Refresh |
Alt+Y+2+DR+S | Refresh, Refresh All Worksheets |
Alt+Y+2+DO | POV |
Alt+Y+2+DL | Lock |
Alt+Y+2+DC | Calculate |
Alt+Y+2+DC+B | Calculate, Business Rules |
Alt+Y+2+DC+U | Calculate, Rules on Form |
Alt+Y+2+DU | Adjust |
Alt+Y+2+DU+J | Adjust, Adjust |
Alt+Y+2+DU+G | Adjust, Grid Spread |
Alt+Y+2+DD | Drill-through |
Alt+Y+2+DB | Submit Data |
Alt+Y+2+DM | More |
Alt+Y+2+DM+J | More, Job Console |
Alt+Y+2+DM+M | More, Member Formula |
Alt+Y+2+DM+I | More, Instructions |
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 |