I’m developing a new Google Sheets interactive lesson to use with my students. One of the potential issues I for-see  is students typing on another student’s sheet. This got my brain rolling and the solution I came up with was to use the Protect Range tool. When you protect a cell or column ranges only the user selected can edit the area. The Google Spreadsheet is shared at once to a group with each sheet having different editing rights. Individual student’s names will appear on the tab for each sheet. One sheet per student. This will help guide the students to the sheet where they have editing rights.

HOW TO PROTECT RANGE

• Click column letters
  • Column becomes highlighted
  • Drop down list occurs
  • Click protect range

• Click set permissions

• Range editing permission window opens
  • Click who can edit this range
  • Click only you to access the editing dropdown list
  • Click Done

• Add E-mail Addresses

• Click done and a save window opens ending the process