Google Sheets Beginners: Protecting cells, ranges and sheet tabs (23) [updated Feb 2022]

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.

The main tutorial

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

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

How to prevent editors from moving columns and rows

You can prevent editors from moving columns and rows by selecting a range of rows, for example, A1:E1 and preventing the user from editing those cells. Now when the editor tries to move any of those columns, they will not be able to.

check out the video tutorial below for more on this:

  1. 00:00 The problem
  2. 00:38 The solution
  3. 01:34 Testing the solution
  4. 02:14 Bonus 1 – hiding non-editable ranges
  5. 03:02 Bonus 2 – Allow editors to hide and unhide selected columns
Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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

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

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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

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.

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~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

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.

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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. 

 

 

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

%d bloggers like this: