Sometimes, while editing the contents of a cell, using the arrow keys will not move the cursor but instead inserts the address to an adjacent cell.
Here is an example of this problem with a screenshot: I go into an empty cell and enter
=SUMIF( and then decide I want to use a normal
SUM instead of a
SUMIF so I hit the left arrow key once to move the cursor back, but this enters the address of the cell to the left.
It doesn't always happen, so I wonder if there are conditions which cause it to occur which can be avoided. Is there a meta key which ensure the arrows can be used for navigation? Or can this functionality be disabled entirely?