Filter
Top Products
9-9
S To input a cell reference name using direct input
Move the cell cursor to cell B1 and then perform the following operation.
?T(A)@DU
S To input a cell reference name using the GRAB command
Move the cell cursor to cell B1 and then perform the following operation.
(GRAB)B(SET)DU
• Commands (GO) through (BOTm) on the submenu that appears when you press
(GRAB) are identical to commands (GO) through (BOTm) of the JUMP command
submenu. See “Using the JUMP Command to Move the Cell Cursor” on page 9-5 about
these commands.
I 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.
Absolute Reference Names
If you want the row or the column, or both the row and the column parts of a cell reference
name to remain the same to matter where you paste them, you need to create an absolute cell
reference name. You do this by affixing a dollar sign ($) in front of the part of the cell reference
name you want to remain unchanged. You have three options when using the dollar sign ($)
to create an absolute cell reference name: absolute column with relative row ($A1), relative
column with absolute row (A$1), and absolute row and column ($A$1).
S To input the absolute cell reference name symbol ($)
When inputting a cell reference into a spreadsheet cell, press ($).
For example, the following key operation inputs the absolute cell reference name = $B$1
($)?J(B)($)@