absolute reference

An absolute reference can be used when replicating (copying) a formula from one cell to another in a spreadsheet. As a formula usually involves references to cells this means you should be aware of whether you want to keep the exact same reference to the cell (an absolute reference) or whether you want the reference to adjust itself according to either the row or column movement (a relative reference).

Related terms

Term sub categories