Tutorials

Tutorials

editors (login required)
Contents Math Bundle - Elementary Replicate Formula
Grade: K-12
Required products: Tool Factory Spreadsheet
Instructions
Once you have written a formula in one cell you can apply the same formula to multiple other cells without having to re-type the formula.

Step 1 - Select the cell with the formula.

Step 2 - Move your mouse to the white box in the bottom right hand corner of the screen. The mouse pointer will turn into a black plus sign. Click, hold, and drag the mouse to the cells you wish to apply the formula.

Now you no longer need to rewrite formulas, you can simply click, hold, and drag!
Downloadable Worksheets
  • Print Instructions on Replicate Formula (DOC)
  • Print Instructions on Replicate Formula (PDF)
    Mac users: To download, ctrl-click on the worksheet and choose "save link to disk"
  • Click images to enlarge