Microsoft Office Tutorials and References
In Depth Information
Copying Formulas
Follow these steps:
Be Sure You Know What
You Want to Copy
1. Click the cell containing the formula you
want to copy. For example, you might click in
cell B15. After you click, a dark border appears
around the cell, indicating that it’s the active
cell.
If your copied formulas contain errors, it
may be because cell addresses changed that
maybe shouldn’t have. If you do not want
a cell address to change when you copy it,
you can change the cell address from a
relative reference to an absolute one. See
the upcoming section “Creating an Absolute
or Mixed Formula Reference” for help.
2. Move the mouse pointer to the lower-right
corner of the active cell. The mouse pointer
changes to a cross.
3. Drag the AutoFill handle (the cross) down
the column or across the row to copy the
formula to adjacent cells. For example, you
might drag the AutoFill handle across row 15
to copy the September Net Income formula
shown in Figure 2-9 across the row to the
other months.
Sometimes, you don’t actually want to copy
the formula, but its result, to another part
of the worksheet. See the section “Copying
Values Instead of Formulas” for more info.
4. Release the mouse button to copy the formula.
Again, the cell references in the original
formula are adjusted to reflect the new
column/row to which the formula is copied.
For example, if cell B15 contains the formula
=B13–B11, and you copy it to cell B16 (one
row down), then the formula is changed to
=B14–B12 (the row part of the cell addresses
is changed by one row). If you copy that
same formula to cell C15 (one column over),
then the formula is changed to =C13–C11
(the column part of the cell addresses is
changed by one column).
Copying with Copy and Paste
AutoFill is perfect to use if you want to copy
formulas to adjacent cells. But what do you do
if the cells are not next to each other? Using
the Copy and Paste commands, you can copy a
formula anywhere in your worksheet—even from
one worksheet or workbook to another. Follow
these steps:
1. Click the cell containing the formula you
want to copy. A dark border appears around
the cell, indicating that it’s the active cell.
2. Click the Copy button on the Home tab to
copy the formula, or press Ctrl+C. A dashed
“marching ants” border appears around the
formula cell, as shown in Figure 2-10.
 
Search JabSto ::




Custom Search