** File: TPSht_05.hlp
** Index: 44

** More Sheet View Help
   :: Data Sheet Basics


Û  Data sheet basics

    The data sheet window contains several
new elements: status box, edit window,
scroll bars, etc.  They are explained in
the following sections.


Û  Status box

    This box shows the currently selected
block of data sheet.  For example,
"C4R3-C8R7" means that the current sheet
selected block is from the fourth column
and the third row to the eighth column and
the seventh row.


Û  Edit window

    The Edit window area is an input-line
box where you can type in data and text.
The OK button and Cancel button are used
in conjunction with the Edit window.

  OK Button:  Click this button to accept
    the contents of the Edit window in the
    active cell (the one that is
    highlighted).

  Cancel Button:  Click this button to
    abort any edit action in the Edit
    window and put the original contents
    back in the Edit window.


Û  Scroll bars

    There are two scroll bars - horizontal
and vertical.  The horizontal scroll bar
controls column movement while the vertical
scroll bar controls row movement.


Û  Columns and rows

    The data sheet is organized by columns
and rows of cells.  A cell is where a data
number is stored and displayed.  A column
is an array of cells.  In TechPlot, all
mathematical transformations and
statistical analyses are based on columns
of data.  A row is a collections of cells
in horizontal direction.  Rows are only
used internally for managing and editing
sheet data.

  Column Name:  Since TechPlot does
    mathematical calculations based on
    columns, the column names become
    important references.  Each column has
    a unique name.  The default name for a
    column is 'Column'+Number, where
    'Number' is the current column number.
    For example, the third column's default
    name is 'Column3'.

  Row Number:  This is the left-most
    column.  It shows the position of
    numbers in a column.

  Active Cell:  The active cell is the one
    that is highlighted.  The value of the
    active cell is shown in the Edit
    window.  Only the value of the
    currently active cell can be edited.


Û  Moving the active cell around the
   data sheet

    You can use either keyboard or mouse to
move a cell around in the data sheet.  The
current active cell is highlighted.

  Using the keyboard:
    ú The up (-) and down (_) arrow keys
      move up and down by one row.  When it
      reaches the first row, it will move
      to the column title and the selection
      becomes one column.  

    ú The left (ª) and right (r) arrow keys
      move left and right by one column.
      When the cell reaches the first
      column, it will move to the row
      number 'cell' and the selection
      becomes one row.

    ú If the current selection is one
      column (row), then when you use
      left (down) or right (up) arrow key,
      then movement will be one column
      (row) by one column (row).  

    ú You can also use the Sheet | GoTo
      command to specify a cell position
      and move to that position.

  Using the mouse:
    ú Just click the mouse button when the
      mouse cursor is pointing at the cell
      position you want to move to.  

    ú When you click on a column title, the
      whole column will be selected.

    ú When you click on a row number, the
      whole row will be selected.

    ú Click 'ALL' to select the entire data
      sheet.

