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...
