When a data table is active, some keys are associated with certain actions, as shown in Table 4.3.
Table 4.3: Keys and Actions in Data Tables
Key |
Action |
---|---|
ESC |
When editing data, aborts the current edit and deselect cells. |
ESC |
Deselects any selected observations and variables. |
F1 |
Displays the online Help system. |
F3 |
Moves the active cell to the row of the next selected observation. |
SHIFT+F3 |
Moves the active cell to the row of the previous selected observation. |
F10 |
If observations are selected, displays the menu. If variables are selected, displays the menu. If observations and variables are selected, displays the menu followed by the menu. |
TAB |
Moves the active cell to the right. |
SHIFT+TAB |
Moves the active cell to the left. |
ENTER |
Moves the active cell down one row. |
ALT+RIGHT ARROWALT+LEFT ARROW |
Toggles selection of a variable without changing the active cell. |
ALT+DOWN ARROW ALT+UP ARROW |
Toggles selection of an observation without changing the active cell. |
SHIFT+ALT+RIGHT ARROWSHIFT+ALT+LEFT ARROW |
Toggles selection of a variable and moves the active cell to the next or previous variable. |
SHIFT+ALT+DOWN ARROW SHIFT+ALT+UP ARROW |
Toggles selection of an observation and moves the active cell to the next or previous observation. |
SHIFT+RIGHT ARROWSHIFT+LEFT ARROW |
Extends the selection of a range of cell columns. |
SHIFT+DOWN ARROW SHIFT+UP ARROW |
Extends the selection of a range of cell rows. |
HOME |
Edits the active cell and places the cursor at the beginning of the cell. |
END |
Edits the active cell and places the cursor at the end of the cell. |
CTRL+SPACEBAR |
Clears selected observations and variables. |
CTRL+HOME |
Sets the active cell to the first row and first column. |
CTRL+END |
Sets the active cell to the last row and last column. |
CTRL+INSERT |
Displays the New Variable dialog box. |
DELETE |
If observations or variables are selected, deletes the selected variables or observations. If cells are selected, deletes the contents of the selected cells. |
In addition, the data table supports the arrow keys for navigating cells, and it supports the standard Microsoft control sequences shown in Table 4.4.
Table 4.4: Standard Control Sequences in Data Tables
Key |
Action |
---|---|
CTRL+A |
Selects all observations. |
CTRL+C |
Copies contents of selected cells to Windows clipboard. |
CTRL+F |
Displays the Find dialog box. |
CTRL+P |
Prints the data table. |
CTRL+V |
Pastes contents of Windows clipboard to cells. |
CTRL+X |
Cuts contents of selected cells and paste to Windows clipboard. |
CTRL+Y |
Redoes last undo. |
CTRL+Z |
Undoes last operation. |