Removing all hyperlinks

[Kiran Kumar]

Hi All,


Is there any way I can remove all hyperlinks in my excel spreadsheet at once!?


Regards,

KK

 

[Kiran Kumar]

hey! I got the answer. ha ha


Here it is!!


Sub Hyperlink_remove()


Sheets("Test1").Hyperlinks.Delete


End Sub

 

[Kiran Kumar]

Hi Folks,


I appreciate you have a better answer only through excel and not through macros.


I can select each cell and remove but that is very manual. Need to remove all the hyperlinks at once. Please note that the cells addresses keep changing for me.


Regards,

KK

 

[bobhc]

Good day Kiran Kumar


Select all cells, right click and choose remove hyper links

 

[Kiran Kumar]

Hi Bobhc,


I cant see remove hyper links option when I select all cells. It appears only when I right click on single cell.


Appreciate for any answer to it!


Regards,

KK

 

[shrivallabha]

1. Invoke FIND and REPLACE option [CTRL + H].

2. In FIND and REPLACE, click on "OPTIONS >>" which will show more options.

3. In FIND option select FORMAT dropdown | Choose Format from Cell. Select a cell which is having hyperlink.

4. In REPLACE option select FORMAT dropdown | Choose Format from Cell. Select a cell which is NOT having hyperlink.


and do "REPLACE ALL". Hopefully, it should help!

 

[Kiran Kumar]

Nope, doesn't work. Only the link highlight color(blue) has gone and not the hyperlink.


Any solution please!?


Regards,

KK

 

[Kiran Kumar]

Hi All,


I just found that there is no direct option to clear all hyperlinks at once! The only option is macros.


Thanks for all of your efforts in trying to get the answer.


Regards,

KK

 

[bobhc]

Good day Kiran Kumar


What version of Excel are you using, I an on 2010 and the select/right click/remove hyper links works

 

[Debraj]

Hi Kiran,

You can do this by TRICS..


* Select a blank cell (without Hyperlink)

* Write 1.

* Copy this Cell.

* Now Select all area with HYPERLINK.

* Press (Alt + E + S + M) (Paste > Special > Multiply)

* Gotcha.. All Hyperlinks Gone..


Regards,

Deb

 

[bobhc]

Kiran Kumar


If you are using 2007u/2010 find this link of help


http://www.extendoffice.com/documents/excel/416-remove-hyperlinks-excel.html

 

[Kiran Kumar]

Hi Debraj,


Tat was fantastic trick. thanks everyone for your support!


Regards,

KK

 

[shrivallabha]

Debraj,


Cool trick