Smart Undo for Excel
Track your changes. Revert any edit. Recover deleted sheets — even after saving, closing, or running a macro.
Install FreeLast updated: February 2026
SheetGuard Smart Undo is a persistent undo system for Microsoft Excel that tracks both cell-level edits and sheet-level operations. It records the before and after value of cell edits, takes periodic full sheet snapshots every few minutes, and stores everything in IndexedDB on your local machine. Unlike Excel's built-in Ctrl+Z, Smart Undo survives saves, macro runs, and session restarts. The free tier tracks 10 operations; Pro tracks 500. All data stays on your machine.
The Problem
Excel's undo dies when you need it most
Excel's built-in undo (Ctrl+Z) has severe limitations. Close the workbook? Undo history is gone. Run a macro? Undo history is cleared. Save the file? Many operations become unrecoverable.
The most painful loss: deleting a worksheet. Excel warns you with a dialog, but once confirmed, there is no undo. If you accidentally delete a sheet with hours of work, it's gone — unless you have a backup file from before the deletion.
For power users who work with macros, this is especially frustrating. A single macro run wipes the entire undo stack, meaning you can't undo any changes made before the macro ran.
There is another subtle issue: Excel's undo is global across all open workbooks. Press Ctrl+Z while looking at Workbook A, and you might undo a change you made in Workbook B five minutes ago. This cross-workbook behavior has confused and frustrated users for decades, and Microsoft has shown no indication of changing it.
There is no built-in way to see what changed in a cell yesterday, last week, or before a macro ran. No audit trail showing what the previous value was. If someone overwrites a critical number, the original value is simply gone.
AutoSave and version history in OneDrive help with catastrophic data loss, but they are blunt instruments. You cannot selectively restore a single cell edit from 20 minutes ago — you have to roll back the entire file to an earlier point in time, losing every change made since. For granular recovery, Excel offers nothing.
"Ctrl+Z applies across ALL open workbooks — dumb af"
— r/excel community, in response to the Excel team's own AMA. This was the #1 complaint.
The Solution
A persistent undo system that tracks everything
Smart Undo combines two layers of protection into a single unified timeline. It tracks individual cell edits with before/after values, and takes periodic full sheet snapshots every few minutes. Everything is stored in IndexedDB on your machine — persistent, local, and independent of Excel's undo stack.
The real power is non-linear revert. Instead of undoing changes in strict reverse order, you can select any specific edit from the timeline and revert just that cell to its previous value. Everything else stays untouched. If someone overwrote cell D14 three hours ago and you've made fifty other changes since, you can revert D14 alone without losing any of those fifty edits.
If a worksheet is deleted, you can restore it from the most recent snapshot — complete with all cell values and formulas. No need to hunt for backup files.
The free tier keeps your 10 most recent operations. Pro users get up to 500, with older ones automatically removed to manage storage. Every operation is tied to the specific workbook you are editing, so there is no cross-workbook confusion.
Smart Undo stores data entirely on your local machine. No spreadsheet data leaves your computer — there is no cloud sync, no telemetry, and no server-side storage of your cell values. This makes it safe for sensitive financial models, HR data, or any workbook you would not want uploaded to a third-party service.
Smart Undo vs. Excel's built-in Ctrl+Z
| Capability | Excel Ctrl+Z | SheetGuard |
|---|---|---|
| Survives save & close | No | Yes (IndexedDB) |
| Survives macro execution | No | Yes |
| Per-workbook scope | No (global) | Yes |
| Non-linear revert | No | Yes |
| Before/after value tracking | No | Yes |
| Recover deleted sheets | No | Yes (snapshots) |
| Storage | RAM (volatile) | IndexedDB (persistent, local) |
How It Works
Persistent undo in four steps
Automatic tracking starts immediately
Install SheetGuard from the Microsoft Add-ins store and open it from the Home ribbon. Smart Undo activates automatically — no setup, no configuration. Cell edits and sheet operations are captured automatically using the Office.js change event API.
Everything is stored locally
Cell edits record the before and after value. Full sheet snapshots are taken periodically every few minutes so deleted sheets can be restored. All data is stored in IndexedDB on your local machine, completely independent of Excel's native undo stack. Nothing leaves your computer.
Browse the unified timeline
Open the SheetGuard sidebar to see a chronological timeline of your changes — cell edits and sheet operations together. Each entry shows the cell address, old value, new value, and timestamp. Filter by change type to find exactly what you need.
Revert any change — non-linear
Click to revert any specific edit without undoing everything after it. Restore a single cell from an hour ago, or recover an entire deleted worksheet from a snapshot. True non-linear undo that Excel has never offered.
Common questions about Smart Undo
Your spreadsheets. Your rules.
No credit card. No cloud. No cookies.
Install FreeMore from SheetGuard: