Hyperlink Issues

JCraig

New Member
Joined
Apr 24, 2007
Messages
8
For whatever reason every cell in my workbook has a hyperlink on it to an email address. Is there any way to remove all the hyperlinks at once in one sheet? Right now I am removing one at a time. Also, any idea how this could have happened?
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,974
Office Version
  1. 365
Platform
  1. Windows
I have run into the same situation. It is quite annoying. Anytime you enter an email address in Excel, or edit an email address in Excel, it automatically converts it to a hyperlink. I don't think there is any way to disable that behavior.

However, you can remove them all at once. Take a look at the code in this post: http://www.mrexcel.com/forum/showthread.php?t=467375
 

JCraig

New Member
Joined
Apr 24, 2007
Messages
8
Thanks! Is this a VBA code? I'm really only experienced in formula's and some formatting as our spreadsheets are used for accounting purposes. How do I use this code? We do have email addresses that are in there but it's okay that they're hyperlinks. The problem is the entire workbook every cell has turned into a hyperlink when it's basic text not an email address. Very strange.
 

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
copy / paste the entire column into Notepad, and then paste back into Excel
 

Watch MrExcel Video

Forum statistics

Threads
1,123,320
Messages
5,600,946
Members
414,417
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top