Google Sheets Beginners: Workbook Edit Version History (26)

Google Sheets keeps a detailed version history of your workbook. You can use this version history to track changes and identify when, where and who made a change. You can make a copy of an old version or revert your current sheet back to an old version.

Find out how to check your workbooks changes history in Google Sheets.

In this tutorial, I’ll cover,

  1. Why you might need to check the version history. 00:05
  2. How to see the version history 00:18
  3. What you can see opening version history 00:32
  4. How to expand to see specific individual history 00:52
  5. How to see edits individually by colour. 01:01
  6. Toggle the view on and off. 01:38
  7. How to Restore a version 01:57 
  8. How to Name a version. 02:30
  9. How to Make a Copy. 03:10
  10. How to exit version history 03:47
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Cell History (25)

Google Sheets

Did you know you can peek in on the history or each one of your Google Sheets cells?

via GIPHY

Find out how in this short video tutorial:

Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Getting Email notifications on changes and form submits (24)

Google Sheets

Google Sheets provides an email notification tool that allows you to get email notifications for changes to a Google Sheet or when a Google Form that is connected to your Google Sheet receives a submission. You can set your email notifications to be received when each change occurs or as a daily summary.

There are some really good use-cases where you might need to receive notifications of changes to a Google Sheet. Here are two common examples that I have used notifications for in the past:

  1. Tech Support: I have had a form connected to a sheet and then had my team use notifications to get an email when a user submits a tech support issue. We set it up so that the first responder adds their initial to a column related to the lastest form submission so that everyone knows that it is being addressed.
  2. Project Management: I’ve run a Gantt chart for project management and when someone from a project I have assigned has completed a portion of a task and is ready for review, they check a box. At the end of each day, I get an email notification summarising the changes in the chart.

Check out the details below on how to get notifications on a Google Sheet and how to read the email notification summary.

In this tutorial, I’ll cover,

  1. What are Notifications in Google Sheets. 00:27
  2. Adding in a Notification Rule. 00:42
  3. Notification from a Google Form. 01:00
  4. How Forms link to get Notifications. 01:25
  5. How Notifications are received in email. 02:10
  6. Creating a daily digest as a Notification Rule. 02:53
  7. What a daily digest looks like in email form. 03:20
  8. Other Notification Rules you can add. 03:55
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Protecting cells, ranges and sheet tabs (23)

Google Sheets

Have you ever had your editors edit something on your Google Sheet that they weren’t meant to? Find out how to protect cells, ranges and sheet tabs in Google Sheets.

In this tutorial, I’ll cover,

  1. Why you may need to protect certain parts of your Google Sheet 00:02
  2. Protecting a range of cells. 00:50
  3. Selecting editors to your protected range. 01:22
  4. How protected ranges look for the user. 01:46
  5. Protecting entire columns. 02:35
  6. Editor hierarchy. 03:18
  7. What to protect? 04:13
  8. The ‘protect’ sidebar. 05:17
  9. Protecting an entire sheet tab. 05:57
  10. Viewing a list of what has been protected in your Google Sheet. 07:17
  11. Hot tip for hiding sheet tabs from other users. 07:42
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Remove Duplicates from a Range (22)

Google Sheets

If you are anything like me, you may find yourself regularly tidying up imported datasets or data from users that contain duplicates that could potentially corrupt your data analysis.

Fortunately, Google Sheets has a quick tool to help you to remove duplicates with a simple click of the button.

In this tutorial, I’ll cover,

  1. Why you might need to remove duplicates. 00:10
  2. How to remove duplicates for a single row 00:30
  3. How to remove duplicates that contain a header row. 01:20
  4. Removing duplicates from multiple selected rows 02:02
  5. What data ‘Remove Duplicates’ will and won’t match. 04:48
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.