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).