Highlight All Named Ranges with Single Click in Excel Office 365!!
Tags: highlightallnamedran, kutoolsexceltutorial, kutools
Published: 2020-10-06 08:54:07

---
title: Highlight All Named Ranges with Single Click in Excel Office 365!!
published: true
date: 2020-10-05 11:52:54 UTC
tags: HighlightAllNamedRan,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/highlight-all-named-ranges-with-single-click-in-excel-office-365/
---

In this article, we are going to see the steps to **Highlight All Named Ranges with Single Click in Excel Office 365** using **Kutools** with example. 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.
## Highlight All Named Ranges:

If you want to highlight all named ranges in the workbook, you need to do the below steps.

- 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>

- It will enable the **Design Tab,** where you need to **choose** the **Highlight Names** option.

![choose the Highlight Names option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-6.png)<figcaption id="caption-attachment-15196">choose the Highlight Names option</figcaption>

- Now, it will show all the highlighted names ranges in the spreadsheet as shown in the below image.

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

### Note:

- If you enable **Highlight Unlocked/Highlight Hidden/Highlight Formulas** 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 Names** 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.

## Bottom-Line:

In the above article, you can clearly understand the steps to **Highlight All Named Ranges with Single Click in Excel Office 365** using **Kutools** with example. Leave 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/)