absolute cell reference

absolute cell reference

[¦ab·sə‚lüt ′sel ‚ref·rəns]
(computer science)
A cell reference used in a formula in a spreadsheet program that does not change when the formula is copied or moved.
McGraw-Hill Dictionary of Scientific & Technical Terms, 6E, Copyright © 2003 by The McGraw-Hill Companies, Inc.

absolute reference

An 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.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
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.
Books and enrichment Submit your events at dailyherald.com/share
Notice the absolute cell reference ($) should be used before copying this formula to other cells.
Double-teaming in Excel: spreadsheets now can solve tougher calculations
Remember to use an absolute cell reference when referring to your table_array before copying.
Make Excel a little smarter: teach your spreadsheets some useful tricks
Encyclopedia browser ?
Full browser ?