Forum Discussion
Remove autofill formulas
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
6 Replies
Same for me. I have turned if off and Excel continues to insert $73,000 in blanks cells and other formulas from various selected places without my consent.
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.
Riny_van_Eekelen Hi - I have done this but excel keep on autofilling new formulas I enter in excel.....
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.
