How to Open Version History in Google Sheets (Ctrl+Alt+Shift+H)

Ctrl+Alt+Shift+H, or Cmd+Option+Shift+H on a Mac, opens version history for the current spreadsheet — a timeline of revisions with the collaborator responsible for each. **A spreadsheet's history answers a different question from a document's.** In prose you mostly want to know what wording changed. In a spreadsheet you want to know when a number stopped being right, and who was in the file when it did. Because a formula error propagates silently into every cell that depends on it, the useful thing is not the edit itself but the moment the downstream values diverged — and the timeline is the only place that is visible. **Naming a version turns a wall of checkpoints into landmarks.** Sheets creates revisions constantly and unprompted, so a file in daily use accumulates hundreds with nothing distinguishing them but timestamps. Naming one — before a quarterly close, before a bulk import, before handing the file to someone else — gives you a point you can find again months later without binary-searching through dates. **Previewing is free; restoring is not.** Selecting a point in the timeline shows the sheet as it was, read-only, with the live file untouched. Only Restore actually reverts it. That distinction makes it safe to browse a dozen revisions looking for where a number changed, which is the normal way this feature gets used. **Restoring does not discard what came after.** The current state becomes its own revision before the older one is applied, so restoring is reversible — you can restore, discover you picked the wrong point, and restore forward again. People hesitate over this far more than the mechanism warrants. **It has limits worth knowing before relying on it.** Version history covers the spreadsheet's own content. It does not track changes made by Apps Script running on a schedule in the same detail, and on a very large file the granularity of automatic checkpoints coarsens. For anything where an audit trail genuinely matters rather than merely helps, a scheduled copy is a sturdier answer than trusting revision history alone. **Who can see it depends on their access.** Version history is available to anyone with edit rights, so on a shared file every editor can read the full record of who changed what. That is usually the point, but it is worth being aware of before working through numbers in a file shared more widely than you assumed. Viewers and commenters cannot open it at all. **A faster route for a single cell.** When the question is narrower — who last touched this one figure — right-clicking the cell and choosing show edit history answers it directly, without opening the full timeline. That is the tool for a specific number that looks wrong, where version history is the tool for understanding a period of activity across the whole sheet. **Copies do not inherit history.** Making a copy of a spreadsheet starts its revision record from scratch, so a duplicate made to preserve a state actually discards the trail that led to it. If the history matters, name a version in the original rather than copying the file — the copy looks like the safer move and is the one that loses more.