Highlight/Color All Unlocked Cells with One Click in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstohighlightorco, kutools
Published: 2020-10-08 08:01:44

---
title: Highlight/Color All Unlocked Cells with One Click in Excel Office 365!!
published: true
date: 2020-10-06 08:37:09 UTC
tags: KutoolsExcelTutorial,StepstoHighlightorCo,Kutools
canonical_url: https://geekexcel.com/highlight-color-all-unlocked-cells-with-one-click-in-excel-office-365/
---

In this article, you will understand the steps to **Highlight/Color All Unlocked Cells with One Click in Excel Office 365** using **Kutools.** Let’s get 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.
## Steps to Highlight/Color All Unlocked Cells:

To highlight or color all unlocked cells with Kutools, do as follows.

- First, you need to enable the **Design Tab. ** To do this, on 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/10/EXCEL_cJkt0ALDpj.png)<figcaption id="caption-attachment-15195">select the Worksheet Design option</figcaption>

- Now, you can see the **Highlight Unlocked** option in the **Protect** section.

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

### Before Highlight the Unlocked Cells:

![Before Highlight Unlocked Cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Before-Highlight-Unlocked-Cells.png)<figcaption id="caption-attachment-15232">Before Highlight Unlocked Cells</figcaption>

### After Applying Highlight Unlocked Option:

- You just **click** the **Highlight Unlocked** option to get the result as shown in the below image.

![Highlight Unlocked Cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Highlight-Unlocked-Cells.png)<figcaption id="caption-attachment-15233">Highlight Unlocked Cells</figcaption>

### Note:

- If you enable **Highlight Unlocked/Highlight Hidden/[Highlight Formulas](https://geekexcel.com/highlight-all-formula-cells-with-color-in-excel-office-365/)** option in the **Design Tab,** the **Highlight Names** feature will turn off automatically.

![Options in Desigh Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-5.png)<figcaption id="caption-attachment-15199">Options in Design Tab</figcaption>

- When you **close** the **Design Tab,** the **Highlight Unlocked** feature will turn off.
- To change the highlight color, you need to go to the **Settings option** in the **Design Tab.**
- It will open the **Design Tools Settings dialog box** , where you need to specify the **Names Color**.

![Design Tools Settings Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Design-Tools-Settings-Dialog-Box.png)<figcaption id="caption-attachment-15200">Design Tools Settings Dialog Box</figcaption>

- **Click** the **OK** button.

## Closure:

In the above article, you can clearly understand the steps to **Highlight/Color All Unlocked Cells with One Click in Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

## See Also:

- [How to Find the Largest Value Smaller than a Specified Number in Excel?](https://geekexcel.com/how-to-find-the-largest-value-smaller-than-a-specified-number-in-excel/)
- [How to Extract Substring Between Two Texts in Excel?](https://geekexcel.com/how-to-extract-substring-between-two-texts-in-excel/)