How to lock cells in Google Sheets and Excel

The locking cell feature is among the numerous protective features in Google Sheets and Excel. This feature prevents the change of any data or formula contained in the locked Cell. In this article, we shall discuss how to lock Google Sheets and Excel.

To lock Cell(s) in Google Sheets

To lock a single cell

Here are the steps to follow while naming a specific cell in Google Sheets.

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. From the Google Apps, click on the Sheets icon and select the existing Sheet.

3. Locate and click on the Cell you want to lock.

4. Right-click on the selected Cell and hover the cursors over the View cell more Actions button.

5. From the side-view pane, choose the Protect range button.

6. Click the Add a range or sheet button on the right pane. Then, enter the description of the Cell in the Description box.


7. Then, click on the Set permissions button. Choose who can edit the Cell from the dialogue box and hit the Done button.

To lock multiple cells

Steps to follow:

1. Highlight the cells you want to lock.

2. Right-click on the selected cells and hover the cursor over the View cell more Actions button.

3. From the side-view pane, choose the Protect range button.

4. Click the Add a range or sheet button on the right pane.

5. Then, enter the description of the Cell in the Description box. Then, click on the Set permissions button.

6. Choose who can edit the Cell from the dialogue box, and hit the Done button.

To lock the Entire Sheet

Steps to follow:

1. Right-click on the Sheet you are working on, and hover the cursor over the View cell more Actions button.

2. From the side-view pane, choose the Protect range button.

3. Click the Add a range or sheet button on the right pane. Click on the Sheet tab.


4. Then, enter the description of the Cell in the Description box. Then, click on the Set permissions button.

5. Choose who can edit the Cell from the dialogue box, and hit the Done button.

To lock Cell(s) in Excel

To lock a single Cell

Steps to follow:

1. Open the Excel application.

2. Click on the Cell you want to lock.

3. Click on the Home tab, hit the Format Cells drop-down button, and choose the Lock Cell option.

To lock the Entire Sheet

Steps to follow:

1. Open the Excel application.

2. Click on the Cell you want to lock.

3. Click on the Home tab, hit the Format Cells drop-down button, and choose the Protect Sheet option.

4. Enter the locking password in the password section.

5. Using the Checkbox, check or uncheck the checkboxes in the Allow all users of this worksheet section.


To lock Cell using the Format cell tool

Steps to follow:

1. Open the Excel application.

2. Click on the Cell you want to lock.

3. Right-click and choose the format cell option.


4. From the dialogue box, click on the protection tab.

5. Check the Locked checkbox.

Leave a Comment