Google Spreadsheet Tips Part II – Protecting Cells

When working on a spreadsheet with others, you may want them to be able to edit the sheet but wish there were certain cells within the sheet that you could lock down, or protect from being edited.  There is a way to do this!  Follow these steps:

1.  Highlight the cells/columns you wish to protect.
2.  Right click and choose Name and protect range.
3.  A panel will open confirming your cell range – check the Protect box.
4.  Choosing a name for your range will make it easier for you to find and manage protected cell ranges
5.  Click Done.

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

Special Thanks to Sheryl Roberts for her contribution to this post.

The Tech Integrator

Leave a Reply

Your email address will not be published. Required fields are marked *