A relative reference in Excel is a pointer to a cell or range of cells. For example, a relative reference to cell A1 looks like this:

=A1

A relative addresses will change when copied to other location in a worksheet because it describes the "offset" to another cell, rather than a fixed address. To help understand what this means, consider the phrase "the house next door to the right". You can only understand the location of this house if you understand the starting point, because the location is described in relative terms.

By default, all references in Excel formulas are relative. You can convert a relative reference to absolute reference with by using dollar sign ($) characters.

Example

In the example shown, the formula in E4 contains two relative references that will change as follows when copied down column E:

=C4*D4
=C5*D5
=C6*D6
=C7*D7
=C8*D8

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass