Google has a habit of keeping its business apps under constant development. Springing new features on customers and offering increased functionality. Today’s update is for Google Spreadsheets and enables a way of locking down cells so they can’t be altered.
Editing with others in real-time makes it easy to get stuff done in Google spreadsheets in only a matter of minutes. But with so many people working in the same space, it’s possible to modify a section that a collaborator didn’t intend to be touched. That’s why, today, we’re updating the Named Ranges feature in spreadsheets to let you also protect them.
Shared documents make working together remotely much easier, but the danger is that one person alters a cell they shouldn’t and alters all the other calculations that rely on it. Being able to lock cells prevents these accidental changes from taking place.