How to View Edit History of Cells in Google Sheets | Easy 2 Minute Guide

How to View Edit History of Cells in Google Sheets | Easy 2 Minute Guide
Reading Time: 3 minutes

View Edit History of cell in Google Sheets

4 Steps to Check Edit History in Google Sheet

Learn how to view the edit history of cells in Google Sheets. Learn to spot mistakes or past changes.

Why View the Edit History of Cells in Google Sheets?

Let’s say you are working on a spreadsheet. You are entering or modifying the sheet for analysing data. There are high chances that you might make errors in the process and want to move back to previous versions.

We know that Google Sheets provides the Undo command for viewing previous versions of your sheet. However, you won’t be able to look at previous versions of individual cells using the UNDO command. 

Let’s say you are making changes to some cells while editing the spreadsheet. After a point in time, you realise that there is an error in the final output. Till now, you would have performed hundreds of actions on the spreadsheet. Therefore, if you want to debug the issue, viewing the previous versions of the entire sheet doesn’t make sense. In this case, you can view previous versions of individual cells to get to the root cause of the discrepancy in the final output. Here’s a brief explanation of how you can view the edit history of cells in Google Sheets.

Step 1: Open the Spreadsheet of interest to view the edit history of cells in Google Sheets.

  • Open the Google Sheet where you want to look at individual cell history.
Open Google Sheets of interest
Figure 1: Open Google Sheets of interest

Step 2: Click on the Cell of Interest

  • Navigate to the cell of interest.
  • Select the cell.
Select the cell of which you want to view edit the history of cells in Google Sheets
Figure 2: Select the cell of which you want to view edit the history of cells in Google Sheets

Step 3: Right-click on the cell. Click on Show Edit History

  • Right-click on the selected cell.
  • Click on the option Show Edit History.
Click on Show edit history
Figure 3: Click on Show edit history

Step 4: Click on Arrow Icons to See Individual Edits.

  • You will see “< >” arrows in the top right corner.
  • You can click on the “<” button to navigate to the previous version of the cell.
  • You can click on the “>” button to navigate to the next version of the cell.
  • You can now view the edit history of cells in Google Sheets.
Click on the highlighted buttons to navigate between views
Figure 4: Click on the highlighted buttons to navigate between views

See Also

Most Commonly Used Google Script Functions for 2022: Learn about widely used advanced script functions.

Google Sheets: How to Use Pivot Tables: Learning how to create and use Pivot Tables for analysing data in Google Sheets.

Conditional Formatting in Google Sheets: Get started with Conditional Formatting in Google Sheets

How to use Filter views in Google Sheets | Simple 2-min Guide 💻: Learn how to use Filter view in Google Sheets and its variations.