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?
How to avoid selecting a cell address when using the arrow keys while editing a cell
google spreadsheets
Short answerGoogle Sheets doesn't have meta-keys that disable cell navigation and referencing during the edition of a formula and this behaviour can't be disabled. WorkaroundsAdd ) before pressing the left arrow key.i.e. if you write =SUMIF(, press ) so you have =SUMIF(). Now press the left arrow key.Press Backspace instead of the left arrow key.ReferencesKeyboard shortcuts for Google Sheets - Docs editors Help