How to lock cells in Google Sheets

How to lock cells in Google Sheets

Have you ever faced an issue when your colleague edited the same cell you were editing? Collaborating easily is a wonderful feature in Google sheets but during these times it can be frustrating. 

Learn how to lock cells in Google Sheets for easy editing. The simple steps below would help you to get rid of this issue.

Steps to lock cells in Google Sheets:

  1. First, Highlight the cell you wish to protect:
google sheets protected ranges
  1. Next, Right click and choose the Protect Range option. Likewise, you can lock a column in Google sheets. 
how to lock cells in google sheets
  1. A dialog box will appear at the side of the sheet where you can enter the description of the range and click the Set permissions button.

Google Sheets protected ranges:

how to lock a column in google sheets
  1. After this another Dialog box will appear asking you to set Range editing permissions and select the people you want to allow to edit the range. Then, click on Done
lock cells in google sheets

Voila! Simple, isn’t it? For more such tips and tricks don’t forget to check other posts on our website.