Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 26th 09, 11:51 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 10
Default Remove hyperlink in Excel worksheet

Dear all,

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

Thanks

Kent



  #2   Report Post  
Old October 26th 09, 12:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 277
Default Remove hyperlink in Excel worksheet

On Mon, 26 Oct 2009 19:51:38 +0800, "Kent" wrote:

Dear all,

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

Thanks

Kent

What Excel? 2003? 2007?
  #3   Report Post  
Old October 26th 09, 12:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default Remove hyperlink in Excel worksheet

Hi,

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

Mike

"Kent" wrote:

Dear all,

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

Thanks

Kent


.

  #4   Report Post  
Old October 26th 09, 12:54 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 897
Default Remove hyperlink in Excel worksheet

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_...ctivation.html
Excel 2003:
http://www.mrexcel.com/forum/showthread.php?t=58075 (scroll down to
bottom)

--JP

On Oct 26, 7:51*am, "Kent" wrote:
Dear all,

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

Thanks

Kent

  #5   Report Post  
Old October 26th 09, 12:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Remove hyperlink in Excel worksheet

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 wrote:

Dear all,

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

Thanks

Kent


--

Dave Peterson


  #6   Report Post  
Old October 27th 09, 07:55 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 10
Default Remove hyperlink in Excel worksheet

Dear all,

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

BR
Kent



"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 wrote:

Dear all,

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

Thanks

Kent


--

Dave Peterson





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove hyperlink if 'remove' option is disabled Vipul New Users to Excel 1 January 8th 08 02:34 PM
i remove the entries in Excel-HyperLink-Browsed web Pages arun Excel Discussion (Misc queries) 1 June 9th 05 08:58 PM
Remove hyperlink when pasting KS Links and Linking in Excel 1 May 11th 05 07:55 PM
Remove Hyperlink chits Setting up and Configuration of Excel 5 March 4th 05 02:09 AM
Remove Hyperlink Janice Excel Worksheet Functions 4 December 1st 04 02:03 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017