How can I switch off automatic formula entry when arrow cursor key pressed?
I type any vale in any cell.
When I press the arrow key to go to an adjacent cell, the value changes in the original cell.
eg Enter "VALUE" in A1
Press down arrow key
A1 value becomes "VALUE+A2"
How do I turn this feature off please?
When I press the arrow key to go to an adjacent cell, the value changes in the original cell.
eg Enter "VALUE" in A1
Press down arrow key
A1 value becomes "VALUE+A2"
How do I turn this feature off please?
ASKER
If I open the same file on a different PC arrow keys work as normal, without formula function.
It must be something to do with the setup within Excel options on the one PC.
It must be something to do with the setup within Excel options on the one PC.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your suggestion
Yes it persisists after closing all sessions.
Yes it persisists after closing all sessions.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
([CTRL] key)
Sorry, of course it's Ctrl
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In Safe mode no Add-ins or Macros are working
Regards
Regards
ASKER
Thanks for your help.
Fanpages suggestion regarding single sesseions got me to thinking about the Temp files created by Excel which have caused me problems before.
After clearing these and rebooting the pc everything seems fine.
Fanpages suggestion regarding single sesseions got me to thinking about the Temp files created by Excel which have caused me problems before.
After clearing these and rebooting the pc everything seems fine.
Could you send sample file?
Regards