Spreadsheets

See who changed a cell and when in Google Sheets

Use Show edit history on a cell, and highlight edits by person in version history, to see who changed a figure in a shared sheet and what these tools cannot show.

Editorial illustration for See who changed a cell and when in Google Sheets

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?

  1. Right-click the cell whose value you want to check.
  2. Choose Show edit history from the menu. If the cell has never been edited, the menu may not offer it.
  3. A box appears with the editor's name, the time of the edit and the earlier value.
  4. Use the left and right arrows in that box to move between earlier edits to the same cell.
  5. 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 knowDoes it show it?What to do instead
Who typed a value into a cellYes, for edits to that cellUse Show edit history
Who changed a formula's inputNot on the formula cell; the formula's result changes because of its inputs, which are a different cellLook at the input cells, or compare versions
What a person was thinkingNoAsk them, kindly
Edits made long agoNot always; old grouped versions may be thinCheck version history for older dates
Who read the sheetNoUse 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?

  1. Note the cell, the old value, the new value, who and when.
  2. Ask the person what it was meant to be.
  3. If it was an error, fix it by typing the right value, or restore the earlier version if many cells are affected.
  4. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports