Configure Cells to be Locked or Unlocked When Protecting Worksheet!!
Tags: configurecellstobelo, kutoolsexceltutorial, kutools
Published: 2020-11-07 04:18:49

---
title: Configure Cells to be Locked or Unlocked When Protecting Worksheet!!
published: true
date: 2020-11-06 12:08:53 UTC
tags: Configurecellstobelo,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/configure-cells-to-be-locked-or-unlocked-when-protecting-worksheet/
---

In this article, we are going to see how to **Configure Cells to be Locked or Unlocked when Protecting Worksheet** in **Excel Office 365** using **Kutools.** Let’s step into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Unlock Selected Cells or Range & Highlighting Unlocked Cells with Color:

To [unlock selected cells](https://geekexcel.com/how-to-select-all-unlocked-cells-in-excel-office-365-with-example/) in the worksheet, do as follows.

- First, you need to **select the cells** which you want to unlock. To select multiple ranges as you need, just hold down the **CTRL key** and select them.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-12.png)<figcaption id="caption-attachment-16840">Example</figcaption>

- Next, you need to go to the **Kutools Plus Tab, select** the **Worksheet Design** option.

![Select the Worksheet Design option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Worksheet-Design-option.png)<figcaption id="caption-attachment-16837">Select the Worksheet Design option</figcaption>

- It will show the **Design Tab** in the ribbon.
- You need to click the **Unlock Cells** option in the **Protect** section.

![Select the Unlock Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Unlock-Cells-option.png)<figcaption id="caption-attachment-16841">Select the Unlock Cells option</figcaption>

- Then, a **prompt**   **box** will pop-out to tell you that all the selected cells have been unlocked.
- **Click** the **OK** button to close it.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Prompt-box.png)<figcaption id="caption-attachment-16842">Prompt box</figcaption>

- To protect this worksheet, you need to **select** the **Protect Sheet** option under the **Design Tab.**

![Click the Protect Sheet option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-Protect-Sheet-option.png)<figcaption id="caption-attachment-16843">Click the Protect Sheet option</figcaption>

- In the popped-out dialog box, you need to **enter** and **confirm** the **password** as you need.

![Enter the password](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Enter-the-password.png)<figcaption id="caption-attachment-16844">Enter the password</figcaption>

- After protecting your worksheet, you can [highlight the unlocked cells](https://geekexcel.com/highlight-color-all-unlocked-cells-with-one-click-in-excel-office-365/).
- To do that, you need to click the **Highlight Unlocked** option under the **Design Tab.**

![Select the Highlight Unlocked option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Highlight-Unlocked-option.png)<figcaption id="caption-attachment-16845">Select the Highlight Unlocked option</figcaption>

- Now, you can see that all **unlocked cells** will be **highlighted with color** as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-6.png)<figcaption id="caption-attachment-16846">Result</figcaption>

## Lock Selected Cells or Range in Worksheet:

If you want to lock selected cells or range in the worksheet, follow the below steps.

- You need to **select the whole worksheet** to lock all the unlocked cells.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-1-1.png)<figcaption id="caption-attachment-16847">Example</figcaption>

- Next, you need to go to the **Kutools Plus Tab, select** the **Worksheet Design** option.

![Select the Worksheet Design option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Worksheet-Design-option.png)<figcaption id="caption-attachment-16837">Select the Worksheet Design option</figcaption>

- It will show the **Design Tab** in the ribbon.
- You need to **click** the **Lock Cells** option under the **Design Tab.**

![Select the Lock Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Lock-Cells-option.png)<figcaption id="caption-attachment-16838">Select the Lock Cells option</figcaption>

- After that, a prompt box will pop-out to tell you that all the unlocked cells have been locked at once.
- You need to **click** the **OK** button to close this prompt box.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-OK-button.png)<figcaption id="caption-attachment-16839">Click OK button</figcaption>

## Wind-Up:

In the above article, you can clearly understand the steps to **Configure Cells to be Locked or Unlocked when Protecting Worksheet** in **Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [How to Print Only Specific, Even or Odd Pages in Excel Office 365?](https://geekexcel.com/how-to-print-only-specific-even-or-odd-pages-in-excel-office-365/)
- [Freeze Panes Across Multiple Worksheets in Excel Office 365](https://geekexcel.com/how-to-freeze-panes-across-multiple-worksheets-in-excel-office-365/)