Google revealed that it has updated its Spreadsheets with data locking, enhanced search by adding “protected ranges” to the documents, means now you can designate sections of spreadsheets to be locked down in order to prevent other users editing the content upholds there. To get started with Protected Ranges in a shared spreadsheet, all you have to do is highlight the cells you’d like to protect, right-click, and choose Name and protect range from the menu. The company along with protected ranges allows users to add colors and patterns when you apply cell borders in Google spreadsheets, means that, for example, a search for “^[A-Z]+” will find all the cells that start with uppercase letters.
