0

Protecting individual cells in Google Sheets is a great way to prevent data in your spreadsheet from getting changed—accidentally or intentionally—by anyone viewing the sheet. Fortunately, Sheets provides a handy tool to protects people from altering cells in your document.

Protecting Cells in Google Sheets

One of the best features of Google Sheets (and all the other Google apps) is the ability for anyone with edit access to collaborate on documents in the cloud. However, sometimes you don’t want the people you’re sharing a document with to edit specific cells in your sheet without completely revoking their ability to edit. This where protecting specific cells comes in handy.

RELATED: How to Create Shareable Download Links for Files on Google Drive

Fire up your browser, open a Google Sheet that has cells you want to protect, and then select the cells.

Select the set of cells you want to protect

With the cells selected, open the “Data” menu and then click “Protect Sheets and Ranges.”

click Data, then on Protect Sheets and Ranges

The Protected Sheets and Ranges pane appears on the right. Here, you can enter a brief description and then click “Set Permissions” to customize the cell’s protection permissions.

Read the remaining 48 paragraphs


Post a Comment Blogger

We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.

 
Top