Figure 2 - Disabling Formula Replication in Excel Tables For most users, formula replication in tables is a welcome feature.
This problem often arises because the cells containing the formula are formatted as 'text' instead of the 'General' type.
As you have learned in this tip, you can easily do this by using Excel’s Undo feature or, more broadly, disabling this feature in Excel’s Options.
For a video demonstration of this tip, please visit
If you want to disable formula replication altogether, you can do that by changing one of Excel’s Options.
In the Excel Options window, choose Proofing and then click the Auto Correct Options button to open the Auto Correct dialog box.