Roll back edits in a shared spreadsheet

How to roll back edits in a shared spreadsheet: open version history, find the revision you want, restore it, and know what happens to newer changes.

3 min read2 viewsRoll back edits in a shared spreadsheet
— · 0 votes
Contents
  1. Open the version history
  2. Restore an earlier revision
  3. Keep newer work and prevent loss
  4. Questions about spreadsheet version history
  5. Are the newer edits gone after I restore an older version?
  6. Who can revert changes in a shared spreadsheet?
  7. How do I see who changed a cell?
  8. What if I restore the wrong revision?

You can roll back edits in a shared spreadsheet by opening the file's version history, choosing an earlier revision, and restoring it so that revision becomes the current copy. The version history lists saved revisions of the file along with who changed what. Restoring an older version does not quietly delete the work done after it. The sections below explain where to look, how restoring works, and how to keep a record of shared editing.

Open the version history

Version history is the panel in a shared spreadsheet that stores saved revisions of the file over time. Open it from the file menu, where the option to see change history or version history sits. Each entry shows a date, the account that made the change, and the cells affected. You read the history first to find the revision you want before you change anything.

Restore an earlier revision

Restoring an earlier revision makes that saved copy the current version of the spreadsheet. Select the revision in the version history and choose the restore option, then confirm in the prompt. The spreadsheet returns to the state of that revision, and the newer edits leave the current copy. Anyone with edit access sees the restored file when they open or refresh it.

Keep newer work and prevent loss

Rolling back does not have to destroy the work done after the revision you restore. Make a copy of the current spreadsheet before you restore, so the newer edits stay in a separate file. You can also copy the newer content back into the restored sheet cell by cell. Decide with your co-editors which changes to keep before you restore anything.

Questions about spreadsheet version history

Are the newer edits gone after I restore an older version?

The newer edits leave the current copy of the spreadsheet when you restore an older revision, but they are not erased from the file's version history. The edits still appear as revisions in the history panel, so you can open them and copy content back. Keep a copy or a note of newer work before a restore to make recovery simple.

Who can revert changes in a shared spreadsheet?

Anyone with edit access to the spreadsheet can open the version history and restore a revision. Viewers and commenters can read the history but cannot restore it in most spreadsheet tools. Check the sharing settings before you ask a family member or colleague to roll back an edit.

How do I see who changed a cell?

The version history shows each revision with the account that made it, so you can trace a cell back to its editor. Select a revision and the changed cells are highlighted in the sheet view. Shared editing leaves this record behind as long as the file's history is kept. Note the account name you need before you restore anything.

What if I restore the wrong revision?

If you restore the wrong revision, open the version history again and restore the correct one from the list. The mistaken restore is itself saved as a revision, so nothing disappears permanently. Act quickly, before co-editors copy or publish the wrong version. Keep the version history open while you correct the mistake.

Latest articles