9. Relative cell references

Advantages
Disadvantages
A formula can quickly be copied to a range of other cells Any mistake in a formula will be replicated to all other cells that are copied from the original formula
When replicated, the relative cell reference will automatically update itself If a formula is referencing just one cell, it will not stay in that cell once copied to other cells
  If a change is made to the original formula, it will need to be recopied to all the other cells

 

 

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Formula and Functions