This explains what you need to do:
http://www.techonthenet.com/excel/macros/delete_hl.php
Basically you have to create a macro to remove all hyperlinks at once. The
link provides detailed instructions on how to do it.
If you get stuck just post another question and someone can walk you through
it.
Dave
--
Brevity is the soul of wit.
"Lorelei" wrote:
I have a simple excel spreadsheet. My spreadsheet includes Company name ,
contact name , email address.. and sometimes the company website.
After a few weeks of adding companies, I have hyperlinks all over the place,
it is hard to click in any cell anymore , as it will go to the email or a
webpage.
my problem does not stop there, I have a new company that I have added, and
I will click on the contact email address, and I will get another hidden
hyperlink email, just aggravating. Is there something like take all
hyperlinks out of spreadsheet without taking the color and information off
the sheets?
If not, please do not tell me I have to go to every cell and say "remove
hyperlink"
thanks