Keyboard Shortcuts in Data Tables

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 Observations menu. If variables are selected, displays the Variables menu. If observations and variables are selected, displays the Observations menu followed by the Variables 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.