Microsoft Office Tutorials and References
In Depth Information
Copying Formulas with AutoFill
Here’s how you can use AutoFill to copy one formula to a range of cells. In
Figure 4-5, you can see the Mother Goose Enterprises – 2013 Sales worksheet
with all the companies, but this time with only one monthly total in row 12,
which is in the process of being copied through cell E12.
Figure 4-5:
Copying
a formula
to a cell
range with
AutoFill.
Figure 4-6 shows the worksheet after dragging the fill handle in cell B12 to
select the cell range C12:E12 (where this formula should be copied).
Figure 4-6:
The
worksheet
after
copying
the formula
totaling the
monthly
(and
quarterly) sales.
Search JabSto ::




Custom Search