View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lorelei Lorelei is offline
external usenet poster
 
Posts: 2
Default Excel Hyperlinks..how to get rid of them

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