Forum Discussion

Copper Contributor

Jul 23, 2022

Excel still autofilling formulas to next columns even turned off

A simple example here: I created a formula to Column A10: =IF(A4=A2:C2;E4;"") Problem is that Excel365 is auto filling that formula to Columns B10 and C10 also. And I cant edit Columns B10 an...

Formulas and Functions

SivFOR

Copper Contributor

Aug 20, 2022

I have the same problem - turned off autofill, but excel keep on autofilling the cells with formulas from one cell. Did you manage to turn it off??? Please share.... Thanks 🙂

Tarmo15

Copper Contributor

Aug 22, 2022

No, still the have same problem. I had to make extra calculations that I managed to move on.