1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Relative Cell Address


Relative Cell Addresses in Spreadsheet Formulas

Relative Cell Addresses in Spreadsheet Formulas

© Ted French

In spreadsheet programs such as Lotus 1-2-3, a relative cell address identifies the location of a cell or group of cells.

Cell addresses are used in formulas, functions, charts , and other spreadsheet commands.

By default, a spreadsheet cell reference is relative. What this means is that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location.

In contrast, an absolute cell address does not change when it a formula is copied and pasted to other cells.

A relative cell address consists of the column letter and row number that intersect at the cell's location.

An example of a relative cell address would be C4, G15, or Z2345.

Note: When listing a cell address - either relative or absolute, the column letter is always listed first.

More information can be found under Cell Address and Absolute Cell Address.

Related Articles

Also Known As: Relative Cell Reference

©2014 About.com. All rights reserved.