Copy Formulas with the Fill Handle

Note: Copying formulas to other cells only works if you created your formula using cell references.

In the image to the right, the formula in cell D1 can be seen in the formula bar.

To copy formulas with the fill handle:

1. Create the formula in the appropriate cell on the spreadsheet.
   
   
2. Click on that cell to make it the active cell.
   
   
3. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the active cell.
   
   
4. Drag the fill handle to copy the formula to as many cells as needed.

Related Articles

• Customizing Excel 2007 Auto Fill Handle
• Adding Data with the Auto Fill Handle
• Cell References in Formulas