This week we rolled out the book sign out Google Sheet to the students. One big “Opps” I made is forgetting to protect the range in the cells which contained the functions. When the Google Sheet owner protects the range it prevents others from accidentally deleting or corrupting cell functions.
Here is an example
- Type Function into column E Cell 2:
- = Sum (Col letter:Row number, Col letter)
- into Cell
- = Sum (Col letter:Row number, Col letter)
- This will total numbers in column C
Example of =sum function in action
How to PROTECT RANGE
- Right Click Cell
- Click Protect Range
- Click SET PERMISSIONS
- Click Restrict who can edit this
- Choose Only You
- Finish by Clicking Done!
Now the Cell Is Protected and It Is Impossible for Students to Make Changes