How To Lock Cells In Google Sheets

Locking and unlocking cells in Google Sheets is a valuable skill to have, so let’s learn how to do it in today’s article.

How To Lock Cells In Google Sheets

PC Guide is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Prices subject to change. Read More

Last Updated on

Google Sheets is a spreadsheet software that allows you to create and edit spreadsheets. The program has become very popular because of its simplicity and ease of use. In addition, it offers features such as charts, graphs, and formulas.

You can easily share your spreadsheet with other people or even collaborate with them. This feature makes Google Sheets a great tool for creating presentations, reports, and financial statements.

You can also lock cells to ensure that the data cannot be tampered with. Let’s take a look at how to do this so that you can learn a crucial skill when it comes to Google Sheets.

1

Locking Specific Cells

To lock specific cells in a sheet, follow these steps:

Step

1

Open The Spreadsheet

1. Open the spreadsheet that you want to lock cells in

Open the spreadsheet that you want to lock cells in.

Step

2

Right-Click On The Cell That You Want To Lock

Right-Click On The Cell That You Want To Lock

Right-click on the cell that you want to lock. From the drop-down menu, pick View More Cell Actions.

Step

3

Now Choose Protect Range

Now Choose Protect Range

Now choose Protect Range. A new window should pop up on the right-hand side of your screen, like below.

Step

4

Click The Add A Sheet Or Range Button

Click The Add A Sheet Or Range Button

Click the Add A Sheet Or Range button on this new pop up. Here you can add a description for the cell you’re going to lock. This is optional, but might be helpful if you are going to need to remember important details about it.

Step

5

Locking Cells

5. Locking Cells

In the Range page you will be able to see the cell’s reference. If you want to lock more than one cell, you can change this here to include more than one cell. Now click on Set Permissions to lock the cell.

Step

6

Choose Who Can Edit The Range

Choose whether you want to allow more people to edit this range or whether you are the only person able to do this. Restricting it to you will ensure that no one tampers with your locked cells, while allowing other people to alter them could be more beneficial on collaborative projects.

2

Unlocking A Cell In Google Sheets

If you have locked a cell in Google Sheets, then you’ll know exactly what I mean when I say that unlocking a cell isn’t quite as easy as locking it. You’ll need to go through some extra steps to unlock a cell. Follow these simple instructions to unlock a cell in Google Sheets.

Step

1

Open The Google Sheet

6. Open The Google Sheet

Open the Google Sheet where you locked the cell.

Step

2

Select The Data Button

 

7. Select The Data Button

Select the Data button from the toolbar to find the drop-down menu.

Step

3

Click Protect Sheets And Ranges

8. Click Protect Sheets And Ranges

Click Protect Sheets And Ranges, and this will open a popup menu on the right-hand side of your screen.

Step

4

Choose The Cell

9. Choose The Cell

Choose the cell that you want to unlock.

Step

5

Click The Delete Widget

10. Click The Delete Widget

Now click the Delete widget which is next to the Description box. Click Remove and that’s it – you’re done!

Final words

Google Sheets is a fantastic bit of software that lets you collaborate on data with others online. if you’re doing this, locking cells is a vital function of the software. Hopefully, we’ve answered all the questions you had on the subject.