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
Note: kutools for Excel 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.
- 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.
- Finally, all the hyperlinks have been removed from the current worksheet without losing the cell formatting.
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. Keep Learning!
Top comments (0)