Google Sheets allows users to protect an entire sheet, or a range of cells. In this video, author Jess Stratton illustrates how to protect a sheet to turn it into an uneditable template.
- [Narrator] Every month, our hotel computers at the…Landon Hotel gives us a report of our visitor data.…My employees take that data and paste it into…a Google Sheet like this.…The data that we'll be copying and pasting…comes in a very specific format from our computer systems,…and we've been having trouble with it,…because when an employee creates a new sheet,…the headers are spelled wrong sometimes,…or they're in the wrong order, and it causes problems…for analyzing the data later.…What I can do to fix this problem…is to make a template my employees can use,…so it will always be correct.…
The template will only be editable by me,…so even the template will be protected…against unwanted changes.…The first step to making my template…is to identify that it is the template.…In the top left hand side of the screen,…I'm going to change the title from Monthly Visitor Data…to Monthly Visitor Data Template.…This way we can very quickly tell that…that's what it is.…The second step is to protect the entire sheet.…Google Sheets gives you the ability to protect…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.