In spreadsheet applications, a reference to a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell. For example, in Lotus 1-2-3 and other spreadsheet programs, the cell reference “$A$3” is an absolute cell reference that always points to the cell in the first column and third row. In contrast, the reference “A3” is a relative cell reference that initially points to the cell in the first column and third row, but may change if you copy the reference to another cell or change the shape and size of the spreadsheet in some other way. Absolute cell references are particularly useful for referencing constant values (i.e., values that never change).
Related Articles
Human Resources Management System
A Human Resources Management System (HRMS) is a software application that supports many functions of a company's Human Resources department, including benefits administration, payroll,...
How To Defend Yourself Against Identity Theft
Almost every worldwide government agency responsible for identity theft issues will tell you the same thing: The first step to fighting identity theft is...
Infographic
An infographic is a visual representation of information or data. It combines the words information and graphic and includes a collection of imagery, charts,...
Phishing
What is phishing?
Phishing is a type of cybercrime in which victims are contacted by email, telephone, or text message by an attacker posing as...
Definitions
ScalaHosting
ScalaHosting is a leading managed hosting provider that offers secure, scalable, and affordable...
Development
HRIS
Human resources information system (HRIS) solutions help businesses manage multiple facets of their...
Definitions
Best Managed Service Providers...
In today's business world, managed services are more critical than ever. They can...