How to View Cell History in Google Sheets

To see who changed a cell in Google Sheets, right-click the cell and choose Show edit history. A box shows the most recent edit with the editor’s name, date and the previous value, and the arrows in the box step through older edits. You can see who changed a value, when they did it, and what it used to be, without scrolling through the whole file’s version history.

Online spreadsheet with a cell right-clicked and its edit history popup showing who changed the value, when, and the previous value
Show edit history reveals who changed a cell and its earlier values.

View a Cell’s Edit History

  1. Open the spreadsheet in Google Sheets on a computer.
  2. Right-click the cell.
  3. Choose Show edit history.
  4. Read the latest change: who made it, when, and what it replaced.
  5. Click the left arrow to see earlier edits, or the right arrow to move forward.

You need edit access to the spreadsheet to use this feature.

What Cell Edit History Doesn’t Show

  • Changes to formatting (colors, fonts, borders) aren’t listed.
  • Values that changed because a formula recalculated aren’t listed; only direct edits are.
  • Edits made by scripts, add-ons or imports (like IMPORTRANGE) may not appear.
  • If rows were inserted, deleted or sorted, the history for a moved cell may be incomplete.
  • Very old edits may not be available.

For these cases, use Version history.

Use Version History for Bigger Changes

  1. Click File > Version history > See version history (or press Ctrl + Alt + Shift + H).
  2. Select a version in the right panel. Changed cells are highlighted in the editor’s color.
  3. Click Restore this version to roll back, or copy what you need from the old version.
  4. Name important versions with File > Version history > Name current version so they’re easy to find later.

Can I delete edit history?

No. Making a copy of the file (File > Make a copy) creates a new file without the old history.

Get Notified When Someone Edits

  • Tools > Notification settings > Edit notifications: choose to receive an email when any changes are made, either right away or as a daily digest.
  • Conditional notifications (available on some Workspace plans) can alert you when specific cells or columns change.
  • Add comments or @mentions to discuss changes with collaborators.

Can I see cell history in Excel?

Excel for Microsoft 365 has Show Changes (Review tab) for workbooks stored in OneDrive or SharePoint.

For Word documents, see how to view edit history in Word.

If Show Edit History Is Missing or Empty

  • “Show edit history” is missing: you may have view-only access, or you’re using the mobile app, which doesn’t offer cell history.
  • “No edit history”: the cell was never edited directly, or changes came from formulas or scripts.
  • Edits show “Anonymous”: the editor wasn’t signed in to a Google account, or the file allows anonymous editing.