How to remove hyperlinks without removing formatting?

In Excel, deleting hyperlinks often removes not only the links but also the cell formatting, such as background color, font, and size, as shown in the screenshot. However, there are times when we want to retain the cell formatting while removing the hyperlinks. Is there a solution to address this issue?

Remove hyperlinks without removing formatting with Clear Hyperlinks feature

Remove hyperlinks without removing formatting with Kutools for Excel

Remove hyperlinks without removing formatting with Clear Hyperlinks feature

The Clear Hyperlinks feature simplifies this process, ensuring that formatting remains intact. Please do as this:

1. Select the cells containing hyperlinks you want to remove.
2. Click Home > Clear > Clear Hyperlinks, see screenshot:

   

3. The hyperlinks are removed, but the text formatting remains untouched.

   

Remove hyperlinks without removing formatting with Kutools for Excel

With Kutools for Excel, you can quickly and easily remove hyperlinks from your worksheet, whole workbook or selected range while preserving all formatting. No more worrying about losing your carefully designed cell styles!

1. Click Kutools > Link > Remove Hyperlinks Without Losing Formatting, then, you can choose the remove scope, such as selected range, active sheet, selected sheets or all sheets as you need. see screenshot:

   

2. Then, the hyperlinks are removed at once but the formatting are kept.

Using Excel's built-in Clear Hyperlinks feature allows you to quickly remove hyperlinks while retaining formatting. However, with Kutools for Excel, you can batch-remove hyperlinks across multiple worksheets or even an entire workbook, all while preserving formatting. Choose the method that best suits your needs! If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials.

Related articles:

How to change multiple hyperlink paths at once in Excel?

How to extract actual addresses from hyperlinks in Excel?