How to Remove Hyperlinks in a Data Range

When hyperlinks in the worksheet are not useful anymore, you can either clear them or remove them. The format of the context will also be removed. Please follow the steps below to remove the hyperlinks:

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

Step 2: Right click and select "Remove Hyperlinks" from the list;

Alternatively, click "Clear" in the "Home" tab, then select "Remove Hyperlinks";

Step 3: All hyperlinks including contents and formats are removed.

Leave a Reply