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.

Common mistakes
  • 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.

ABCD
1ItemSoldPriceTotal
2Sourdough loaf14$6.50
3Croissant32$2.80
4Cinnamon bun21$3.20
5Baguette18$3.00
6Rye loaf9$7.00

Tap Try it to type =B2*C2 into D2.

Go deeper: Absolute and relative references