Relative reference

Excel glossary definition

A cell reference (like A1) that adjusts when copied to other cells.

Definition

When a formula containing a relative reference is copied, Excel shifts the reference by the same number of rows and columns it was moved.

Back to Excel glossary