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.
Ubergizmo , Protected Ranges in Google Spreadsheets now available, Protected Ranges in Google Spreadsheets now available