Tap to overwrite cell Google Sheets on Android?

Question

I have a Google Sheets golf scorecard which I use on my Android 7 phone. I use it to capture my scores at the end of the round, to calculate stableford points and adjust my handicap. Each time I want to quickly enter a score for each hole, overwriting the previous entry in each cell. However when I tap on a cell which contains an existing number and start typing a number the new number gets appended to the existing one, rather than overwriting it.
So for example if a cell contains a 4, and I tap on it and enter a 5, the cell value becomes 45 rather than 5.
Obviously I can use the backspace key before entering each value, but that's a bit tedious when I want to quickly enter 18 values.
Is there a way of configuring the Sheets app to overwrite existing values when I tap on a cell and start typing?

arul selvan · Answer

If you overwrite the score, you will lose the old score. If you want to preserve all scores, you can create a form, linked to your spreadsheet and capture each score, with automatic time stamping. It doesn't take more than a few minutes to create a form and deploy it.

Create a sheet insert-form

That's all

Create a sheet
insert-form

That's all

Tap to overwrite cell Google Sheets on Android?

One Answer

Add your own answers!

Ask a Question