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:
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.
In the example shown, the formula in E4 contains two relative references that will change as follows when copied down column E:
An absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. Unlike a relative reference , an absolute reference refers to an actual fixed location on a worksheet. To create an absolute...
An mixed reference in Excel is a reference where part of the reference is absolute and part is relative. For example, the following references have both relative and absolute components: = $A1 // column locked = A$1 // row locked = $A$1:A2 // first...