by This tutorial will help you work with version history and cell edit history in Google Sheets.
Google Sheets has many beneficial features. Saving your spreadsheets automatically while keeping records of all changes made in the file is one of them. You can access those records, look through them and restore any version anytime.
What is a version history in Google Sheets
If you're used to making copies of your spreadsheets or duplicating tabs for the record, it's high time for you to stop cluttering your Drive :) Google Sheets saves every edit automatically now and keeps logs of every change so you could look them up & compare. It's called version history.
Version history is implemented as a special Google Sheets option and shows you all changes in one place.
It contains the dates & times of the edits and editors' names. It even assigns each editor a color so you could see what has been altered by any person in particular.
How to view edit history in Google Sheets
Note. This functionality is available to the spreadsheet owners and users with the editing permissions only.
To see the entire edit history in Google Sheets, go to File > Version history > See version history:
Tip. Another way to call Google Sheets edit history is to press Ctrl+Alt+Shift+H on your keyboard.
This will open a side pane on the right of your spreadsheet with all the details:
Each record on this pane is a version of the spreadsheet that differs from the version below.
Tip. Some versions will be grouped. You'll notice these groups by a small right-pointing triangle:
Click on the triangle to expand the group and see the entire Google Sheets version history:
When you browse Google Sheets version history, you'll see who updated the file and when (names, dates and times).
Click on any timestamp and Google Sheets will show you the sheets with the contents related to that date and time.
You can also view each editor's changes. Tick the Show changes box at the bottom of the sidebar:
You will instantly see who updated the cells because their fill colors will match the color of the circles next to the editors' names in the Google Sheets version history sidebar:
Tip. To review each edit individually and to navigate between them quickly, use the arrows next to Total edits:
How to restore Google Sheets to the previous version
You can not only view edit history in Google Sheets but also restore this or that revision anytime.
Once you find the variant of the spreadsheet you'd like to bring back, hit that green Restore this version button at the top:
Tip. If you change your mind about recovering any earlier version, click the arrow instead to go back to your current spreadsheet:
Name versions in the Google Sheets version history
If you're satisfied with some variants of your spreadsheet, you can name them. Custom names will let you quickly find these versions in the edit history afterwards and prevent other versions from grouping with named ones.
In the Google Sheets menu, open File > Version history > Name current version:
You will get a corresponding pop-up inviting you to enter a new name:
Tip. You can name your versions directly from the version history. Click the icon with 3 dots next to the variant you want to rename and pick the first option, Name this version:
Type in a new name and press Enter on your keyboard to confirm:
Note. You can create only 40 named versions per spreadsheet.
To find this variant among others in the edit history quickly, switch the view from All versions to Named versions at the top of version history:
Google Sheets version history will then feature only variants with custom names:
Tip. You can change or remove the name completely later using the same More actions icon:
How to make copies of earlier file variants (or delete version history from Google spreadsheets)
You may wonder why I mention such different actions – copy and delete – in a title for one section.
You see, many of you ask how to delete version history in your Google Sheets. But the thing is, there is no such option. If you're the owner of a spreadsheet or have the right to edit it, you'll be able to view edit history in Google Sheets and restore earlier revisions.
However, there's one option that resets the entire edit history – copy the version:
Go for it, and you'll get a suggested name and a place on your Drive for that copy. You can change both, of course, and even share this copy with the same editors who have access to the current spreadsheet:
Hit Make a copy and that version will appear in your Drive as an individual spreadsheet with a blank edit history. If you ask me, it's a pretty solid alternative to deleting version history in Google Sheets ;)
See cell edit history
One more way to view the changes is to check each cell individually.
Right-click a cell of interest and choose Show edit history:
You will instantly get the most recent edit: who changed this cell, when, & what value was there before:
Use those arrows at the upper right corner to review other changes. Google Sheets even says if the value was restored from one of the earlier versions:
Note. There are some edits Google Sheets doesn't track and, hence, you won't be able to check them:
- Changes in the format
- Changes made by formulas
- Added or deleted rows and columns
This is all you need to know at the moment to track changes in data in your Google Sheets and manage & restore any variant of your file at any time.
34 comments
Thanks for this information
I have a question: Can I set it to automatically revert to a certain old version at a fixed time of day?
Thank you so much.
Hello Quang Duc,
Not with the standard functionality. You'll need to use Apps Script for that.
Maybe now you can show how to do it on mobile?
Hello J,
Sorry, we don't cover the work in the Google Sheets app for mobile.
Hello Natalia ,
I need to restore Edit history , i lost history when i use restore this version
Any solution to the problem ?!
Hello Ahmed,
I'm afraid it's impossible to see cell edits that were made prior to restoring the previous version.
Hi Team,
I have made a google sheet and someone from the user deleted one column which had important Data
Please can you help me identify who is this user and how to i protect the sheet.. where users can only add data and edit data but are not allowed to delete rows and columns
Hi Asif Shaikh,
If the users have rights to edit all data, they automatically can delete rows and columns. Unless you protect those rows & columns specifically from everyone.
Use the version history as described in this article, go from version to version and you'll see whose edits removed the column.
Is there a way to see edit history on cells that only contain inserted notes?
Hello Lea M,
Sorry, there's no way to filter the history up to cells with notes only.
Is there a wat to recover a file that was deleted over 30 day. I accidentally deleted a Google sheet file to get more storage and picked the wrong file. Is there any was to recover that deleted file even after 30 days?
Hello Maria,
If you delete a file within your organization's Drive, contact your Drive specialist. If it's your personal Drive, you need to contact Google Drive support.
Is there any option to get a version history of Google sheets on a specific date
Hello Prakash,
All versions in the version history are marked with the date so you could find and restore the one you need.
Hi, I was wondering if you could tell me more information about how to edit the name of worksheets within a google sheet. I'm really struggling and it's not clear
Hi Daisy,
If you mean the name of the copied file from the version history, it's described here. If you ask about the spreadsheet (file) in Drive, we mentioned it here. To rename the tabs within the file quickly, use this add-on or double-clik each tab that you want to rename.
Hi,
Can you please let me know why in my google sheet when I right-click the "show edit history" not showing?
Is there any way to put it?
Thanks.
Hi MFG,
To see the edit history of a single cell, you must either have editing access to the spreadsheet or be its owner.
Hello, thanks for the information.
Is it possible that a new version is created even without edits? It happened to me that version is created by itself and it doesn't show the number of edits. This happened in a large sheet multiple worksheets and with many collaborates.
Hello Ritish,
No, the version history purpose is to show different snaps of your file after some edits. If you don't see the total edits at the top, please report this to Google.
Do you know of any way to use Version History to calculate hours worked on a sheet?
I'm trying to create a log from work done on projects years ago and thought Version History did a good job clocking the times worked. Now I'm trying to figure out how to get that data into some kind of log book format?
Thx
Hello Bobby,
Unfortunately, there's no possibility to calculate records from different versions of the same document. First, you have to make copies of those earlier versions. Then you can collect them together in one document (as long as the 10M limit for cells is not exceeded) and calculate as you need.
Thank you so much!!! I'm the Project Superintendent of a construction site building 160 homes and every step of every phase of every house was tracked through Sheets and I deleted it! New emotions I didn't know existed surfaced! When I found this post... Well, I never knew the emotion of relief could be so rich!
One question... I'm about to restore the earlier version but I noticed that my formatting is not the same. Will it come back when I hit the restart button or do I need to do something else first?
Thanks again! True lifesaver!
You're most welcome, Aaron! I'm glad this article has been a huge help!
As for the formatting, it depends on what you mean exactly. But I believe it should restore to its initial form. But you can always restore the previous version to a separate spreadsheet.
Hi there, I have edited a document and now have different versions. How do I get all comments from the initial to final version in a single document?
Hi Jaysree,
You will find them by clicking the Comments icon next to the Share button and your account picture. Make sure to check the Resolved ones and on All sheets to not miss any comments.
Thanks for this information very clear and informational
A question: I am working with a few people on a google sheet, a teammate recovered a pervious version and now the right click -show edit history - only shows the restored version with nothing before that - is there a way to get the edit history back with the right click show edit history?
Hello Alan,
I'm afraid it's impossible. The restored version is a copy of the old version. As with standard copies of the files, it's treated as a new file and it doesn't save the edit history of separate cells.
Hi Natalia, I have a question regarding hirstory.I clicked the pop up saying you can make edit online and now the spreadsheet history is too slow and there is a popup saying your documents is too large you can resume editing online.So, does it mean I am offline in spreadsheet?how to get back online?please help me..I need the answer urgently.
Thank you so much.
Looking forward to hear from you.
Hi Nanie,
Your spreadsheets don't go offline unless there's no Internet connection, so please make sure your connection is stable (try turning VPN off is you use one).
Thanks for this informative blog. I have a question.
The sheet I am working with has multiple tabs. When looking at "Version history", I click on the "Show changes" check box. Then I click on one of the change records to see the changes that have been made.
It seems that I have to click on the different tabs and scroll through the sheet to find the highlighted changes.
Is there a way to cause the system to go to the appropriate tab and automatically scroll to the change?
Thank you for your feedback and a question, Hank!
There's a way to jump between edits and I've just added it to the article :) Please see the Tip and its screenshot right before this section.
Hello, I recently restore an old version and consequently, I can't see "edit history" in each cell.
I tried to make a copy of an old version but I still can't see edit history, is there anyway to see again edit history in cells? Thank you.
Hello Tanny,
I'm afraid it's impossible to see cell edits that were made prior to restoring the previous version.