How to see revision history in Google Sheets on Mac: steps for the browser app

Google Sheets runs in a web browser on your Mac. The official Google pages I checked describe it as a browser app, and none of them list a Mac app. So the steps here assume Chrome or Edge, with the Sheets page open like any other website. Google does not publish version numbers for the web app, so these steps match the layout on Google's help pages as I checked them on 7 November 2026. If Google moves a button, the button's name is your best guide.

Before you start: edit access and the right browser

Revision history needs edit access. If someone shared a view only link with you, the Last edit link will not show earlier versions. Google's help says view only access does not show version history at all. Ask the owner for Editor rights, or ask them to restore the version for you.

Pick the browser on purpose. Google's offline setup page names Chrome and Microsoft Edge for Docs, Sheets, and Slides. It does not name Safari. I did not test Safari, so if the panel misbehaves there, open the same file in Chrome and compare what you see.

• Edit access to the spreadsheet, not view only access
• Chrome or Microsoft Edge on the Mac
• A file that stays within Google's size limits

Size matters more than most people expect. Google's Drive help says a Sheets file can hold up to 20 million cells or 100MB. If your file is near either limit, consider splitting it into smaller files before you depend on long version history.

Open revision history from the Last edit link

Start at the top right of the sheet. Google's help says to click Last edit there. A panel opens on the right, and it lists the earlier versions of the file. Click one, and the sheet shows that version. Only the preview changes. Your current file stays the same until you restore.

Preview before you act. Click two or three versions and read the numbers. Check the tab names, the totals, and any formula you rely on. People often restore the first version they see, then find a second problem. A short look at a few versions first costs very little.

If you prefer the keyboard, press ⌘ ⌥ ⇧ H. Google's keyboard shortcut list gives that combination for Open revision history on Mac. Use it when your hands are already on the keys and you want the panel without moving to the top right of the window.

Restore an older version without losing work

Restoring rolls the live sheet back to the version you picked. Google's help says to click Restore this version, then confirm with Restore. Anyone else who opens the file will see the older content once the restore finishes.

A restore has a cost you should plan for. Google says a restore clears the cell by cell edit history for changes made before it. If you may need that history later, copy the file first. A copy keeps the current state in its own file.

Here is a common case. A budget sheet loses a total on Tuesday. You open revision history, find the Monday version, and make a copy named Budget Monday. You compare the two totals, type the one number you need back into the live sheet, and leave the rest alone.

To make the copy, click More next to the version, choose Make a copy, enter a name, choose a location, and click OK. Google also lets you share the copy with the same people. You can skip that step if you only need the numbers for yourself.

Name versions so you can find them later

Named versions are the checkpoints you can find again. Open More next to a version and choose Name this version. Type a label that says why it matters, such as Before client review. Google's help says each spreadsheet can hold up to 15 named versions.

Use the filter when the list gets long. Turn on Only show named versions, and the panel hides the unnamed entries. Turn it off when you want the full list back.

Fifteen slots go fast on a sheet that changes all week. Name a version before a big change, such as an import or a restructure. That way the label sits on the file you will want to return to.

Mistakes people make with Sheets version history

• Clicking Last edit on a view only file and expecting history. Ask for edit access first.
• Restoring before making a copy, then needing the old cell history later.
• Naming a version after the damage is done instead of before the change.
• Trusting Show edit history for row, column, format, or formula changes.
• Choosing Delete forever when you only wanted to tidy the list.

See who changed one cell, and what that view misses

The version list tracks the whole file. If you only want to know who typed a number, use the cell route instead. Right-click the cell and choose Show edit history. Google's help says this shows who changed the cell.

The cell route has gaps. Google lists these exceptions: added or deleted rows and columns, format changes, formula-driven changes, and changes made before a restore. If the cell history looks thin, check the version list for a structural change.

Pick the route by the question you are asking. Who edited one cell points you to the cell route. What the sheet looked like last week points to the version list. Did someone change the layout points to the version list too, because the cell route skips structural changes.

When version history is missing or empty

Start with access. View only access does not show earlier versions, and Google says so on its help page. Ask the owner to give you edit rights, then reopen the file in Chrome or Edge.

A new file can show little history. Third-party guides suggest making an edit and waiting one or two minutes before the list fills. I could not confirm that advice on Google's pages, so treat it as something to test, not a fix you can count on.

If you are on a phone, switch to a desktop browser. Third-party guides say the mobile app shows less detail. Google's pages I checked do not make that claim, so check it yourself if the detail matters for your work.

How long Google keeps history, and how deleting works

I could not find a retention period for Sheets version history on Google's pages. Third-party sites disagree, and some say the history is kept indefinitely. Do not plan around either claim. Name or copy any version you need to keep.

Deleting is a separate action, and it is permanent. Google's help lists Delete history in the version panel, with Delete forever as the final step. Google says that option is for owners with personal accounts, so a work account may not show it.

Next steps once you find the version you need

Choose one of three moves. Restore the version when the whole sheet should go back. Make a copy when you need both versions side by side. Leave the file alone when you only needed to see an old value. Then decide whether the name or the copy should stay for the next person who opens the file.