Excel Tips Tutorial: How to Stop Automatically Creating Calculated Columns in Excel Tables
If you were to add a formula to a column directly to the right of an Excel table, Excel will automatically add a new column to the table and fill every row with the same formula. If you want to turn off automatically calculated table columns simply follow the steps below.
Step 1: Enter a formula in a cell directly to the right of your table and press Enter. A new table column will automatically be added with all the formula automatically filled into all rows of the new column. A SmartTag will also appear in the cell where you first entered your formula.
Step 2: Click on the SmartTag and a drop-down menu and select Stop Automatically Creating Calculated Columns.
Now when you add a formula to a column Excel will provide you with a SmartTag that allows you the option to add the same formula to all rows instead of automatically filling all rows with the formula.
Removing automatically calculated columns is useful when you need to add different formulas into different rows within a table.