Inputting and Editing Cell Data
kReferencing a Particular CellThe 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
20050401