in cell reference if you copy formula to another cell the cell reference to the formula will change according

the type of reference

Explanation:

There are many cell reference types eg relative, absolute and mixed cell referencing. if you write your cell reference in relative type then it will change as you copy it to another cell. if you select absolute cell referencing then it will not change if you copy to another cell.