To see who changed a cell in Google Sheets, right-click the cell and choose Show edit history. A small panel names the editor and the time of each change, and arrows let you step back through earlier edits. For a wider view, open version history and tick the option that shows changes by person.
How do I use Show edit history on a cell?
- Right-click the cell whose value you want to check.
- Choose Show edit history from the menu. If the cell has never been edited, the menu may not offer it.
- A box appears with the editor's name, the time of the edit and the earlier value.
- Use the left and right arrows in that box to move between earlier edits to the same cell.
- Press the cross to close it.
Say a monthly electricity bill cell, E7, shows 5,200 where you remember 2,400. The history on E7 might show that one account changed it from 2,400 to 5,200 on one evening, and you can ask that person about it. It is usually a typo or a different bill, and the history lets you ask without guessing.
How do I see all changes by person in version history?
Open File > Version history > See version history. Choose a version in the panel, then tick the option to show changes. Cells that changed since the version before it are highlighted, and each highlight colour matches a person listed with their name. This is the better tool when you do not know which cell to look at.
- Start with the latest version and click the version just before it to compare.
- Step back through versions until the odd figure first appears.
- Hover on a highlighted cell to see what changed.
Who counts as a person in the list?
The name comes from the Google account that made the edit. If the sheet was shared with anyone who has the link and they were not signed in, their edits appear under a generic anonymous label, and you cannot tell who it was. For a couple's sheet, share with named accounts and turn off open link editing, so every edit has a name against it.
What can edit history not show?
| You might want to know | Does it show it? | What to do instead |
|---|---|---|
| Who typed a value into a cell | Yes, for edits to that cell | Use Show edit history |
| Who changed a formula's input | Not on the formula cell; the formula's result changes because of its inputs, which are a different cell | Look at the input cells, or compare versions |
| What a person was thinking | No | Ask them, kindly |
| Edits made long ago | Not always; old grouped versions may be thin | Check version history for older dates |
| Who read the sheet | No | Use the sharing list to see who has access |
Do not treat the history as proof of blame. Autofill, a paste across many cells and an undo can all leave odd traces. Use it to start a conversation.
What should I do once I find the change?
- Note the cell, the old value, the new value, who and when.
- Ask the person what it was meant to be.
- If it was an error, fix it by typing the right value, or restore the earlier version if many cells are affected.
- If it keeps happening, change the sharing or lock the cell so only you can edit it.
How do I make mistakes less likely?
- Move people who only need to read to viewer or commenter.
- Protect formula columns with Data > Protect sheets and ranges.
- Use a dropdown for categories, so typed variations are impossible.
- Ask everyone to put a short comment on a cell whenever they change a figure that is not a new entry.
If you would like each transaction to keep its own account, category and receipt in one place, rather than a cell history, SpendixAI has a dashboard and reports over your imported statements. Its workspace is personal, so it is not a shared-edit sheet for a family.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


