Google Spreadsheet forces you to be in overtype mode whenever you edit an existing formula.

The only way out I know is to type gibberish. That is, for how every many characters you want to insert, you type however many gibberish -- while still losing a few meaningful formula characters.

Is there a way convert to insert mode when editing formulas on Google Spreadsheets?

Note: Insert key does not work

  • 1
    Are you sure the Insert key on your keyboard hasn't been pressed? – Michael Frank Nov 12 '15 at 22:47

The insert toggle is sneaky - it's hard to tell when it is on, and when your context is inside of the formula bar (ie you are editing a formula) it doesn't seem possible to turn it off - context has to be out of that formula bar.

1) Click into some other cell of the sheet

2) Press the Insert key.

3) Attempt to edit the formula again.

  • It's been a while. I can't find the place where the problematic scenario in my question occurred and can't verify your answer, even though it seems right :/ – Argyll May 16 '16 at 22:39

Not the answer you're looking for? Browse other questions tagged or ask your own question.