By default, Excel recalculates all the formulas in your worksheet automatically when you open your worksheet or change any entries, formulas, or names on which your formulas depend.
If you worksheet is large, with many formulas, this can take several seconds or minutes.
Immediately click the Undo button on the Quick Access Toolbar or use the CTRL Z keyboard shortcut and you will notice that all of the other formulas return to their original state and that the formula in the cell of interest is now different from all of the other formulas in that column.
However, editing the formula in that column for that row would ordinarily change the calculation for the entire column because, by default, formulas always replicate throughout the entire column in a table.
Even if I edit cell (F2 button) and I hit ENTER, I do not see updated formula (as long as I will not use CTRL SHIFT F9).
I think that this "feature" might be a source of confusion.
One of the primary advantages associated with using tables in Excel is formula replication – formulas that automatically copy down a column in a table, even as the volume of data changes.
However, in some cases you may not want this feature to engage.