Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Remove hyperlink in Excel worksheet

18 views
Skip to first unread message

Kent

unread,
Oct 26, 2009, 7:51:38 AM10/26/09
to
Dear all,

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

Thanks

Kent


CellShocked

unread,
Oct 26, 2009, 8:09:24 AM10/26/09
to

What Excel? 2003? 2007?

Mike H

unread,
Oct 26, 2009, 8:34:02 AM10/26/09
to
Hi,

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

Mike

"Kent" wrote:

> .
>

JP

unread,
Oct 26, 2009, 8:54:42 AM10/26/09
to
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

unread,
Oct 26, 2009, 8:55:09 AM10/26/09
to
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

Kent

unread,
Oct 27, 2009, 3:55:28 AM10/27/09
to
Dear all,

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

BR
Kent

"Dave Peterson" <pete...@verizonXSPAM.net>
???????:4AE59C2D...@verizonXSPAM.net...

0 new messages