Programming Guide

20050401

9-4-6

Inputting and Editing Cell Data

k Referencing a Particular Cell

The following procedure shows how to reference A1 (which contains the value 3) and

perform the calculation A1 × 2.

u To reference a particular cell

1. Move the cell cursor to cell A2, and then input

!.(=).

2. Press 1 (GRAB).

•This enters the Grab mode, which changes

the function menu to the function described

below. The Grab mode function menu

makes it easier to move the cursor around

the spreadsheet.

To move the cell cursor to here: Press this key:

A specific cell 2(GO)

Line 1 of current column 3(TOP↑)

Column A of current line 4(TOP←)

Bottom line of current column 5(BOT↓)

Column Z of current line 6(BOT→)

3. Press f to move the cell cursor to cell A1.

4. Press 1 (SET).

•This inputs the reference to cell A1.

#Instead of using the GRAB command

(1(GRAB) in step 2), you could also type in

the necessary letter and number manually, if

you want. In place of steps 2 through 4 in the

above procedure, you could input av(A)b

to type “A1” if you want. For more information, see

“Formula Input Example” (page 9-4-4).