This has only started happening recently, where I have say a list of values:

```
A B C
_ _ _
1| 1 4 5 [=sum(A1,B1)]
2| 2 5
3| 3 6
```

I have my formula in cell C1 [enclosed in square brakcs for visualisation], and I want to duplicate it down the C column. So I select the cell, click the little black square bottom right of the cell, and drag it down.

The result is this

```
A B C
_ _ _
1| 1 4 5 [=sum(A1,B1)]
2| 2 5 5 [=sum(A2,B2)]
3| 3 6 5 [=sum(A2,B2)]
```

The sums don't actually evaluate until I go into each one individually, and click the formula bar, and click `Enter`. I don't want to have to do this for hundreds of rows.

Is there a 'Re-evaluate all Formulas' button? Like in Word, you can re-evaluate all items in a Table of Contents...

fill handle:) – Cornelius Jul 21 '10 at 7:53