Shortcuts for Table Navigation

(Up to New to Release 4.0)

Table Navigation Keys

Analytica 4.0 offers a wide set of mouse and keyboard shortcuts for navigating around a table. If even supports search within a table. These are identical to those in Excel, wherever this makes sense. CTRL-PgUp and CTRL-PgDn are exceptions.

These shortcuts let you move the highlighted Current cell and, in some cases, select a rectangular current region of cells. In a region, the the Anchor cell is the corner opposite the current cell. If you select only one cell, the Anchor and Current are the same cell.

Mouse operations

• Mouse Click: Click in a cell to make it the current cell.

• Mouse SHIFT-Click: Select the region from the previous anchor to this cell.

• Mouse Drag: Select the region from the cell in which you depress the left mouse button to the cell in which you release the button.

• Mouse Wheel: Scroll vertically without changing the selection.

• CTRL-Mouse Wheel: Scroll horizontally without changing the selection.

Searching a table

• CTRL-F: Open the Find-dialog to search for text in the table. It searches starting after the current cell. It selects the first matching cell, if any.

• CTRL-G: Repeat the previous Find, starting one cell after the current cell.

Arrow keys

• arrow (right, left, up, down): Move one cell in the given direction. At the end of row, right arrow wraps to the start of the next row. At the end of the last row, it wraps to top-left cell. Similarly, for the other keys. In the last cell of a list index in edit mode, down-arrow or right-arrow appends an element to the index.

• SHIFT-arrow: Move the current cell one cell in the given direction. The Anchor cell stays put, causing the selected region to grow or shrink. It does not wrap.

• CTRL-arrow: Move to the end of row or column in the given direction.

• SHIFT-CTRL-arrow: Move current cell to the end of row or column in the given direction, leaving the Anchor where it is, causing the selected region to grow (or flip).

• END,arrow: Two key sequence. Same as CTRL-arrow.

• END,SHIFT-arrow: Two key sequence. Same as SHIFT-CTRL-arrow.

Home key

• HOME: Move the anchor to the first column, and sets the current cell to be the anchor (so only one cell is selected). If you are in the row headers, moves the anchor & current to the first row.

• CTRL-HOME: Select the top-left cell in the table. (Selects one cell.)

• CTRL-END: Select the bottom-right cell in the table. (Selects one cell.)

• SHIFT-CTRL-HOME: Select the region between the anchor and the top left cell. (Leaving current as top left.)

= Page key

• Page Up, Page Down: Move the current cell up or down by the number of rows visible in the window, and scrolls up or down to show that cell. (Selects one cell.)

• CTRL-Page Up, CTRL-Page Down: Move the current cell left or right by the number of columns visible in the window, scrolling horizontally to show the new current cell. (This is not the same as Excel, in whihc CTRL-PgUp, CTRL-PgDown toggle between worksheets. Since we don't have worksheets, these do something else useful.)

• SHIFT-Page Up, SHIFT-Page Down: Move the Current cell by the number of rows or columns that currently display on the screen, and scroll vertically by one page. Anchor stays the same, so that the currently selected region expands or shrinks by one page length.

• SHIFT-CTRL-Page Up, SHIFT-CTRL-Page Down: Same as SHIFT-Page Up, but horizontally rather than vertically.

Other keys

• TAB: Move one cell right. Same as right arrow.

• SHIFT-TAB: Move one cell left. Same as left arrow.

• ENTER, SHIFT-ENTER: If editing, accept change, selection remains on cell just edited. If not editing, but in edit mode, current cell becomes anchor cell and begin editing that cell.

• RETURN: If editing, accept changes. Move anchor down one cell, wrapping to top of next column if anchor is at the bottom. Set current cell to anchor (so only one cell is selected). If not editing, just move, do not start editing.

• SHIFT-RETURN: If editing, accept changes. Move anchor cell up one cell, wrapping to bottom of previous column if at top. Set current to anchor, so only one cell is selected.

• CTRL-A: Select all (body) cells. If a row/col header is selected, selects all rows/cols.