Alternatively, go toFilein the menu bar > selectVersion History>See Version Historyto reach the next step.

you could also expand the version and view each activity in the document before it was saved.

The latest version of the document will be changed with the data and content from the previous version.

Article image

you’re able to do it in the same version history tab.

If you want to generate a separate spreadsheet from a version, you could use theMake a Copyoption.

A new spreadsheet with the contents of that particular version will then appear.

Article image

This can help you collaborate and communicate better in a Google Sheets document.

Step 1:Click onFileat the top of the spreadsheet.

Step 2:SelectVersion history, followed byName Current Version.

Article image

Add a name to the current version of your Google Sheets document.

Step 1: Right-clickon a cell in Google Sheets.

Step 2:Click onShow edit history.

Article image

you’ve got the option to now see the edit history of a specific cell.

Navigate using the buttons in the box to view all the previous edits.

However, the version history will remain on the source document unless you delete the document itself.

Article image

Step 1:Click onFile.

Step 2:Click onMake a copy.

The duplicate copy version of the spreadsheet without the version history will pop up in the new tab.

Article image

Step 1:Open theGoogle Drive appon your iPhone or Android phone.

Step 2:Find and punch thethree dots iconnext to the document you wish to access.

Step 3:Click onDetails and Activity.

Article image

it’s possible for you to see all the activities in the Google Sheets document.

Unable to View Version History?

Heres how to do that.

Article image

Step 1:In the Google Sheets document, click onFile>Version history>See version history.

Step 2:Ensure you have checked the box forShow Changes.

Was this helpful?

Article image

The content remains unbiased and authentic and will never affect our editorial integrity.

Article image

Article image

Article image

Article image

Article image

Article image

Article image

Article image

Article image

How to Create Dropdown Lists on Google Sheets

Article image

How_to_Insert_a_Date_Picker_in_Google_Sheets_and_Google_Docs

Article image

Article image

Article image

Top Fixes for Formulas Not Working in Google Sheets