How To Check Google Sheets 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.

How to check google sheets history. Alternatively we can check the history edits using the keyboard. A blue ring will appear around the google sheets cell you ve selected. Recently google sheets has provided the ability to view the cell history changes for individual cells as well. Click on the cell you wish to view the edit history for. The combination of controls is different for windows and mac users.

If you re using windows hold simultaneously ctrl alt shift h. It also shows the trend of views and comments and a sharing history. Right click the cell then choose the show edit history option. The activity dashboard feature in google docs sheets and slides lets you see who has viewed a file and when they last viewed it. Alternatively you can press ctrl alt shift h.

We have two ways to view the history of changes the menu option or the keyboard combination. I ll be using google docs but the process is the same on the other two services as well. Note however that you can t restore a previous version from the cell history. We can view the history of changes in google sheets by navigating to file version history see version history. First open up a file you have stored on google docs sheets or slides.

At the top left click menu settings. Mac users should hold cmd alt shift h. Locate the cell whose history you want to view. Under activity dashboard turn off show your view history. Right click the cell then select show edit history.

Using the menu option. In this blog post i ll show you how the feature works and how you can configure the related privacy settings. If the file isn t owned by a google account.