How to Check Google Sheets Version History – Guide
Google Sheets is a great tool for storing and updating important data. But what if you prefer the earlier version of the program? Do you have access to edit history? Fortunately, a feature which is on by default allows you to see all changes and restore the document to your preferred version. You can also review individual cell modifications that various contributors have made. Read on to find out how this is done.
Check a cell’s edit history
At the top of the dialog box, you will see arrow keys that you can click to switch between edits. You will be able to see the name of the contributor who made the edits, the timestamp of the edit, and the previous value of the edit. Note that added or deleted rows and columns, or any cell format changes, will not be visible in the edit history.
Check edit history using the menu
Checking the edit history using the menu is quite simple. Here’s what you need to do: The bar allows you to see all changes made to the document. For users’ convenience, changes are grouped into time periods. So you can navigate to the date you want to check. When you click to expand, you will see all edits made on that specific date. If you click on the edited version, it will appear in your Google Sheet. In turn, you can see how that sheet looks with that particular edit.
Check edit history using keyboard
Alternatively, we can check history edits using the keyboard. The combination of controls is different for Windows and Mac users. If you are using Windows, simultaneously hold Ctrl + Alt + Shift + H. Mac users should hold Cmd + Alt + Shift + H.
Check edit history by naming versions
When creating a worksheet, it will be named after the timestamp by default. When working with many other people, it can be cumbersome to scroll through dates to find what you need. Google Sheet has added a function that allows you to name each version and more easily control your or your colleagues’ edits. You can name the current version by navigating to “File” and selecting “Version History”. Here you will see the option “Name current version”. By choosing the relevant name for the document, you save yourself and your colleagues from having to go through date-named versions of spreadsheets and choose the right one. Google Sheet lets you add up for 15 named versions.
Check edit history enabling notifications
Here it is. So you will always be informed about edits, without having to open the spreadsheet and check for yourself.
Check edit history by enabling conditional formatting
When new information is added, it can be helpful to see it in different colors or sizes. Google Sheet has a “Conditional Formatting” function that provides a visual representation of the added data. To apply conditional formatting, follow these steps:
Final note
I hope you like the guide How to Check Google Sheets Version History. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.
