Difference between revisions of "Shortcuts for Table Navigation"

 
(Table Navigation Keys)
Line 3: Line 3:
 
= Table Navigation Keys =
 
= Table Navigation Keys =
  
Navigation keys in a table alter the region of selected cells. The region of selected cells is a rectangle determined by two corner cells: The Anchor Cell, and the Current CellIf only one cell is selected, the Anchor and the Current cells are the same cell.
+
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 senseCTRL-PgUp and CTRL-PgDn are exceptions.
  
The navigation keys in Analytica 4.0 have been altered to act like those in Excel, to the extent that this makes senseCTRL-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 cornersIf only one cell is selected, the Anchor and the Current cells are the same cell.
  
* arrow (right,left,up,down): Moves the Anchor cell in the indicated direction by one cellSets the Current Cell to be the new Anchor (so only one cell is selected).  Wraps to next row/col.  When in the last cell of an index and in edit mode, down or right appends an element to the index.
+
* 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: Moves the current cell by one in the given direction.  Anchor cell stays put, causing the selected region to grow or shrink.  Does not wrap.
+
* 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: Moves 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).
+
* 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: Moves the current cell to the end of row or column in the given direction, causing the selected region to grow (or flip).
+
* 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,arrow: Two key sequence.  Same as CTRL-arrow.
Line 19: Line 19:
 
* END,SHIFT-arrow: Two key sequence.  Same as SHIFT-CTRL-arrow.
 
* END,SHIFT-arrow: Two key sequence.  Same as SHIFT-CTRL-arrow.
  
* HOME: Moves 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.
+
* 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: Moves the anchor and current to the first row and first column, so only the top-left cell in the table is selected.
+
* CTRL-HOME: Select the top-left cell in the table. (Selects one cell.)
  
* SHIFT-CTRL-HOME: Moves the current to the first row & column, thus selecting everything between the anchor and the current.
+
* CTRL-END: Select the bottom-right cell in the table. (Selects one cell.)
  
* CTRL-END: Moves the anchor and current to the last row and last column, so only the bottom-right cell in the table is selected.
+
* 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 anchor cell down by the number of rows that fit in the current window, and scroll vertically by one page. Set the current to the anchor, so only one cell is selected.
+
* 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 anchor cell horizontally by the number of columns tha tfit in the current window and scroll horizontally.  Set the Current to the Anchor, so only one sell is selected. Note: This is not the same as Excel.  In Excel, CTRL-PgUp, CTRL-PgDown toggle between worksheets.  Since we don't have worksheets, I've assigned this combination to something else useful.
+
* 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: Moves 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-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.
 
* SHIFT-CTRL-Page Up, SHIFT-CTRL-Page Down: Same as SHIFT-Page Up, but horizontally rather than vertically.
  
* TAB: Same as right arrow.
+
* TAB: Move one cell right. Same as right arrow.
  
* SHIFT-TAB: Same as left 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.
 
* 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.

Revision as of 21:07, 26 January 2007

(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.
Comments


You are not allowed to post comments.