Forum Discussion

Tarmo15's avatar
Tarmo15
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 and C10 as I want them to be.

I have turned this auto filling off from the settings long time ago, as it is very annoying

thing:

 

 

But for some reason it doesn't work at the moment and I can't do the things

I want at all. 

 

 

 

Formulas and Functions

3 Replies

  • SivFOR's avatar
    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's avatar
      Tarmo15
      Copper Contributor
      Aug 22, 2022
      No, still the have same problem. I had to make extra calculations that I managed to move on.
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 23, 2022

    Tarmo15 That setting under Proofing affects structured Excel tables. You seem to be working with regular ranges. The formula you entered, indeed, spill its result into three cells at once. That's a great feature of dynamic arrays. If you don't want that, you should enter:

    =IF($A$4=A2;$E$4;"") and drag across.

     

    Otherwise, what result do you want to see?

     

     

     

     

Resources