Via the @BISDwiredTeam: Tom Spall, Brittni Branton, and Troy Kuhn

Tech Tip Thursday: Lock Cells in Sheets

No comments
Tech Tip Thursday: Locking Your Cells in Google Sheets

Have you ever shared a spreadsheet with a colleague, friend, parent, or student, and they messed up your columns or rows or changed up all the information or data? If we are honest, we all probably can think of that one time someone changed your spreadsheet. Most likely, it was probably a total accident, too.

Make sure you lock your rows, columns, and cells next time you create a spreadsheet! Then everyone can work in their assigned cell, row, or column.

Here’s how to do it-
1. Highlight your row or column or cell you want to protect.

2. Click on “Data” and “Protected Sheets and Ranges” from the menu on the top.

3. Title the data, and click “save permissions” and then check and uncheck who you want to be able to access that column. Click done to save changes.

You can do this for as many rows, columns, or cells that you want to.

No comments :