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

23 Google Sheets Shorts - Protect Cells Ranges Sheet Tabs

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.

Leave a Reply