If you don’t want to turn the option off, but don’t always want to create calculated columns as you work in a table, you can stop calculated columns from being created automatically.ģ) Under AutoCorrect options, click AutoCorrect Options.ĥ) Under Automatically as you work, select or clear the Fill formulas in tables to create calculated columns check box to turn this option on or off. If you don’t want Excel to create calculated columns when you enter formulas in table columns, you can turn the option to fill formulas off. The option to automatically fill formulas to create calculated columns in an Excel table is on by default.
You can stop creating calculated columns.
