Google Updates Spreadsheets With ‘Protected Ranges,’ Allow To Add Colors, Patterns On Applying Cell Borders

Posted on Aug 8 2012 - 7:58am by Editorial Staff

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.

About the Author

Editorial Staff at I2Mag is a team of subject experts.