Google Sheets keeps a record of changes to each cell, so 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. This guide shows how to view a single cell’s edit history, use Version history for bigger changes, track changes with notifications, and what the feature can’t show.
Quick Answer
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. Use the arrows in the box to step through older edits.
View a Cell’s Edit History
- Open the spreadsheet in Google Sheets on a computer.
- Right-click the cell.
- Choose Show edit history.
- Read the latest change: who made it, when, and what it replaced.
- 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
- Click File > Version history > See version history (or press Ctrl + Alt + Shift + H).
- Select a version in the right panel. Changed cells are highlighted in the editor’s color.
- Click Restore this version to roll back, or copy what you need from the old version.
- Name important versions with File > Version history > Name current version so they’re easy to find later.
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.
For Word documents, see how to view edit history in Word.
Troubleshooting
- “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.
Frequently Asked Questions
Can I see cell history in Excel?
Excel for Microsoft 365 has Show Changes (Review tab) for workbooks stored in OneDrive or SharePoint.
Can I delete edit history?
No. Making a copy of the file (File > Make a copy) creates a new file without the old history.
Does cell history work on phones?
No. Use a computer, or open the desktop site in a mobile browser.
Summary
- Right-click a cell > Show edit history.
- Use the arrows to see older edits.
- Use File > Version history for formatting and bulk changes.
- Turn on edit notifications to track future changes.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.