Forum Discussion
Solved
Fill handle and formula settings wrong?
Lately, my fill handle has gone off the rails. I used to double click on the little arrow and the rest of the column would get the formula. Now it just copies the data(using the same formula). I do...
Check on ribbon if Formulas->Calculation Options is set to Automatic
Also, with the "copied" formula (referencing different cells for data), if I go down the column or row, open the formula, and push enter, it will now display the proper information.
Check on ribbon if Formulas->Calculation Options is set to Automatic
- Yes, this is it! Thanks so much!