Microsoft Office Tutorials and References

In Depth Information

**Copying Formulas Using Fill**

Tip

Numbers in Formulas
You can also include an actual number in a for-

mula instead of two cell references. For example, you could create a

formula such as =A6-10, which subtracts 10 from the amount in cell

A6.

Copying Formulas Using Fill

Similar to filling a pattern of days or months, Excel can also fill cells with the pattern of

a formula. For example, you might want to copy a formula if you have multiple rows or

columns that require the same calculation.

Select the cell that has the formula you want to copy.

Position the mouse pointer on the lower-right corner of the beginning cell.

The mouse pointer becomes a crosshair.

Press and hold the mouse button, and drag to select the next cells to be

filled in.

Release the mouse button. Excel copies the formula to all the selected cells.