Relative reference

A relative reference in Excel is a pointer to a cell or range of cells.

To help understand what this means, consider the phrase “the house next door to the right”.

By default, all references in Excel formulas are relative.

you might convert a relative reference toabsolute referencewith by using dollar sign ($) characters.