Click and hold on the fill handle and drag to the right (or down) to fill in the other cells.
Select the cell(s) with the formula and move the cursor over the little block in the lower right corner of the active cell, and the cursor changes to a hairline plus sign (+), as opposed to the usual block plus sign.Ģ. To use AutoFill with formulas, insert the formula and make sure it works (see Formulas and Functions for more information about working with formulas)ġ.
