How to Clear Hyperlinks in a Data Range

If you think the hyperlinks in the worksheet are not useful anymore, you can either clear the hyperlinks or remove the hyperlinks. The advantages to clear hyperlinks is that the format of the context will be the same. Please follow the steps below to clear the hyperlinks:

Step 1: Select the data range (or the whole worksheet) where you want to clear;

Step 2: Click "Clear" in the "Home" tab, then "Clear Hyperlinks";

Step 3: All hyperlinks are removed, but the formats stay.

To also remove the formatting, repeat the steps and click "Remove Hyperlinks".

Leave a Reply