Relative Cell Reference

In spreadsheet applications, a reference to a cell or group of cells by indicating how far away it is from some other cell. For example, in Lotus 1-2-3 and many other spreadsheet programs, the cell reference “C2” is relative. Initially it points to the cell in the third column and second row, but it does this by specifying how far away this cell is from some other cell. For example, if you insert this reference in cell A1, the program will translate it to “2 columns right and 1 row down”. If you then copy the reference to cell B4, it will now point to cell D5.

In contrast, an absolute cell reference always points to the same cell, no matter where the reference appears.

Webopedia Staff
Webopedia Staff
Since 1995, more than 100 tech experts and researchers have kept Webopedia’s definitions, articles, and study guides up to date. For more information on current editorial staff, please visit our About page.

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...

ScalaHosting

ScalaHosting is a leading managed hosting provider that offers secure, scalable, and affordable...

HRIS

Human resources information system (HRIS) solutions help businesses manage multiple facets of their...

Best Managed Service Providers...

In today's business world, managed services are more critical than ever. They can...