Tuesday, January 26, 2016

Google Tip of the Day: Protect a Cell Range in Google Sheets

Do you have a Google Sheet for which you want various people to fill in information but you are concerned they will delete information others enter?  Of course you can use the Revision History to help but you can also protect a range of cells.  Here is how it is done.

  1. Click Tools>Protect Sheet.
  2. Select the cells you do not want others to be able to edit.

  3. Click Set permissions.
  4. Select Only you unless you want a few others to be able to adjust that information.
  5. Click Done.