User Manual

9-10
3. Copy the formula in cell C2 and copy it into cells C3 and C4. Move the cell cursor to cell C2
and then perform the following operation.
2(EDIT) 2(COPY) c1(PASTE) c1(PASTE) J
• For details about the copy and paste operations, see
“Copying and Pasting Cell Contents” (
page 9-11).
k Inputting a Cell Reference Name
Each cell on a spreadsheet has what is called a “reference name”, which is derived by
combining its column name (A through Z) with its row name (1 through 999). A cell reference
name can be used inside of a formula, which makes the value of the called cell part of the
formula. See “Inputting a Formula into a Cell” (page 9-9) for more information. There are two
methods you can use to input a cell reference name: direct input of the name and input using
the GRAB command. The following illustrates how you would use each of these methods to
input =A1+5 into cell B1.
u To input a cell reference name using direct input
Move the cell cursor to cell B1 and then perform the following operation.
!.(=) av(A) b+fw
u To input a cell reference name using the GRAB command
Move the cell cursor to cell B1 and then perform the following operation.
!.(=) 1(GRAB) d1(SET) +fw
• Commands 2(GO) through 6(BOT → ) on the submenu that appears when you press
1(GRAB) are identical to commands 1(GO) through 5(BOT → ) of the JUMP command
submenu. See “Using the JUMP Command to Move the Cell Cursor” on
page 9-6 about
these commands.
k Relative and Absolute Cell Reference Names
There are two types of cell reference names: relative and absolute. Normally, cell reference
names are treated as being relative.
Relative Cell Reference Names
In the formula =A1+5, the cell reference name A1 indicates a relative cell reference. It is
“relative” because copying the formula and pasting in a different cell will cause the cell
reference name to change in accordance with the location of cell where it is pasted. If the
formula =A1+5 is originally located in cell B1, for example, copying at pasting in cell C3 will
result in =B3+5 in cell C3. Moving from column A to column B (one column) causes A to
change to B, while moving from row 1 to row 3 changes (two rows) changes the 1 to 3.
Important!: If the result of a copy and paste operation causes a relative cell reference name
to change to something that is outside the range of the spreadsheet cells, the applicable
column letter and/or row number will be replaced by a question mark (?), and “ERROR” will be
displayed as the cell’s data.