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.
Search JabSto ::




Custom Search