89
Chapter 8 Pocket Sheet
Cell References
The term cell reference means calling the contents of one cell into another
cell. Pocket Sheet supports three types of cell references: relative, absolute,
and mixed. Whether a cell references is relative, absolute, or mixed does not
make affect the results it normally produces. The cell reference type matters
only when the contents of the cell are copied and then pasted into another
location. See “Copying a Relative Cell Reference” on page 109 and “Copying
an Absolute or Mixed Cell Reference” on page 109 for full information
about how cell references are affected by cut, copy, and paste operations.
Relative Cell References
As its name suggests, a relative cell reference is one that references a cell in
relation to the cell where the reference is made. Note the following examples.
Absolute Cell References
An absolute cell reference is one that references a specific cell, no matter
where it is located in relation to the cell where the reference is made. A
reference is made absolute by inserting a dollar sign in front of its column
name and row number. Note the following examples.
Meaning
Contents of cell A1
Contents of the column of cells from A1
through A10
Contents of the row of cells from A1 to E1
Relative Cell
Reference
A1
A1:A10
A1:E1
Meaning
Contents of cell A1. Both the column ($A) and
row ($1) references are absolute.
Contents of the column of cells from A1
through A10. All the column and row
references are absolute.
Contents of the row of cells from A1 to E1. All
the column and row references are absolute.
Absolute Cell
Reference
$A$1
$A$1:$A$10
$A$1:$E$1
To Next Page
Loading...
Need help?
Display and Memory
Power
Weight and Dimensions
