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…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons