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).
Get the Free Newsletter
Subscribe to Daily Tech Insider for top news, trends & analysis
This email address is invalid.
Get the Free Newsletter
Subscribe to Daily Tech Insider for top news, trends & analysis
This email address is invalid.
Related Articles
Virtual Private Network (VPN)
A virtual private network (VPN) encrypts a device's Internet access through a secure server. It is most frequently used for remote employees accessing a...
Gantt Chart
A Gantt chart is a type of bar chart that illustrates a project schedule and shows the dependency between tasks and the current schedule...
Input Sanitization
Input sanitization is a cybersecurity measure of checking, cleaning, and filtering data inputs from users, APIs, and web services of any unwanted characters and...
IT Asset Management Software
IT asset management software (ITAM software) is an application for organizing, recording, and tracking all of an organization s hardware and software assets throughout...
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...