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

Relative Cell Reference

By

Relative Cell References in Excel

Relative Cell References in Excel

© Ted French
Definition:

In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group of cells.

Cell references are used in formulas, functions, charts , and other Excel 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 reference does not change when it a formula is copied and pasted to other cells.

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

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

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

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

Related Tutorials

Also Known As: Relative Cell Address

©2014 About.com. All rights reserved.