Cells and formulas · Copy a formula downWorks in: all current Excel versions, Google Sheets
Write once, fill down
You rarely type the same formula twice. Write it once, then copy it to the cells below by dragging the small square at its bottom-right corner (the fill handle), or double-click the handle to fill down as far as the data next to it goes. You'll drag it yourself in this lesson; later lessons copy it for you.
As the formula moves down a row, its references move with it: =B2*C2 in D2 becomes =B3*C3 in D3, then =B4*C4. These are relative references: they really mean “the cells in my row”. Copy a formula to the right instead and the column letters move: =B2*C2 in D2 becomes =C2*D2 in E2.
- Typing a separate formula in every row: slow, and easy to get one wrong.
- Writing the first formula for the wrong row: a formula in D2 must point at row 2.
Tap Try it to fill the whole Total column.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Sold | Price | Total |
| 2 | Sourdough loaf | 14 | $6.50 | |
| 3 | Croissant | 32 | $2.80 | |
| 4 | Cinnamon bun | 21 | $3.20 | |
| 5 | Baguette | 18 | $3.00 | |
| 6 | Rye loaf | 9 | $7.00 |
Tap Try it to type =B2*C2 into D2.
Go deeper: Absolute and relative references