Relative Reference

The cell reference will change when you copy the cell reference using a formula – B4 will change whenever it is copied. If you copy one row down and one column across the B will change to a C and 4 will change to a 5