User Manual

9-5
u Auto Calc
Auto Calc is an S
•
SHT mode Setup item (page 1-34).
When Auto Calc is enabled (On), all of the formulas in a spreadsheet are recalculated when
the spreadsheet is opened or when any editing operation is performed. It should be noted,
however, that recalculation can slow down the overall processing speed. When Auto Calc is
disabled (Off), you need to execute recalculation manually as required.
u To execute spreadsheet re-calculation manually
Press 1(FILE) 4(RECAL). This recalculates all of the formulas in the currently open file and
displays the applicable results.
k Using the Cell Cursor
The cell cursor shows the cell that is selected on a spreadsheet. The highlighted cell is the one
that is currently selected by the cell cursor.
Cell cursor
Edit box
When a single cell is selected by the cell cursor, the contents of that cell are displayed in the
edit box. The cell contents can be edited in the edit box.
When a multiple cells are selected by the cell cursor, the selection range is displayed in the
edit box. In this case, you can copy, delete, or perform other cell operations on the entire range
of selected cells.
u To select cells
To select this: Do this:
A single cell Use the cursor keys to move the cell cursor to the cell
you want, or use the JUMP comment to jump directly
to the cell.
A range of cells See “To select a range of cells” (page 9-6).
An entire row of cells
Move the cell cursor to column A of the row whose
cells you want to select and then press d. Pressing
d while the cell cursor is located at cell A2, for
example, will select the entire second row (from A2 to
Z2). This will cause A2:Z2 (which indicates the selected
range) to appear in the edit box.