Users can now set permissions for single cells and cell ranges in Google Spreadsheets.

The ability for colleagues to share your Google Spreadsheet and work on the same file together at once is a wonderful feature of Google Spreadsheets – but how do you make sure that collaborators don’t edit a cell you don’t won’t them to? New to Google Spreadsheets is the ability to set permissions for a single cell or a range of cells, and share access with collaborators, exactly like sharing file access.

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.

Once you have protected your cells, any collaborators on the document will see the cell data but will be unable to edit the cell.