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.

Read Also:

  • remanufactured cartridge

    In inkjet printing, a remanufactured cartridge is an OEM cartridge that has been used, but are remanufactured (recycled) and refilled with ink. Some printer manufacturers do offer remanufactured cartridges.

  • remote

    In networks, remote refers to files, devices, and other resources that are not connected directly to your workstation. Resources at your workstation are considered local.

  • remote access

    The ability to log onto a network from a distant location. Generally, this implies a computer, a modem, and some remote access software to connect to the network. Whereas remote control refers to taking control of another computer, remote access means that the remote computer actually becomes a full-fledged host on the network. The remote […]

  • Remote Access Server

    A server that is dedicated to handling users that are not on a LAN but need remote access to it. The remote access server allows users to gain access to files and print services on the LAN from a remote location. For example, a user who dials into a network from home using an analog […]

  • remote attack

    Any malicious attack that targets any computer other than the computer the attacker is currently logged on to. For example, the attacker can log on to a system but actually attack any computer or server on the same network.


Disclaimer: relative cell reference definition / meaning should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. All content on this website is for informational purposes only.