Remove hyperlinks from range of cells in Excel

For example, I copied and pasted a Table from a web page. By default, it has lot of hyperlinks - how can I remove them all in one shot.

excel remove hyperlinks from range of cells

To do it in Excel, here is the answer:

a) Select the entire range. Since it is possible that clicking on a cell with Hyperlink will redirect to the web page, an area outside of the range can be selected as shown below. This range would be easier to select.

excel remove hyperlinks from range of cells

b) Under "Home", click on "Clear" under "Editing" section. Click on "Clear Hyperlinks" as shown below. All Hyperlinks are removed.

excel remove hyperlinks from range of cells


You can find similar Excel Questions and Answer hereunder

1) How can I remove display of Gridlines in my worksheet using VBA?

2) How can I add a Prefix to a set of numbers in a range?

3) I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?

4) How to see to which cells a cell is connected or used by. How to see the dependents of a cell

5) how to combine the content of two or more cells in Excel

6) How can I remove all nonprintable characters from text?

7) How do I get the 2nd highest number in a range of numbers?

8) How do I find the median salary of employees with the same skillset in my Organization?

9) How can I dynamically add a hyperlink using VBA?

10) How to lock cells so that no one can change them


Here the previous and next chapter