Absolute cell reference | Article about absolute cell reference by The Free Dictionary
absolute cell reference
absolute cell reference[¦ab·sə‚lüt ′sel ‚ref·rəns]
A cell reference used in a formula in a spreadsheet program that does not change when the formula is copied or moved.
absolute referenceAn address or pointer that does not change. For example, in a spreadsheet, a cell with an absolute reference does not change even if copied elsewhere. Contrast with relative reference. See explicit link.
References in periodicals archive
Learn some basic functions and formulas and how to use absolute cell reference
. Other things discussed include Tables and PowerPivot Tables.
Notice the absolute cell reference
($) should be used before copying this formula to other cells.
Remember to use an absolute cell reference
when referring to your table_array before copying.