# How do I see the version history of a Google Sheet?

To see the version history of a Google Sheet on a computer, open the spreadsheet and click Last edit at the top right. A panel lists earlier versions with who made the changes; click one to see it, then click Restore this version and Restore to go back to it. You need edit permission to see version history. In a 12-tab ProfitDrawer bookkeeping spreadsheet imported to your Drive, this is a way to undo an accidental change.

**View an earlier version (computer):**

1. Open the spreadsheet.
2. At the top right, click **Last edit**.
3. Pick a version in the right panel to see who changed what. Sheets hides unmodified rows by default; click **Show unmodified rows** at the bottom right to see everything.

**Restore it:** select the version, click **Restore this version**, then **Restore**. Google notes that in Sheets, restoring clears the cell-by-cell edit history from before the restore, so make a copy first if you need that history.

**Name a version:** select it, click **More**, then **Name this version**, for example "Books closed 2026". A spreadsheet can have up to 15 named versions. Turn on **Only show named versions** to filter the list.

**Keep an old version separately:** choose **More > Make a copy**.

Limits to know:

- Some changes do not show in edit history, such as added or deleted rows and columns, and values changed by formulas.
- Google may occasionally merge revisions.

- Source: [Find what changed in a file: Google Docs Editors Help](https://support.google.com/docs/answer/190843)
- Updated: 2026-10-29
- Published: 2026-10-29
- Category: Google Sheets and Excel how-tos
- Canonical: https://profitdrawer.com/answers/how-do-i-see-the-version-history-of-a-google-sheet.html
- Publisher: ProfitDrawer (https://profitdrawer.com)