Two simple ways to stop Tables from auto-filling formulas in new columns.
Auto-filling formuals in Tables can be nice or terribly annoying, but now you will learn how to control this feature.
Ctrl + Z after inputting the formula in the column.
File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type tab > uncheck Fill formulas in tables to create calculated columns.