Cell Reference
A Cell reference is the use of a cell's coordinates in a formula.
Each spreadsheet cell
is identified by its row and column (and optionally its
file name and
sheet name).
Using these coordinates in a formula as an operand or parameter is called
cell reference or short reference.
For example, the formula "=3*$B$1" contains as second operand the reference to the cell "$B$1" or column "B", row "1"
Cell references can be absolute
or relative. Sometimes
referencing is also called addressing, such as relative addressing and absolute addressing.
A cell can also be referenced indirectly through the use of a
name, such as
"=3*MonthlyTotal", where "MonthlyTotal" is defined as
a name for a cell.
Using Cell References
The following screencasts demonstrate how to use cell references in spreadsheet formulas:
- How to reference a single cell in a formula.
- How to define a range of cells.
- How to use a cell range in a function.
- How to define a name for a cell.
- How to define a name for a cell range.
OpenOffice.org™ is a trademark of OpenOffice.org.
