Let’s take a look.
This is a perfect tool for relative cell references.
To start off, we’ll create our first formula in cell E6.
We want to multiply the quantity times the unit cost, so our formula is = C6 * D6.
Note that C6 and D6 are relative references which is Excel’s default behavior.
For our first item, we get a total of $25.00 since 2 x 12.50 = 25.
If we change the quantity, we see the total recalculate as expected.
To fill in the rest of the formulas, we could just enter each formula manually.
But that’s a lot of busy work and it isn’t necessary.
Instead, let’s take advantage of relative references and just copy and paste the formula down the rows.
Control-C to copy; Control-V to paste.
If we check the copied formulas, we see that they have been updated as needed.
Note that we could have used the Fill handle to copy the formulas as well.
If we undo the paste using Control-Z, we can drag the Fill handle to copy the formulas.
Or, we could just double-smack the Fill handle.
Either way, the result is the same.
