Four ways to see if someone has edited your Google Sheet

If you have multiple people contributing to a shared Google Sheet, it can be difficult to keep track of all the changes being made. However, Google Sheets has some really useful features that can tell you when something has been changed and help you pinpoint exactly what was changed and by whom. In this blog post, I’ll share these four features with you and show you exactly how to use them.

Find it difficult to track changes to your #GoogleSheets? Here are four features that can help! Click To Tweet

 

Feature #1 – Notification rules

The notification rules feature sends you an email to notify you that changes have been made to your spreadsheet. You can choose to receive an email every time a change is made, or one email at the end of the day with a summary of all changes.

Follow the steps below to set up notification rules:

1. Open the spreadsheet and click the Tools menu > Notification rules.

sheets-edits-notification

2. Choose the option Any changes are made and choose when you want to receive an email.
3. Click Save.

sheets-edits-notification-2

The notification rules feature in #GoogleSheets will email you when a change is made to your #spreadsheet. Click To Tweet

 

Feature #2 – Conditional formatting

This is a great strategy that I picked up from the lovely Dez, a member of the Monash University Faculty of Medicine, Nursing and Health Sciences.
Conditional formatting can be used to automatically change the background colour of a cell when data is entered into it. This provides an easy visual representation of new data being added (but not when it is changed).

Follow the steps below to setup conditional formatting:

1. Select the data range you want to apply the conditional formatting in (by highlighting them with the mouse).
2. Click the Format menu > Conditional formatting.

sheets-edits-conditional-1

3. In the Format cells if drop-down, choose the ‘Is not empty’ option.
4. Choose a background colour in the Formatting style section (green is the default).
5. Click Done.

Based on the configuration below, a cell will turn green when a person enters data into it.

Four ways to see if someone has edited your Google Sheet

If you want to learn more about using conditional formatting in Google Sheets, check out this blog post and video from Adrian.

Love this idea of using conditional formatting in #GoogleSheets as a visual indicator of when new data is entered. Click To Tweet

 

Feature #3 – Version history

Version history is a feature available in Google Sheets, Docs, Slides and Drawings. It provides a date-based overview of all the changes made to a file, and details of who made the edits. You can also use version history to revert to a previous version of the file.

Follow the steps below to access the version history of a Google Sheet:

1. Open the sheet, then click the File menu > Version history > See version history.

sheets-edits-version

2. All the recent changes will be highlighted in a colour associated with the person’s name (shown in the right hand panel). Use the arrows at the right of the version history window to move through the changes.
3. To see an earlier version, click on a previous version in the right-side panel. To see even more versions, click on the small arrow shown to the left of the version date and time.

sheets-edits-version-2

Feature #4 – Cell edit history

In addition to viewing the version history of the entire Google Sheet, you can also view the edit history of a single cell. This is a great way to see what has changed in the cell, when, and by whom.

Follow the steps below to view the edit history of a cell:

1. Right-click the cell and choose Show edit history from the menu.

sheets-edits-cell

2. Use the arrows in the history box to move through all the cell edits.

#GoogleSheets version history and cell edit history are two great ways to track edits to your #spreadsheet! Click To Tweet

 

Looking for more Google Sheets tips and tricks? Check out these three simple tips for working with data in Google Sheets and learn how to get a date picker in a Google Sheets cell.

 


Two ways to use the STEM learning approach with your students

If you’re like most teachers and school leaders today who are considering introducing STEM or STEAM learning in your classrooms, the first thing you’re probably asking is ‘What will we buy?’ It’s hard to escape the buzz around the latest robotics tools, the new ‘invention kit’ or fancy coding platform.

VIEW POST
Outclassed Podcast

Fake News and Getting Google Search to Work For You Ep 27

Get Notified Of Future Episodes: Apple Podcasts | Spotify | Google Podcast | Stitcher | TuneIn + Alex | Podcast Addict | Podchaser | Deezer | Listen Notes In this Episode: To see all the OutClassed episodes go to utb.fyi/outclassed Podcast Episode Highlights: Coming Resources and links mentioned: Transcript: Mike

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: