Comments on: Version history in Google Sheets: see edit history & restore any version

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. Continue reading

Comments page 2. Total comments: 52

  1. 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!

  2. 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?

    1. 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.

  3. 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?

    1. 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.

  4. 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.

    1. 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).

  5. 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?

    1. 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.

      1. Hello Tanny,

        I'm afraid it's impossible to see cell edits that were made prior to restoring the previous version.

    2. 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.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)
Find and replace in values, formulas, errors, links, and notes
Calculate cells based on their colors
Switch between different text cases
Transform your crosstab table to a flat list
Lock top rows and left columns
Unmerge all cells in the selection
Flip adjacent cells, rows, or columns
Find duplicate or unique rows in your sheet
Compare columns or sheets for duplicates
Find duplicate or unique cells in your sheet
Join values in the selected cells, rows, or columns
Update data in the main table with the info from the lookup table
Combine duplicate rows and merge unique data referring to the same record
Combine data from multiple sheets into one
Manage tex in different ways
Apply lower, upper, sentence case; toggle and capitalize cells
Insert text to any position in selected cells
Replace accented characters, symbols, and codes
Remove all unwanted characters
Delete multiple substrings or individual characters
Get rid of extra spaces and delimiters
Erase characters by their position in selected cells
Eliminate all blank and unused rows and columns
Сlear data by type
Split values to columns by any character or a string
Divide text from one cell into multiple columns
Pull records apart by position
Separate first and last names; pull titles, salutations, and other name units
Convert relative to absolute and back, replace formulas with values, modify all formulas at once
Turn text to number and date format, export data to JSON or XML
Fill the range with random passwords, dates, numbers, custom values, or booleans
Shuffle the selected cells, rows, or columns
Find and replace in values, formulas, errors, links, and notes
Calculate cells based on their colors
Switch between different text cases
Transform your crosstab table to a flat list
Lock top rows and left columns
Unmerge all cells in the selection
Flip adjacent cells, rows, or columns
Find duplicate or unique rows in your sheet
Compare columns or sheets for duplicates
Find duplicate or unique cells in your sheet
Join values in the selected cells, rows, or columns
Update data in the main table with the info from the lookup table
Combine duplicate rows and merge unique data referring to the same record
Combine data from multiple sheets into one
Manage tex in different ways
Apply lower, upper, sentence case; toggle and capitalize cells
Insert text to any position in selected cells
Replace accented characters, symbols, and codes
Remove all unwanted characters
Delete multiple substrings or individual characters
Get rid of extra spaces and delimiters
Erase characters by their position in selected cells
Eliminate all blank and unused rows and columns
Сlear data by type
Split values to columns by any character or a string
Divide text from one cell into multiple columns
Pull records apart by position
Separate first and last names; pull titles, salutations, and other name units
Convert relative to absolute and back, replace formulas with values, modify all formulas at once
Turn text to number and date format, export data to JSON or XML
Fill the range with random passwords, dates, numbers, custom values, or booleans
Shuffle the selected cells, rows, or columns
Find and replace in values, formulas, errors, links, and notes
Calculate cells based on their colors
Switch between different text cases
Transform your crosstab table to a flat list
Lock top rows and left columns
Unmerge all cells in the selection
Flip adjacent cells, rows, or columns
Find duplicate or unique rows in your sheet
Compare columns or sheets for duplicates
Find duplicate or unique cells in your sheet
Join values in the selected cells, rows, or columns
Update data in the main table with the info from the lookup table
Combine duplicate rows and merge unique data referring to the same record
Combine data from multiple sheets into one
Manage tex in different ways
Apply lower, upper, sentence case; toggle and capitalize cells
Insert text to any position in selected cells
Replace accented characters, symbols, and codes
Remove all unwanted characters
Delete multiple substrings or individual characters
Get rid of extra spaces and delimiters
Erase characters by their position in selected cells
Eliminate all blank and unused rows and columns
Сlear data by type
Split values to columns by any character or a string
Divide text from one cell into multiple columns
Pull records apart by position
Separate first and last names; pull titles, salutations, and other name units
Convert relative to absolute and back, replace formulas with values, modify all formulas at once
Turn text to number and date format, export data to JSON or XML
Fill the range with random passwords, dates, numbers, custom values, or booleans
Shuffle the selected cells, rows, or columns