Making edits with other folks in a collaborative effort over a document stored on the cloud is ideal in keeping track of different edits made by various folks with their respective timestamps, but sometimes, as the old proverb says, “too many cooks spoil the soup”. With Google Spreadsheets in Google Docs, the Internet search giant has decided to introduce the idea of Protected Ranges, making it possible to modify a section which a collaborator did not intend to be edited. This is the reason why the Named Ranges feature in spreadsheets has been updated so that you are able to protect them.
In order to access the Protected Ranges in a shared spreadsheet, all you need to do is highlight the cells which you would like to protect, right-click, and select Name and protect range from the menu. Apart from protected ranges, you are also able to add colors and patterns whenever you apply cell borders in Google spreadsheets. It is also now possible to find and replace by searching for pattern. Do expect more features and updates to arrive in the coming weeks.
- 2014-04-21: Nest Thermostat Briefly Spotted On Google Play
- 2014-04-21: Flippypad Concept Shows How Project Ara As A Handheld Gaming Console
- 2014-04-21: Leaked Android Dialer App Screenshot Shows Slight Makeover
- 2014-04-21: Google Reportedly Working On Stronger End-To-End Encryption For Gmail
- 2014-04-21: HTC Could Deliver Nexus 8 (Rumor)
- 2014-03-11: Google Introduces Add-Ons For Docs And Sheets
- 2013-12-11: Google Sheets Offline Editing Is Finally Possible
- 2012-09-05: Google spreadsheets get all talkative with discussions
- 2012-06-28: Google Drive for iOS and PC offline editing introduced
- 2012-03-13: Google Docs graduates from Google+ Hangouts