How to See Edit History in Google Sheets

Supreeth is passionate about technology and dedicates himself to helping people figure it out. An engineer by education, his understanding of the inner workings of all types of gadgets and devices ensures he provides top-notch guidance, tips, and recommendations to his readers. When away from the desk, you will find him traveling, playing FIFA, or hunting for a good movie.

How to View Google Sheets Version History

Step 1:In the second toolbar above the spreadsheet, click on theclock iconat the top right section.

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

Asidebarwill open, showing all the different versions of the spreadsheet, as well as when and by whom it was saved.

Step 3:If you click on aversion, the spreadsheet will open, highlighting all the additions and changes made to the spreadsheet.

You can also expand the version and view each activity in the document before it was saved. Further, you can also see the date and time when the activity or version was saved.

Tip: In addition to the above method, you can also use the keyboard shortcut ‘Ctrl + Alt + Shift + H’ on Windows or ‘Command + Option + Shift + H’ on Mac to access the edit history feature in Google Sheets.

Restore to a Previous Version in Google Sheets

To restore your spreadsheet on Google Sheets to a previous version, clickthe three-doticonnext to a version and selectRestore this version.

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

However, you can undo this action by returning to the last version before restoring the document with an earlier version. You can do it in the same version history tab.

If you want to generate a separate spreadsheet from a version, you can use theMake a Copyoption. A new spreadsheet with the contents of that particular version will then appear.

Also Read:How to get dark mode in Google Sheets

Rename Each Version of Your Document

We recommend naming each version inGoogle Sheetsto track the version history. 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. Add a name to the current version of your Google Sheets document.

However, if you want to name an older version of the document :

Step 1:Click onVersion history>See version history.

Step 2:In the version history sidebar, click on thethree-dot iconnext to the version you wish to rename and selectName this version.

Check Individual Cell History on Google Sheets

If you want to check the changes made over time for an individual cell in a Google Sheets document, here’s how to view the individual cell history in Google Sheets.

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

Step 2:Click onShow edit history.

You can now see the edit history of a specific cell. Navigate using the buttons in the box to view all the previous edits.

Delete Version History on Google Sheets

While Google Sheets does not allow you to delete the version history, you can create a new duplicate of a spreadsheet document, which will erase the history. However, the version history will remain on the source document unless you delete the document itself.

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.

View Google Sheets Activity on iPhone and Android

The Google Sheets app on iPhone and Android does not display the version history in detail. However, you can still see the activity and who made the changes when on the document.

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

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

Step 3:Click onDetails and Activity. You can see all the activities in the Google Sheets document.

Unable to View Version History? Here’s What You Can Do

Always ensure to enable the Show Changes option before creating the Google Sheets document to see the edit history and activity. Here’s how to do that.

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

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

Further, ensure that you have access to the Google Sheets documentas an Editor– only then can you track the version history.

Was this helpful?

Last updated on 04 September, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

How to Collaborate on Instagram Posts With Your Friends

5 Ways to Fix Audio Not Working on Discord

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.