Google Docs Bring Sheet Protection for spreadsheet
5:12 PM | View Comments | Docs, Google, Google Docs, Security, Technology, Web App
When working on a spreadsheet together with others, sometimes it's handy to allow some people to modify specific sheets but restrict them from modifying other sheets. Google bring up a feature called "Protect Sheet" in Google Docs where user can protect the sheet by allowing editing authority.
an additional layer of control over who can edit individual sheets, using the list of people invited as collaborators. If you want to restrict your collaborators from editing specific sheets of your spreadsheet, you can protect those sheets in your workbook. To protect a sheet, click the sheet's tab at the bottom of your spreadsheet (next to Add sheet button) which will bring up the menu, and select Protect sheet. You will also able to allow different people for different spreadsheet.
- Any collaborator can edit the sheet
- Only you can edit
- You and specific collaborators can edit
Your collaborators and viewers will still be able to view the data on the protected sheet, but depending on the permission you set for each sheet, they won't be able to make any changes or delete a protected sheet.Sheet protection is a great way to add a little fine control over the contents of your spreadsheets.
