remove hyperlinks from range of cells in Excel

Q123. In Excel, how can I remove hyperlinks from a range of cells?

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 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 excel excel remove hyperlinks from range of cells

 

You can find similar Excel Questions and Answer hereunder

1) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?

2) Is there a way I can average a range of numbers even if there is an error value in range?

3) Determine if hyperlinks are valid in Excel

4) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?

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

6) How can I identify cells with Circular Reference in a WorkSheet?

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

8) How can I find the count of records that meet multiple conditions in my raw data table?

9) In a Table , how can I remove duplicate records?

10) How can I identify all cells with Conditional Formatting in my WorkSheet?

11) Calling a macro from another workbook in Excel

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

13) 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?

14) How can I find the sum of records that meet a given condition in my raw data table?

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