Interacting with the Data Table

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.

Top of Page