Keyboard Shortcuts#
You can use the following shortcuts to accelerate Spectrum executions:
Workbook Shortcuts#
| Command | Keystroke |
|---|---|
| Calculate full Workbook | Alt + C |
| Close Workbook | Alt + Q |
| Create filter sheet | Alt + F |
| Create join sheet | Alt + J |
| Create sort sheet | Alt + R |
| Create union sheet | Alt + K |
| Duplicate sheet | Alt + P |
| Exchange data source | Alt + X |
| Flip Side | Shift + Alt + F |
| Go to line | Alt + E |
| Hide/Show column | ALT + H |
| Jump to column or sheet | Alt + M |
| Link datasource | Alt + D |
| Move sheet (up, down, left, right) | ↑, ↓, ←, → |
| New Workbook | Alt + N |
| Open Workbook | Alt +O |
| Save As | Alt + T |
| Save Workbook | Alt + S |
| Sheet dependency graph | Alt + G |
| Submit a formula | ⌘-Enter (mac) and Ctrl-Enter (win) |
| Switch among column headers* | Tab |
| Switch among columns** | ← and → |
| View full results | Alt + A |
| Workbook info | Alt + I |
| Show partition sunburst | Alt + B |
* For this shortcut to work, you must be in the column header. Example - renaming the column.
** For this to work, you must first click on a column. Then you can switch among the columns in the Workbook.