Easy methods to Lock Cells in Google Sheets


Think about spending hours making a Google Sheet to share along with your workforce, solely to seek out {that a} workforce member by accident deleted an necessary column, row, cell, or, even worse — a whole sheet.

marketer learns how to lock cells in google sheets

→ Access Now: Google Sheets Templates [Free Kit]

That may be irritating. Nonetheless, it is solely preventable if you happen to lock cells in Google Sheets.

Because it seems, with just some clicks of a mouse, you may lock cells and full sheets in Google Sheets — that means, you and your workforce can work on the identical sheet with out hindering the following particular person from finishing their assigned duties.

On this put up, we’ll go over methods to lock and unlock cells in Google Sheets.

Desk of Contents

The Advantages of Locking Cells in Google Sheets

Google Sheets permits customers to lock cells from enhancing, which implies you may shield your Sheet from any potential accidents, together with enhancing and deletion.

It’s also possible to shield necessary knowledge and calculations, so you may relaxation simple understanding the formulation in your Sheet are appropriate and correct.

The power to lock cells in Google Sheets comes with a wide range of advantages.

Not solely are you able to lock cells from enhancing, however you can too management which workforce members can edit your doc — proper all the way down to the very cells these workforce members are allowed to govern.

That is extraordinarily useful if a number of workforce members are engaged on the identical Sheet without delay. It’s also possible to copy permissions from different sheets, when you’ve got locked cells in different Sheets.

Let’s check out the steps to lock cells in Google Sheets.

Easy methods to Lock Particular Cells in Google Sheets

Locking particular cells in Google Sheets is a straightforward job. Right here’s methods to do it:

1. Proper-click on the cell you need to lock.

After opening a brand new Google Sheet (or a Sheet you’ve gotten already been working in), right-click on the cell or cells you need to lock.

How to lock cells in google sheets, step 1: right-click on the cell you want to lock.

2. Hover over “View extra cell actions.”

This feature is listed on the backside of the dropdown menu.

Relying on the place your cells are positioned within the Sheet, you could have to scroll down till you see it. While you see it, hover over the “View extra cell actions” to open up one other menu.

How to lock cells in google sheets, step 2: hover over “view more cell actions.”

3. Choose “Shield vary.”

The subsequent menu will provide you with a number of extra cell actions. Search for the motion labeled “Shield vary.” Select “Shield vary” to start assigning cells to a locked standing.

Protect cells google sheets, step 3: select “protect range.”

Alternatively, you may carry out the identical job by clicking on the Information tab and selecting “Shield sheets and ranges.”

Protect cells google sheets, alternate step 3: click on the “data” tab and select “protect sheets and ranges.”

4. Select “Add a sheet or vary” from the aspect panel.

After clicking “Shield vary” from the dropdown menu or “Shield sheets and ranges” from the Information tab, you’ll discover the open aspect panel on the fitting of your display. Click on on “Add a sheet or vary.”

Protect cells google sheets, step 4: select “add a sheet or range” from the side panel.

5. Select which cells to lock.

Subsequent, resolve which cells to lock from enhancing. In the event you click on the cell you need to lock, that cell’s info shall be referenced within the vary part. If it is advisable to lock a variety of cells, enter the vary into the sector.

Google sheets protected cells, step 5: choose which cells to lock.

6. Choose “Set permissions.”

Choose “Set permissions” to decide on who can edit the chosen cells. In the event you’re the one particular person allowed to edit the cell, be sure you select “solely you.”

It’s also possible to copy permissions from different sheets, when you’ve got locked cells in different Sheets.

Google sheets protected cells, step 6: select “set permissions.”

7. Choose “Completed.”

When you’re completed locking cells from enhancing, click on “Completed” to avoid wasting your preferences. Now, these cells are locked from enhancing till you unlock them and alter the settings.

ow to lock cells in google sheets, step 7: select “done.”

Easy methods to Lock Cells and Give Enhancing Permission to Choose Customers

In the event you and your workforce are working in a Google Sheet, take into account giving enhancing permissions to pick out customers. This may enable you assign duties and higher handle your challenge and hold others from by accident deleting necessary work.

To lock cells and provides enhancing permission to pick out customers, comply with these steps.

1. Proper-click the chosen cells.

Select the cell or cells you wish to prohibit. Then, right-click to open up the dropdown menu.

How to lock cells in google sheets, step 1: right-click on the cell you want to lock.

2. Hover “View extra cell actions.”

Scroll or look to the underside of the dropdown menu and hover over “View extra cell actions.” This may open one other menu in your display.

How to lock cells in google sheets, step 2: hover over “view more cell actions.”

3. Choose “Shield vary.”

To vary a cell’s enhancing standing, select “Shield vary.” This motion will open a aspect panel menu.

Protect cells google sheets, step 3: select “protect range.”

4. Click on “Add a sheet or vary” from the aspect panel.

Within the aspect panel, click on “Add a sheet or vary.” Clicking this button will help you enter which cells or sheets to lock.

Protect cells google sheets, step 4: select “add a sheet or range” from the side panel.

5. Select which cells to lock.

Decide which cells your workforce member must carry out their assigned job. Then, enter the vary of cells into the field.

Google sheets protected cells, step 5: choose which cells to lock.

6. Choose “Set permissions.”

When you’ve entered the specified cells within the field, you’ll have to set enhancing restrictions. To limit entry to the vary of cells, click on “Set permissions.”

Google sheets protected cells, step 6: select “set permissions.”

7. Select “Customized.”

From this display, you’ve gotten the choice to resolve who has permission to edit the vary of cells. So as to add a workforce member or a number of workforce members, click on “Customized.”

How to lock cells in google sheets, step 7: select “custom.”

8. Assign editors to cells.

Now, you may resolve who wants enhancing entry to the vary of cells you’ve gotten specified. Enter the e-mail addresses of your workforce members to assign them as editors of the cells. This may give them enhancing entry to designated cells throughout the sheet.

Remember to click on “Completed” to avoid wasting the vary enhancing permissions.

How to lock cells in google sheets, step 8: assign editors to cells and select “done.”

Easy methods to Lock an Whole Sheet

There could also be occasions you will want to lock a whole sheet from enhancing. Fortunately, this can be a easy course of.

To lock a whole sheet, you may right-click on any cell throughout the doc to open the dropdown menu. You’ll take the identical steps to lock a whole sheet as you probably did with locking only one cell.

Right here’s methods to do it:

1. Proper-click on any cell.

Proper-click on any cell in your Google Sheet to open a drop-down menu. To lock a whole sheet, it doesn’t matter which cell you utilize to do that.

How to lock cells in google sheets, step 1: right-click on any cell.

2. Hover over “View extra cell actions.”

Select the “View extra cell actions” possibility on the backside of the dropdown menu. You do not want to click on. Simply hover over it to open one other menu.

ow to lock cells in google sheets, step 2: hover over “view more cell actions.”

3. Choose “Shield vary.”

Click on “Shield vary” to open the permissions aspect panel. Alternatively, you may attain the “Protected sheets and ranges” aspect panel by clicking on the Information tab and deciding on “Shield sheets and ranges.”

Protect cells google sheets, step 3: select “protect range.”

4. Select “Add a sheet or vary” from the aspect panel.

Click on “Add a sheet or vary” to start locking a whole sheet.

Protect cells google sheets, step 4: select “add a sheet or range” from the side panel.

5. Click on on “Sheet.”

Click on on the “Sheet” button to lock a whole sheet. When you’re within the Sheet tab, choose which Sheet you wish to lock.

ou have the choice to exclude sure cells from being locked. In the event you want sure cells open for enhancing, click on the field for “Besides sure cells” and specify the vary.

Google sheets protected cells, step 5: click on “sheet.”

6. Choose “Set permissions.”

Earlier than you may lock your Sheet, it is advisable to set enhancing permissions. Choose “Set permissions” to decide on who can edit the locked Sheet. In case you are the one particular person allowed to edit the sheet, be sure you select “Solely you.”

Google sheets protected cells, step 6: select “set permissions.”

When you’ve decided who has enhancing permissions in your Sheet, both simply you or members of your workforce, make sure to hit “Completed” to avoid wasting the permissions. Now your Sheet is locked and can’t be edited with out permission.

Google sheets protected cells, step 6: select “done” after “set permissions.”

Easy methods to Present a Warning however Enable Enhancing of Locked Cells

In the event you’re engaged on a doc concurrently with workforce members and also you don’t need your cells to be modified, you may permit customers to obtain a warning earlier than accepting their edits.

To point out a warning, comply with these steps:

1. Proper-click on the cells you need to lock.

In your Google Sheet, right-click on the cells you need to lock. You’ll be able to set a warning for a whole Sheet by following this course of as properly.

How to lock cells in google sheets, step 1: right-click on the cell you want to lock.

2. Hover over “View extra cell actions.”

Scroll to the underside of the menu and hover over “View extra cell actions.”

How to lock cells in google sheets, step 2: hover over “view more cell actions.”

3. Choose “Shield vary.”

To set an enhancing warning on sure cells or your Sheet, click on “Shield vary” to assign cells or a Sheet to a warning standing.

Protect cells google sheets, step 3: select “protect range.”

4. Select “Add a sheet or vary” from the aspect panel.

On the fitting of your display, you will notice an open aspect panel menu. Click on “Add a sheet or vary.”

Protect cells google sheets, step 4: select “add a sheet or range” from the side panel.

5. Select which cells or sheet to set an enhancing warning.

You’ll be able to set an enhancing warning for a variety of cells or a whole sheet. Within the aspect panel, decide which cells or sheets want a warning and ensure the knowledge referenced within the field matches your required cells or sheet.

Google sheets protected cells, step 5: choose which cells or sheet to add an edit warning.

6. Choose “Set permissions.”

After you’ve gotten verified which cells or sheets ought to have an enhancing warning, click on “Set permissions” to go to the enhancing choice display.

Google sheets protected cells, step 6: select “set permissions.”

7. Select “Present a warning when enhancing this vary.”

How to lock cells in google sheets, step 7: choose “show a warning when editing this range,” then select “done.”

Choose “Present a warning when enhancing this vary,” then hit “Completed” to avoid wasting your enhancing permissions.

If a consumer tries to make modifications within the semi-locked cell or Sheet, they’ll obtain a warning message as a heads-up. Customers should both click on “Cancel” or “Okay” to make modifications or revert to the unique doc.

How to lock cells in google sheets, step 7: If a user tries to make changes in the semi-locked cell or Sheet, they will receive a warning message as a heads-up.

Easy methods to Unlock Cells

Locking a cell or a Sheet is extraordinarily useful in sustaining the integrity of your knowledge. However, there shall be occasions when you will want to unlock a cell to replace or change the knowledge inside it.

Now that you simply perceive methods to lock cells, let’s check out methods to unlock them.

1. Proper-click on the cells you need to unlock.

In your Google Sheet, right-click on the cell it is advisable to unlock. This motion opens a dropdown menu.

How to unlock cells in google sheets, step 1: right-click on the cell you want to unlock.

2. Hover over “View extra cell actions.”

Search for the “View extra cell actions” possibility within the drop-down menu. This feature is positioned on the backside of the dropdown menu. While you discover it, hover your mouse over the motion.

How to unlock cells in google sheets, step 2: hover over “view more cell actions.”

3. Choose “Shield vary.”

Like locking a cell, you’ll nonetheless have to click on on the “Shield vary” possibility. This may open a aspect panel menu the place you may select to unlock the cell.

Protect cells google sheets, how to unlock cells step 3: select “protect range.”

4. Click on on the locked cell.

Within the aspect panel menu, you will notice a listing of locked cells inside your Sheet. Click on on the cell or cell vary that you simply want to unlock.

Protect cells google sheets, how to unlock cells step 4: click on the locked cell or range you want to unlock.

5. Click on the garbage can icon.

Subsequent, click on on the garbage can icon to the aspect of the outline field.

Google sheets protected cells, how to unlock cells step 5: click the trash can icon.

6. Choose “Take away.”

A warning display will pop up asking if you wish to take away the protected vary. In case you are certain you need to unlock the cell, click on the “Take away” button.

When you click on the button, your cell is free to be edited by anybody with enhancing permission for the doc.

Google sheets protected cells, how to unlock cells step 6: select “remove.”

Locking Cells in Google Sheets

And there you’ve gotten it! Remember to take a while to set enhancing preferences and assign sure cells or sheets to your workforce.

When you’ve accomplished that, you and your workforce can confidently work on the identical Google Sheet with out worrying somebody will by accident edit or delete necessary info.

business google sheets templates



Source_link

Leave a Reply

Your email address will not be published. Required fields are marked *