Microsoft Office Tutorials and References

In Depth Information

**Copying Formulas**

Another thing that’s cool
about Excel’s

formulas is how easy it is to reuse them. For

example, after you carefully type in a formula

that calculates the number of black bean

taquitos available for sale during August, taking

into account any deliveries or returns during the

month, you don’t want to repeat the process

with the next item in your inventory. Luckily,

Excel allows you to copy formulas, automatically

adjusting the cell references for you. For example,

if you copy that formula for black bean taquitos

to the jalapeño-apple salsa row, the cell references

are automatically adjusted so you calculate the

adjusted opening inventory for salsa and not

taquitos. In Figure 2-8, the formula in cell E12,

which calculates the adjusted opening inventory

for taquitos, is =B12+C12–D12. When copied to

cell E15 (the salsa row), the formula is adjusted

so that it uses similar cells in row 15 instead:

=B15+C15–D15.

Figure 2-8

When formulas are copied, cell references

are automatically adjusted to reflect

the formula’s new location.

Copying with AutoFill

Typically, you will want to copy formulas to

nearby cells so they can use similar data. For example,

in Figure 2-9, you might type the formula for

September total expenses in cell B11, and then

copy that formula across row 11 to the other

month columns. The simplest way to copy

formulas to adjacent cells is to use AutoFill. With

AutoFill, you simply drag from the source cell to

copy its data to adjacent cells. In this case, you

will copy a formula from one cell to nearby cells,

simply by dragging over them with something

called the AutoFill handle.

Figure 2-9

Use AutoFill to copy formulas to adjacent cells.