View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
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