One of the settings that I always change when I first get a new Excel installation is …
Remove “Edit directly in cell”
Here is where you find that option
I guess I am too old, but I want to see and edit formulas in “Formula bar”, not where it shows.
I guess because I know the differences between Cell content and cell value