Relative Reference in Excel

Originally published at: Relative Reference in Excel - Excelbuddy.com

Relative Reference in Excel points to a cell or range of cells. However, this is pointed to cell is not locked like an absolute referenced cell.

In Excel, all references are Relative references. As stated above, they point to a cell, but are not locked if the cell is copied or if columns/rows are added.

Most spreadsheets will use a combination of relative and absolute references.

Relative Reference in Excel

=B2

Let’s look at the example below. Since we are using Relative Reference, we cannot drag down the autofill handle since we are not locked onto cell D2. The referenced column D2 changes when dragged.