Shortcuts for Table Navigation

(Up to New to Release 4.0)

Table Navigation Keys

Analytica 4.0 offers a wide set of keyboard shortcuts for navigating around a table. They are identical to those in Excel, wherever this makes sense. CTRL-PgUp and CTRL-PgDn are exceptions.

Navigation keys in a table change the region of selected cells. This is a region is a rectangle defined by the Anchor Cell and the Current Cell in opposite corners. If only one cell is selected, the Anchor and the Current cells are the same cell.

• arrow (right, left, up, down): Move the Anchor cell by one cell in the indicated direction. It sets the Current Cell to be the new Anchor (so only one cell is selected). It wraps to next row or column. When in the last cell of an index and in edit mode, arrow-down or arrow-right appends an element to the index.

• SHIFT-arrow: Move the current by 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 the anchor cell to the end of row or column in the given direction. Sets the current cell to be the new anchor (so only one cell is selected).

• SHIFT-CTRL-arrow: Move the current cell to the end of row or column in the given direction, 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: 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 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.

• 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-F: Bring up a Find-dialog to find a string within the table. The search starts at one cell after the top-left cell in the selected region. The anchor & current are set to the next occurrance found, if any, so the single cell is selected.

• CTRL-G: Repeat the previous Find, starting one cell after the top-left cell in the selected region.

• Mouse Click: A single click in a cell sets the anchor and current to that cell.

• Mouse SHIFT-Click: Sets the current cell, selecting the rectangle between it and the previous Anchor.

• Mouse Drag: The cell where the drag is initiated (where the mouse is depressed) becomes the anchor. The cell where it is released becomes the current. A region of cells is thus selected.

• Mouse Wheel: Scrolls vertically without changing the selection.

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

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