Module 1 · Lesson 3
Copying formulas
Use relative references and the fill handle to repeat reliable logic.
Relative references move with the formula
Most references are relative by default. Copying a formula down changes its row numbers so every record uses values from its own row.
D2: =B2*C2 → D3: =B3*C3Fill only after checking the first row
Confirm that the first formula is correct, then drag the fill handle or use Fill Down. Finally, inspect the first and last copied formulas.
- Check the first result.
- Fill the complete target range.
- Inspect a formula near the bottom of the list.
Key takeaway: When =B2*C2 moves down one row, Excel changes it to =B3*C3.