When you copy a formula to another cell, its references move with it. Copy one row down and A2 becomes A3. These are called *relative* references.
B2 contains =A2*2. You copy B2 into B3. What formula is in B3?
Loading spreadsheet…
When you copy a formula to another cell, its references move with it. Copy one row down and A2 becomes A3. These are called *relative* references.
B2 contains =A2*2. You copy B2 into B3. What formula is in B3?