Forum Discussion
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...
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?