AppsCare | Protecting a cell range in Google Sheets - AppsCare
AppsCare is a Google for Work Premier Partner in the UK and specialises in the deployment of Google Apps for Work, Google Drive for Work, Google for Education, Google Maps for Work, Chrome Devices for Work and Google Search.
google enterprise premier partner, google enterprise partner, google enterprise reseller, google apps reseller, google apps partner, google maps reseller, google maps partner, chromebooks reseller, chromebox for meetings, google maps for business, google apps for business, google apps for education, google drive for work, drive for work, google for work, google apps for work, google maps for work, chrome for work, google for work premier partner, google apps for work reseller, uk, google for work uk premier partner, google apps reseller, google apps partner
single,single-post,postid-17199,single-format-standard,ajax_fade,page_not_loaded,,wpb-js-composer js-comp-ver-4.0.5,vc_responsive

06 Nov Protecting a cell range in Google Sheets

Using Google Sheets allows you to work collaboratively with your team mates. However, information can be important and you may want to protect this from being edited by those with access to your Sheet. Protecting your cells in Google Sheets can help you to preserve the important stuff, whilst still allowing your team mates to collaborate on the document where and when you need them to. 

To get started, you will need to make sure that anyone with access to the Sheet can edit. This is to make sure that your team mates can still edit all unprotected cells in the Sheet. You can make any exceptions to this by typing in specific contacts, and editing their permissions.

Google Apps Tips - Protect Google Sheets

To get started with protecting your Sheet, you can highlight a particular column or row that you want to protect. Then visit ‘Tools’ in the menu bar and scroll down to ‘Protect sheet…’

Google Apps Tips - Protecting Google Sheets

You will then see a sidebar appear on the right hand side of the window. You will have the option to protect the sheet or a range, and in this case we will select ‘Range’. Your highlighted cells will already be selected here.

Google Apps Tips - Protecting Google Sheets

You can now choose a description for your protected cells – you can either make this the title of the cells or a warning to those trying to edit it!

Now, you want to set who can edit your protected cells. Click ‘Set permissions’ and change all those with access to the file, to be able to ‘Comment’ rather than edit, as this will keep your cells protected.

Google Apps Tips - Protecting Google Sheets

To save your permissions and protect your cells, save all your changes and hit ‘Done’ in the sidebar.

Google Apps Tips - Protecting Google Sheets

You can then view, edit and delete your protected cells from the sidebar. You can also protect other cell ranges and manage them all here.

Google Apps Tips - Protecting Google Sheets


For more tips and tricks like this, visit our Google Apps Tips blog.

Claire Stead
No Comments

Post A Comment