Microsoft Office Tutorials and References

In Depth Information

**Calculating the total cost for each item**

How has this worked? You’ll see that Excel has changed the formula as it has

copied it. As it moved down each row, Excel changed the row reference in the

formula before pasting it. The formula was taken from row 4, but when it was pasted

into row 5, Excel changed all the references from row 4 to row 5. This ensures that

the total euro cost in row 5 is based on the price and quantity cells in row 5. Click

on the total euro cost cell for row 5, and you’ll see the formula is:

=B5 * D5

Excel made these changes for each row you pasted into, as you can conﬁ rm by

looking at the formula for those cells.

A quicker way to copy

If you’re copying into cells next to the cell you’re copying from, as we are here,

there is a quicker approach you might want to try:

1.
Click on the cell you want to copy from.

2.
Hold down the CTRL key.

3.
Click the bottom right corner of the cursor so that it turns into a small plus sign.

4.
Hold down the mouse button.

5.
Move the mouse pointer to select the cells to paste into.

When you release the mouse button, the contents of the ﬁ rst cell will be copied

into the selected cells. The formulae will be modiﬁ ed as they are with normal

copy and paste.

If you don’t hold down the CTRL key, Excel does a ‘series ﬁ ll’. In this case,

you might not spot a difference. But if you enter ‘January’, Excel will put the

other months in turn into the cells. You can also put a number in one cell,

another underneath it, and then select both cells. If you then follow steps 3

and 4 above, Excel will complete the sequence of numbers for you.