Excel - Remove hyperlink in Excel worksheet

Asked By Kent

26-Oct-09 07:51 AM

Dear all,

Please advise the way remove the hyperlink in my excel worksheet.

Thanks

Kent

26-Oct-09 08:09 AM

What Excel?  2003?  2007?

26-Oct-09 08:34 AM

Hi,

Right click the link and select 'remove hyperlink' form the popup menu.

Mike

26-Oct-09 08:55 AM

You can select the cell with the name (and hyperlink) and hit ctrl-k (this
option is Insert|Hyperlink in xl2003 menus and in the Insert Tab of the ribbon
(Links group)).

And remove each hyperlink one at a time.

Another way if you have more than a couple.

Select the range to fix (all the cells is ok if you want)
Hit alt-f11 to get to the VBE (where macros live)
Hit ctrl-g to see the immediate window
type this and hit enter:
Selection.hyperlinks.delete

then hit alt-f11 to get back to excel and see if it worked.


--

Dave Peterson

26-Oct-09 10:41 AM

You can turn off auto-hyperlink creation, so any future URLs or email
addresses you type will not turn into hyperlinks.

Excel 2007:
http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html
Excel 2003:
http://www.mrexcel.com/forum/showthread.php?t=3D58075 (scroll down to
bottom)

--JP

27-Oct-09 03:55 AM

Dear all,

Thank you all but Dave's most fit my case.

BR
Kent



???????:4AE59C2D.7D684A47@verizonXSPAM.net...