When editing formula, clicking new cells adds the value.

Update:

This happened after changing the language from Danish to English. I just tried switching it back to Danish and that fixes the problem. I do, however, need to work in English Excel, so need to find a solution that allows me to change this setting in the English version. Any suggestions would be appreciated:-)

---

Susanne Tjalve Krebs wrote:

Hi guys,

for some reason, my Excel has changed a setting, and I can't figure out how to change it back.

 

Previously when I clicked the formula editing bar, and then clicked on another cell, it would exit formula editing and move to the new cell.

But now, whenever I click the formula editing bar and click a new cell, it adds that cell to the formula.

Any ideas on how to change that setting back?

---