Google has added a new feature to its spreadsheet product that enables users to lock down particular sections.
According to Google, the feature, called Protected Ranges, is intended to stop cells being modified accidentally when several users are working on the same spreadsheet.
Protected Ranges creates designated sections of a spreadsheet that cannot be changed by users that don't have editing rights.
The feature works like this: highlight the cells you want to lock down, right-click to bring up the menu, and then choose "Named and protect range." Then, click "protect" and "done." … Read more