Protecting Cells

Sometimes there are sheets that you want to share, but maybe some of the data needs to be fixed.  This is when protecting cells can help. 

To protect a cell or a range of cells:

1. Highlight the cell or cells and select the DATA menu.

2. In the DATA menu, select, Protect sheets and ranges

3. In the menu that appears on the right, enter a description. In my example, I wrote a message for whom to contact for editing rights.

4. You can also change permissions and add a warning when clicking the cell. You can also add collaborators who are able to edit the data without a warning. To do this click the Change permissions  button below the range.

After clicking Change permissions, this pop-up appears.

5. To delete a protected range, open the right-side menu again by clicking on DATA and Change permissions. 

Click on the trash can.