Top 100

Tuesday, August 26, 2014

Password Protect Google Sheet

This is a feature I've wanted for a long time, the ability to lock certain cells in a spreadsheet so others who may be collaborating with you cannot change the contents. Basically, highlight the cells you want to lock, choose Data > Name and Protect Range and follow the options in the box to protect those cells. It even brings up another box with all of the collaborators that allows you to further pinpoint who can or cannot work inside protected cells.

No comments:

Post a Comment