Protecting Google Sheet Range

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
  • This will total numbers in column C

sum (1)

Example of =sum function in action



  • Right Click Cell
  • Click Protect Range

sum 2.png


sum 3.png

  • Click Restrict who can edit this
  • Choose Only You
  • Finish by Clicking Done!

sum 4

Now the Cell Is Protected and It Is Impossible for Students to Make Changes





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.