Using a macro,
you can eliminate the ones you don't want based on selection.
By using Ctrl+A to select all cells on the entire sheet you can
eliminate all hyperlinks with the same macro. Additional information
can be found
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperLinks
Sub DelHyperLinks()
Selection.Hyperlinks.Delete
End Sub
Since this is not the programming group you may need help to
install and use the macro see my getstarted.htm web page.
Since you are not posting with your name and email address it is
impossible to even guess whether you read anything about newsgroups
ahead of time. I just looked at the CDO (Communities) for posting
a message and they tell you absolutely nothing
So I would suggest taking a look at
http://www.mvps.org/dmcritchie/excel/xlnews.htm
to at least help you try to obtain information faster on your own
before posting. I would obtain and use a hotmail address and my
first and lastname rather than posting anonymously if I wanted to
protect myself from Spam. I will continue to use my name and my
email address to enjoy a much more friendly / businesslike experience..
ap@twc said:
I copied a list from a website and into Excel. I want to deactivate the hyperlinks from all the items. There are around 700 cells.
I know how to do it cell by cell, but hoping there is an easier way.
