Copy the formula in cell A1 to A2, and it updates the row reference to =A2. In other words, if you copy the relative formula =A1 to cell B1, Excel updates the reference to reflect the move one column to the right and enters the formula =B1. A relative reference adjusts when you copy the formula.You probably know the difference between a relative and an absolute cell reference:
