To get started with Protected Ranges in a shared spreadsheet, highlight the cells you’d like to protect, right-click, and choose Name and protect range from the menu.
Click through the presentation below to see the feature in action.
Even more spreadsheet features added this month
Along with the arrival of protected ranges, you can now add colors and patterns when you apply cell borders in Google spreadsheets. We also updated find and replace to make it possible to search using patterns (also called regular expressions). For example, “^[A-Z]+” will find all the cells that start with uppercase letters.
As always, Google spreadsheets is getting better every day, so stay tuned for even more features and updates in the coming weeks.
Posted by: Joe Kaptur, Software Engineer