So, when the cell reference is relative, it automatically changes when you copy it or move it. To simplify it, the cell reference is relative to its location. Absolute Cell Reference(Keeping value ...