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.
to a cell
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).