The Google for Work team are launching a number of improvements to the protected sheets and ranges functionality in Google Sheets, providing faster and more fine grained controls for locking down sections of content in spreadsheets.
Key improvements include:
- The ability to lock down all content in a sheet except for a particular cell or range.
- Quicker set up with the ability to re-use the same permissions previously used on a different set of cells.
- The ability to lock down a sheet or range to only a single person, a small number of people or a domain.
This is rolling out to rapid release today and scheduled release in two weeks time.