Navigating and Selecting Data
Using the mouse to navigate and select data:
Selection |
Action |
---|---|
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. |
Using the keyboard to navigate and select data:
Key |
Action |
---|---|
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. |
Navigating to a particular cell:
1.In data view, click on any cell in the data set to which you want to navigate. You can skip this step in the data set editor.
2.Click Data Tools/Design[Value] > Go To.
3.In the dialog box that now appears, enter the coordinates of the cell to go to via the X index and, if applicable, Z index or via the X value and, if applicable, Z value.
See Also