Single cell

Click on the cell or press an arrow key to navigate to the cell

Cell Range

Click on the first cell in the range and drag your mouse to the last row or hold down the SHIFT key and then use the arrow keys or Page Up or Page Down to move within the data grid.

Alternatively, you can click on a cell and then use your mouse to navigate to the section of the data grid that contains the cell, which represents the opposite corner of the desired selection. Hold the SHIFT key down and click on this cell.

Entire Row

Click on the row header.

Entire Column

Click on the column header.

Adjacent Rows or Columns

Drag the mouse across the row or column headers.

All Cells

Click on the button in the top left corner of the data set window or press CTRL+A.

CURSOR KEYS

Move the cell selection in the corresponding direction, if possible. If you hold down the SHIFT key, the cells that you cross over are selected.

TAB, SHIFT + TAB

Moves the cell selection to the right or left, if possible.

ENTER KEY

Moves the cell selection down, if possible.

CTRL + HOME

Moves the cell selection to the top left corner of the data grid.

CTRL + END

Shifts the view onto the data grid so that the last row of the data grid is visible. The last cell of the last row is selected.

CTRL + LEFT

Moves the cell selection into the first column of the current row.

CTRL + RIGHT

Moves the cell selection into the last column of the current row.

CTRL + UP

Moves the selection to the first row of the current column.

CTRL + DOWN

Moves the selected cells to the last row of the current column.

SHIFT + LEFT

Extends the current selection by one column to the left.

SHIFT + RIGHT

Extends the current selection by one column to the right.

SHIFT + UP

Extends the current selection by one row up.

SHIFT + DOWN

Extends the current selection by one row down.

SHIFT + CTRL + LEFT

Extends the current selection to the first column.

SHIFT + CTRL + RIGHT

Extends the current selection to the last column.

SHIFT + CTRL + UP

Extends the current selection to the first row.

SHIFT + CTRL + DOWN

Extends the current selection to the last filled row.

SHIFT + CTRL + HOME

Extends the current selection to the upper left corner.

SHIFT + CTRL + END

Extends the current selection to the bottom right corner.

F2

Starts editing a cell value. The cell value is shown as being selected.

Any key

Replaces the text of the currently selected cell with the character entered. If the selected area was previously larger than one cell, it is reduced to the edited cell.