i-nth logo
Understanding absolute, relative, and mixed cell references in Excel
10 August 2017

A worksheet in Excel is made up of cells. These cells can be referenced by specifying the row value and the column value.

The power of Excel lies in the fact that you can use these cell reference in other cells when creating formulas.

There are three kinds of cell references in Excel:

  • Relative cell references.
  • Absolute cell references.
  • Mixed cell references.
  • Understanding these different type of cell references will help you work with formulas and save time (especially when copy pasting formulas).

Full article: Understanding absolute, relative, and mixed cell references in Excel