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
Embedded Analytics
Embedded analytics brings self-service business intelligence to everyday application users.
HRIS
Human resources information system (HRIS) solutions help businesses manage multiple facets of their workforce operations. They provide a central platform for human resources professionals...
Complete List of Cybersecurity Acronyms
Cybersecurity news and best practices are full of acronyms and abbreviations. Without understanding what each one means, it's difficult to comprehend the significance of...
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,...
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...