Remove hyperlink in Excel worksheet

[Kent]

Dear all,

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

Thanks

Kent

 

[CellShocked]

Dear all,

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

Thanks

Kent

What Excel? 2003? 2007?

 

[Mike H]

Hi,

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

Mike

 

[JP]

You can turn off auto-hyperlink creation, so any future URLs or email
addresses you type won't 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=58075 (scroll down to
bottom)

--JP

 

[Dave Peterson]

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.

 

[Kent]

Dear all,

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

BR
Kent