Microsoft Office Tutorials and References
In Depth Information
Copying Formulas
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:
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.
Search JabSto ::

Custom Search