Absolute Cell Reference
An absolute cell reference is the use of a cell's
row and column (and optionally its
file
name and
sheet name).
An absolute reference does not change if columns or rows are
inserted or deleted from a sheet.
For example, the formula "=3*$B$1" contains as second operand the reference
to the cell "B1" or column "B", row "1". The
dollar sign, "$" indicates an absolute reference.
Cell references can also be relative.
Sometimes referencing is also called addressing, such as relative addressing and absolute addressing.
A cell can also be absolutely referenced through the use of a
name, such as
"=3*MonthlyTotal", where "MonthlyTotal" is defined as
a name for a cell.
Using Absolute 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.
