Delete All Hyperlinks from Range, Worksheet, Workbook in Excel 365!!
Tags: kutoolsexceltutorial, stepstodeleteallhype, kutools
Published: 2020-10-30 07:14:43

---
title: Delete All Hyperlinks from Range, Worksheet, Workbook in Excel 365!!
published: true
date: 2020-10-29 12:16:44 UTC
tags: KutoolsExcelTutorial,StepstoDeleteAllHype,Kutools
canonical_url: https://geekexcel.com/delete-all-hyperlinks-from-range-worksheet-workbook-in-excel-365/
---

In this article, we will explain how to **Delete All Hyperlinks from Range, Worksheet, or Workbook in Excel Office 365** using **Kutools.** 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.
## Remove Hyperlinks but Keep Cell Formatting:

- Here, we come up with a great feature of Kutools that is **Remove Hyperlinks Without Losing Formatting.**
- Using this utility, you can remove all hyperlinks from the selected range, active worksheet, active workbook, and multiple worksheets without losing the cell formatting.
- Apply this feature by clicking **Kutools Tab, select** the **Link** option, then **choose** the **Remove Hyperlinks Without Losing Formatting**.
- Then, you need to specify any one of the following options from the drop-down list, **active worksheet** , **selected multiple worksheets, all worksheets,** or a **specified range.**

![Go to the Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Go-to-the-Kutools-Tab-2.png)<figcaption id="caption-attachment-16445">Go to the Kutools Tab</figcaption>

- For example, we will remove the hyperlinks in the **active worksheet**.
- Now, it will open the **prompt box,** you need to **click** the **Yes** button.

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

- Finally, all the hyperlinks have been removed from the current worksheet without losing the cell formatting.

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

### Note:

- You can also **restore** the removed hyperlinks by doing the **Undo (CTRL** + **Z** )operation instantly.
- This utility supports **one level Undo**.

## Closure:

From the above article, you can clearly understand the steps to **Delete All Hyperlinks from Range, Worksheet, or Workbook in Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Remove All Macros within Worksheet or Workbook in Excel?](https://geekexcel.com/how-to-remove-all-macros-within-worksheet-or-workbook-in-excel/)
- [Delete All Sheets Except Current/Active One from Workbook in Excel!!](https://geekexcel.com/delete-all-sheets-except-current-active-one-from-workbook-in-excel/)
- [How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)