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
The cell reference will change when you copy the cell reference using a formula