Forum Discussion

Susanne Tjalve Krebs's avatar
Susanne Tjalve Krebs
Copper Contributor
Jun 28, 2018

When editing formula, clicking new cells adds the value.

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?

excel
  • Susanne Tjalve Krebs's avatar
    Susanne Tjalve Krebs
    Copper Contributor
    Jun 28, 2018

    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?

     

Resources