In Relative referencing, there is a change when copying a formula from one cell to another cell with respect to the destination. cells’ address Meanwhile, there is no change in Absolute cell referencing when a formula is copied, irrespective of the cell’s destination. This type of referencing is there by default. Relative cell referencing doesn’t require a dollar sign in the formula. If you don’t want a change in the formula when it’s copied across cells, then absolute referencing requires you to add a dollar sign before and after the column and row address.