HomeGoogleGoogle SheetsProtecting Sheets and Ranges

13.25. Protecting Sheets and Ranges

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-it interactive" to select your preferred viewing method. Then, click start.


19 STEPS

1. The first step is to open Google Drive, then open the Google Sheet you want to protect. Once your sheet is open, click Data

Step 1 image

2. Click Protected sheets and ranges o

Step 2 image

3. Click Add a sheet or range

Step 3 image

4. Click Select data range if you want to protect specific cells within a Google Sheet.

Step 4 image

5. Type in the cell range you want to protect, in this case all the data in Cells C2 - C11. Click Ok

Step 5 image

6. Click Set permissions

Step 6 image

7. I can now control who can edit my specified range. Click the drop down menu.

Step 7 image

8. Only you means that no other users can edit these ranges. Clicking "custom" would allow us to add specific editors by email address.

Step 8 image

9. Click Done

Step 9 image

10. Click Add a sheet or range again.

Step 10 image

11. We can also protect an entire Sheet, which can be helpful when you have a Google Sheet with multiple tabs, but you only want to share one.

Step 11 image

12. Click the drop down menu to select the sheet you want to protect.

Step 12 image

13. Click highlight

Step 13 image

14. Click Set permissions

Step 14 image

15. Click Only you

Step 15 image

16. Click Custom

Step 16 image

17. I can now enter email addresses to allow specific people access to a sheet. Alternatively, I can allow anyone to view/change a sheet but show them a warning first.

Step 17 image

18. Click Done

Step 18 image

19. That's it. You're done.

Step 19 image

Here's an interactive tutorial

https://www.iorad.com/player/1739687/Docs-Google---How-to-untitled-task-name



Downloads

Knowledge Tags