4 ms·
I just made an Excel sheet, put in formulas and I could just type over any formula with numbers without any notifications or errors. How do you manage to requi
by theshrike79 3y ago
I just made an Excel sheet, put in formulas and I could just type over any formula with numbers without any notifications or errors.
How do you manage to require "a handful of clicks" to do it?
- mkishi 3y agoThis only happens in "proper" tables. When you add a formula to a table column, Excel will automatically convert it into a "calculated column," so overridden values will have a green mark denoting an "inconsistent formula." It's still a pretty minor warning and it only requires two clicks to ignore.