The following control key combinations provide shortcuts to many of the more frequently used menu commands.
Key | Function | Shift+Key | Alt+Key |
Ctrl+A | Select All | Add Note | Bookmark by Value* |
Ctrl+B | Submit Batch File | Display Note | Rebase Date column |
Ctrl+C | Copy | Change Case | Select Column* |
Ctrl+D | Clear All Data | ||
Ctrl+E | Update Data and Exit* | Excel import wizard | |
Ctrl+F | Find | Reorder Levels* | Calculate Factor* |
Ctrl+G | Goto Line/Cell | ||
Ctrl+H | Next Error Message | Previous Error Message | |
Ctrl+I | Insert row before current row* | Insert multiple rows* | |
Ctrl+J | Insert row after current row* | ||
Ctrl+K | Submit Clipboard | Submit to current line | Conditional Format* |
Ctrl+L | Submit Line | DDE Link* | Edit Factor Levels* |
Ctrl+M | Submit Selection/Run Analysis* | Submit from current line | Move Column* |
Ctrl+N | Open New Text Window | ||
Ctrl+O | Open File | Reorder Columns* | |
Ctrl+P | Protect Column* | ||
Ctrl+Q | (none) | Cell Colours* | Toggle Selection of Cell |
Ctrl+R | Replace | Repeat Line | Select Row* |
Ctrl+S | Save File | Save File As | |
Ctrl+T | Find Next | Text Split* | Temporary Missing Value* |
Ctrl+U | Update Sheet* | Allow Auto Update* | |
Ctrl+V | Paste | Paste Special | |
Ctrl+W | Submit Window | Recycle Window | Default Column Widths* |
Ctrl+X | Cut | ||
Ctrl+Y | Redo | ||
Ctrl+Z | Undo | ||
Ctrl+Delete | Delete | ||
Ctrl+0 | Restrict Expression* | ||
Ctrl+1 | Restrict on Cell* | ||
Ctrl+2 | Restrict No Missing values* | ||
Ctrl+3 | Restrict Missing Values* | ||
Ctrl+4 | Reverse Restriction* | ||
Ctrl+5 | Restrict Selection* | ||
Ctrl+6 | Restrict Selected rows added to Excluded* | ||
Ctrl+7 | Restrict Selected rows removed from Excluded* | ||
Ctrl+8 | Restrict UnSelected rows as Excluded* | ||
Ctrl+9 | Restrict UnSelected rows added to Excluded* | ||
Ctrl+0 | Restrict UnSelected rows removed from Excluded* | ||
Ctrl+] | Moves the cursor to next brace or matching statement |
Bookmark Shortcuts
The following key assignments provide shortcuts to bookmark functions:
Key | Function | Shift+Key | Control+Key |
Alt+A | Toggle | Display | By Value |
Alt+B | Next | Previous | |
Alt+D | Delete Note |
Other Alt key Shortcuts
The following key assignments provide shortcuts to bookmark functions:
Key | Function | Shift+Key |
Alt+K | Insert Code | Insert Command |
Alt+N | Copy Column Names* | Paste Column Names* |
Alt+Q | Swap Selected Cells* | |
Alt+R | Rename Columns* | |
Alt+T | Combine Text* |