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

Sum.gif

How to PROTECT RANGE

  • Right Click Cell
  • Click Protect Range

sum 2.png

  • Click SET PERMISSIONS

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

 

 

 

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s