In Google Sheets, open File > Version history > See version history. Click an earlier version in the panel to preview it, then press Restore this version to bring it back, or use the three-dot menu beside it to make a copy. Name a version when you close a year, so you can find that exact state again.
How do I find earlier versions?
- Open the sheet and choose File > Version history > See version history.
- A panel opens on the right. It lists versions by date and time, with the newest at the top, and often groups many small edits together.
- Click one. The sheet shows how it looked at that time, and a banner at the top tells you that you are looking at an earlier version.
- Use the arrow to expand a group and see the smaller edits inside it.
Only people with edit access normally see the full history. If you cannot find the menu option, check what access you have to the file.
What is the difference between restoring and making a copy?
| Action | What happens to the file you have | Use it when |
|---|---|---|
| Restore this version | Your file goes back to the older state; the changes since then are replaced, though the version you restored from stays in the history | You want the whole file as it was, and are sure about it |
| Make a copy (from the three-dot menu) | Your current file is untouched; a new file holds the older version | You want to look, compare, or rescue one tab or a few rows |
How do I name a version?
Plain autosaved versions are labelled by time only, so after a few months nobody remembers which is which. A named version is easy to find.
- With the file open, go to File > Version history > Name current version.
- Type a label such as FY 2026-27 closed, or Before changing categories.
- In the version panel, switch on the option to show only named versions. The list shrinks to the ones you labelled.
- You can also rename a version from the three-dot menu beside it in the panel.
A good rule: name a version at each month end, at the financial year end in March, and before any large restructure, such as merging categories or moving columns around.
What is a good routine at year-end?
- Finish the March entries and match your accounts to the statements.
- Name the current version with the year, like FY 2026-27 closed.
- Make a separate copy of the file with the same name, kept in a folder only you can edit.
- In April, start new entries in a fresh tab or a new file, so the closed year stays as it was.
What can version history not do?
- It cannot bring back a file that has been permanently deleted from Drive; look in the bin first, and note that the bin has its own time limit.
- It does not keep every keystroke; small edits are grouped, so you may not find an exact state from an hour ago.
- It does not replace a backup. If the file is lost or you lose access to the account, the history goes with it.
- Pasting a block of values over a formula loses the formula in later versions; restore only if you notice in time.
How do I find out who changed what?
Inside the version history panel, there is a tick box to show changes. It colours the cells that differ from the previous version and names the person who made each change, in a colour linked to them. A separate article in this series covers the edit history for one cell.
Quick reference
- Open: File > Version history > See version history.
- Name: File > Version history > Name current version.
- Compare: tick the option to show changes.
- Safe look: use the three-dot menu and make a copy.
- Undo for good: restore, only when sure.
Version history helps when you slip up inside one file. If your records grow past what a sheet is good at, SpendixAI keeps deleted transactions in a recycle bin for 30 days, which is a similar safety net for an app-based record.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
