Remove autofill formulas

[SivFOR]

I have tried to remove / disable autofill formulas in excel 365. Following instructions in Options / Proofing and Advanced, but still not removing every time I enter a formula it fill it in rows or columns.... So frustrating

[#2]

@SivFOR I'm using Excel 365 but don't have "Options / Proofing and Advanced".

To disable the creation of so-called calculated columns in structured tables, you need to uncheck the box "Fill formulas....." on the "Autoformat As You type" tab, shown in the screen-shot below.

If this is not what you are trying to achieve, please include a screen-shot of the window with the setting you refer to.

[#3]

@Riny_van_Eekelen Hi - I have done this but excel keep on autofilling new formulas I enter in excel..... 

[#4]

@SivFOR That's odd. It works for me all the time. With the box checked AutoFill works as intended. Uncheck the box and Autofill will not occur.

[#5]

Yes, very odd - it started a day ago.... Never had the autofill activated before....

[#6]

Never had it activated either, and just spent 2 hours with Microsoft support. They re-installed office twice and still can't fix it - so have an appointment with level 2 engineer Monday morning.... Anyway, thanks for replying to me 🙂