Table 6-7 TRCS Ad Hoc Ribbon Keyboard Equivalents for Excel 2016 (assumes TRCS Ad Hoc ribbon is Alt+Y)
Keys | Action |
---|---|
Alt+Y+2+Y+3 | Zoom In |
Alt+Y+2+Y+3+N | Zoom In, Next Level |
Alt+Y+2+Y+3+A | Zoom In, All Levels |
Alt+Y+2+Y+3+B | Zoom In, Bottom Level |
Alt+Y+2+Y+4 | Zoom Out |
Alt+Y+2+Y+5 | Pivot |
Alt+Y+2+Y+5+P | Pivot, Pivot |
Alt+Y+2+Y+5+T | Pivot, Pivot to POV |
Alt+Y+2+Y+6 | Keep Only |
Alt+Y+2+Y+7 | Remove Only |
Alt+Y+2+Y+8 | Member Selection |
Alt+Y+2+Y+9 | Query |
Alt+Y+2+Y+9+Q | Query, Query Designer |
Alt+Y+2+Y+A | Change Alias |
Alt+Y+2+Y+B | Save as Smart Form |
Alt+Y+2+Y+C | Cascade |
Alt+Y+2+Y+S | Cascade, Same Workbook |
Alt+Y+2+Y+N | Cascade, New Workbook |
Alt+Y+2+Y+D | Cascade, Different Workbooks |
Alt+Y+2+D+R | Refresh |
Alt+Y+2+D+R+R | Refresh, Refresh |
Alt+Y+2+D+R+S | Refresh, Refresh All |
Alt+Y+2+D+O | POV |
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+D | Drill-through |
Alt+Y+2+D+Z | Visualize |
Alt+Y+2+B | Submit Data |
Alt+Y+2+B+B | Submit Data, Submit Data |
Alt+Y+2+B+W | Submit Data, Submit Data Without Refresh |
Alt+Y+2+B+R | Submit Data, Submit Data Range |