Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Do Not Type There

protect range google sheets
Google Sheets: Do Not Type There

protect range google sheets

Protect Range in Google Sheets

One nifty thing about using Google Sheets is the ability to lock collaborators from editing your work. I love to create crowdsourced spreadsheets and invite people on social media to add to the document. It is normal for people to start typing when they open a document. This causes them to accidentally type over the content in the first few cells. Just to make sure the headers and the first few entries on the spreadsheet do not get accidentally deleted, I protect the cells from editing.

Notice on this collaborative spreadsheet for Google Maps lesson plan ideas, the header editing permissions are restricted.

Protect Range

Highlight a range of cells on a spreadsheet. Right click and choose “Protect range.” Set the permissions for who can edit the cells in the range.
Protect Range google sheets

Owner Rules All

The owner can not be restricted from editing the spreadsheet. If you are not the owner and you protect a range on the spreadsheet, the owner is still able to edit that range. For this reason, spreadsheets copied in Google Classroom to students can not restrict the student from editing certain parts of the spreadsheet. Students are owners of their own work and thus have full editing rights.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.