Copying a formula down

1 / 6

Each Total is the Qty times the Price.

keyboard Typing formulas is easiest on a computer with a keyboard.

A1
ABCDE
1ItemQtyPriceTotal
2Monitor Stand240.49
3Headset551.99
4Office Chair340.5
5Bookshelf855.99
6USB-C Hub342.5
7
8
9
10
11
12
Qty
Price
Total
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
Study notes

In a bit more detail

  • Do you need a new formula for every row?

    No. Write the formula once and copy it down.

  • What happens to the cell names?

    Excel changes the row numbers for you as it copies: =B2*C2 in row 2 becomes =B3*C3 in row 3, and so on.

  • How do you copy a formula down?

    • Drag the fill handle, the small square at the bottom-right corner of the selected cell.
    • Select the formula cell and the cells below it, then press Ctrl+D (D for down).

Know someone fighting with a spreadsheet? Send them this page.