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.

Google Sheets Beginners: Linking (21)

Google Sheets 

Find out how to effectively link to websites, your own Google docs and within your very own Google Sheets. In this tutorial, I’ll cover,

  1.  Types of linking in Google Sheets 00:00
  2. Simple copy and paste approach 00:11
  3. How the link is displayed and it’s properties 00:20
  4. Add a link to an existing cell with text in it. 00:50
  5. Other access points to use the link tool. 01:22
  6. The link window tools. 01:34
  7. The shortcut command to the link tool 02:05
  8. Add both the title and the link with the link tool. 02:30
  9. Link to another Google doc in your Drive 02:48
  10. Link to another Sheet Tab within your Google Sheet 03:35
  11. Link to a cell within your Google sheet 04:30
  12. Link to a selected range within your Google Sheet 05:34
  13. Link to a specific piece of text within a string of text in a cell 04:30
  14. Different links to different pieces of text within a cell 07:22
  15. Get a URL to a specific cell in a specific Sheet Tab and share it. 08:33
Watch this video on YouTube.

Linking can be a really handy tool for you when building your Google Sheet project. You can use it to reference a long list of external documents. Create a table of contents Google Sheet Tab for your monster of a Google Sheets project. Or even create a mini centralised information hub for your organisation or team.

Oh! Did you know that there is also a Google Sheets functions for HYPERLINKS. Why use it over the link too? Well, it is great for concurrent automation of cells down a row. Or you might want to add it to a greater formula to, say, add URL extensions automatically.

Cheers,

Yagi

Google Sheets Beginners: Sharing your Sheet (20)

The ability to share and co-edit documents live is a powerful tool for organisations. In this tutorial, we will dive in deep on sharing a Google Sheet. In this tutorial, I’ll cover,

  1. What is sharing? Who can you share your Google Sheet with and what permissions can you give them? 00:00
  2. How to share your Google Sheet 0:20
  3. Understanding the share dialogue window. 00:50
  4. How to share your Google Sheet with people and/or groups 00:58
  5. Sharing with a group of users. 01:37
  6. Introduction to the top-bar of the comment dialogue box. 02:45
  7. Change users share permissions. 02:57
  8. Notify users that you are sharing a Google Sheet with them. 03:46
  9. See the number of people you have shared and the permissions that you have given them. 04:39
  10. A view of the email notification the user will receive. 04:59
  11. A warning on notification messages 05:25
  12. Viewing a shared Google Sheet as an editor. 05:45
  13. See the results of an edit from another shared account. 06:32
  14. Setting up custom people and group share settings. 07:02
  15. Change the permission level of existing shared user 08:48
  16. Make a shared user the owner of the document. 09:10
  17. The ‘View’ permission. What it looks like for the user. 10:43
  18. Requesting permissions from the owner. 11:13
  19. The ‘Get Link’ share settings. 12:19
  20. How anonymous users appear on your sheet. 14:30
Watch this video on YouTube.

While understanding the basics of sharing is quite simple, it can be a huge benefit up understand the different aspects of sharing. Your Google Sheet.

In the tutorial, we mentioned that we have a tutorial on how to handing a multitude of users making edit privilege request in your Gmail. Here is the tutorial:

How to stop getting Google document requests to edit from users outside your organisation from publicly viewable files.

Finally, here is a link to the Google Sheet that we have set to share fory anyone with a link can view: 

Shareing in Google Sheets tutorial link.

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: Communicating with Comments (19)

Google Sheets

One of the beauties of Google Sheets is collaboration. In this tutorial, we will cover how to insert comments in Google Sheets so that you can target cells and ranges for discussion with comments. In this tutorial, I’ll cover,

  1. Uses of comments in Google Sheets. 00:16 
  2. Who can access comments (Permissions)? 01:08
  3. How to create a comment. 01:21
  4. Create a general comment 01:28
  5. What comments look like in a sheet. 02:15
  6. Introduction to the top-bar of the comment dialogue box. 02:45
  7. Replying to comments in Google Sheets. 03:24
  8. Viewing comment history. 04:18
  9. Resolving comments. 04:35
  10. Other ways to create a comment in Google Sheets. 04:55
  11. Specifically addressing users in comments. 05:29
  12. Assigning comments to users. 06:52
  13. Viewing comment notifications in Gmail. 07:38
  14. Manually setting notifications for comments 09:30
  15. A final example using comments 10:35
  16. Seeing how many comments there are in a Google Sheets tab. 11:20

There is a lot to comments. Mostly learning comments is quite intuitive, however, it is important that your users know what they need to in order to be able to effectively communicate with each other in the Google Sheet. 

 

Watch this video on YouTube.