How To Check Google Sheets History
On your computer open google docs sheets or slides.
How to check google sheets history. It also shows the trend of views and comments and a sharing history. In this blog post i ll show you how the feature works and how you can configure the related privacy settings. Under activity dashboard turn off show your view history. Open a google doc file click on the upward trending arrow icon in the upper right or go to the tools pull down menu open the activity monitor click on the all viewers for your organization tab. The combination of controls is different for windows and mac users.
The activity dashboard feature in google docs sheets and slides lets you see who has viewed a file and when they last viewed it. Find the cell whose history you wish to view. Mac users should hold cmd alt shift h. Note however that you can t restore a previous version from the cell history. If the file isn t owned by a google account.
Alternatively we can check the history edits using the keyboard. If you re using windows hold simultaneously ctrl alt shift h. Recently google sheets has provided the ability to view the cell history changes for individual cells as well. We have two ways to view the history of changes the menu option or the keyboard combination. Alternatively you can press ctrl alt shift h.
A blue ring will appear around the google sheets cell you ve selected. Right click the cell then select show edit history. At the top left click menu settings. Click on the cell you wish to view the edit history for. Once you ve opened a document head to file version history see version history.
First open up a file you have stored on google docs sheets or slides. Locate the cell whose history you want to view. Right click the cell then choose the show edit history option.