How to lock cells in Google Sheets

Google Sheets is a powerful spreadsheet tool many people use every day. While the program may be similar to Microsoft Excel, it also offers some distinct advantages

One of those advantages is that you can share your spreadsheets with others. This lets you collaborate with your teams, employees, and supervisors — but it can also lead to some potential issues.

If you’ve put hours of work into developing your spreadsheet, you won’t necessarily want just anyone to edit the cells, either intentionally or accidentally. Taking a few minutes to lock your cells can protect them from being edited or changed, ensuring your document is safe even if you share it with others.

How to lock cells in Google Sheets step by step:

To protect your document, open your sheet and identify the cells that you want to lock. You can lock some of the cells while still allowing collaborators to make changes to others. Start by identifying and selecting the cells that you want to lock.

  1. Open the Data menu at the top of the document, and then select Protected Sheets and Ranges in the dropdown menu. This will open a Protected Sheets and Ranges pane on the right side of your document.
Clicking on the Protected Sheets and Ranges option under the Data options on Google Sheets
  1. In the Protected Sheets and Ranges pane, enter a description for the actions you’re prohibiting in the protected cells, like “No changing” or “No editing.”
Entering No Editing at the protected Sheets and Ranges pane on Google Sheets
  1. Click the Set Permissions button to customize the permissions of that highlighted range of cells.
Clicking on the Set Permissions button under the Protected sheets & ranges tab

Give editing permissions to select users

  1. Decide who should have permission to edit those selected cells. Click Restrict who can edit this range.
  2. You can choose Only you under the dropdown menu, and no one else will be able to edit those cells.
Selecting Only you from the Range editing permissions window
  1. If you want a select few people to still be able to make changes to those cells, choose Custom from the dropdown menu.
Choosing the Custom option from the dropdown menu
  1. Finally, click Done.

If anyone without special editing permissions tries to edit those protected cells, they’ll receive a warning message stating that the cell is protected. They will need to contact you to get permission to edit the locked cells.

Pro Tip

Organize your Jotform form data in Google Sheets seamlessly — sign up for free today.

How to lock an entire sheet in Google Sheets

Protecting certain cells can be useful if you want others to be able to make edits to other portions of a sheet. However, if you want to protect a whole sheet, you can prevent anyone from making changes to any part of it. You can choose to give only yourself editing permissions, or you can give specific people the ability to make edits.

  1. To start, open the sheet you want to protect.
  2. Right-click on the sheet tab that you’ll be protecting. This process only applies to one tab at a time, so you’ll need to repeat it for any other tabs you want to protect.
  3. Click on the Protect sheet option. This will open a Protected Sheets and Ranges pane to the right of the sheet.
Clicking on the Protect sheet option from the dropdown
  1. In the Protected Sheets and Ranges pane, enter a description of what you’re doing, like “Protecting sheets from any editing.”
Entering Protecting sheets from any editing to the Protected Sheets and Ranges pane
  1. Double-check that the sheet name in the second field reflects the name of the sheet you want to protect.
  2. Click on the Set permissions button.
Clicking on the Set permissions button on the Protected Sheets and Ranges pane
  1. Select Restrict who can edit this range.
  2. In the dropdown, choose Only you if you want to be the only one who can edit the sheet. If you want to give certain people the ability to make edits, then choose the Custom dropdown option. Deselect any collaborators you don’t want to have editing permissions.
Choosing Only you option from the Range editing permissions window
  1. Click on Done.

How to unlock cells in Google Sheets

Need to make changes to locked content later on? Here’s how you can easily unlock cells:

  1. Open the Google Sheet that contains the locked cells.
  2. Click Data in the top menu, then select Protected sheets and ranges.
Selecting Protected sheets and ranges option on the dropdown
  1. In the pane that appears on the right, find the range or sheet you want to unlock.
Displaying the range and the sheet to unlock on the Protected sheets & ranges window
  1. Click the trash can icon next to the range or sheet description.
Clicking on the trash can icon on the Protected sheets & ranges window
  1. Confirm that you want to remove the protection.

Once deleted, those cells will no longer be restricted, and anyone with edit access to the document will be able to make changes.

Benefits of locking cells in Google Sheets

Locking cells in Google Sheets offers several benefits, especially when working in collaborative environments:

  • Prevent accidental edits: Ensure that complex formulas and critical data aren’t changed unintentionally.
  • Protect sensitive data: Limit access to confidential information to only trusted collaborators.
  • Maintain version integrity: Keep formatting and structure consistent across users.
  • Control permissions flexibly: Choose exactly who can and cannot make changes to specific ranges.
  • Improve productivity: Reduce time spent on correcting errors caused by unauthorized edits.

Making the most of Google Sheets

Google Sheets is a powerful tool for any business, and when you know how to use functions like protected ranges and cells, you can make this tool work even better for your business.

If you frequently work in spreadsheets, then it may be time to upgrade your spreadsheet-database software. Options like Jotform Tables can allow for seamless collaboration, and you can import CSV or Excel files directly to help get you up and running quickly. Jotform Tables is also equipped with templates like budget sheets and calendar templates to further save you time.

No matter what programs and software your business uses, spreadsheets are sure to be a key element. When you understand their functionality and features, you’ll get the most out of these tools and make your business more efficient.

Photo by Vojtech Okenka from Pexels

AUTHOR
A journalist and digital consultant, John Boitnott has worked for TV, newspapers, radio, and Internet companies for 25 years. He’s written for Inc.com, Fast Company, NBC, Entrepreneur, USA Today, and Business Insider, among others.

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments: