Disabeling Hyperlinks

Hi Nathalie,

You can disable all hyperlinks without code by selecting an empty cell and
choosing Copy, then select all the cells containing hyperlinks and choose
Edit, Paste Special, Add.

This works in all versions of Excel but in 2007 the cells still "look like"
they are hyperlinks. Just change the format.

Cheers,
Shane Devenshire
Microsoft Excel MVP
Join http://setiathome.berkeley.edu/ and download a free screensaver and
help search for life beyond earth.


"Nathalie Krochmann" wrote in message
...
Hi everyone,

any ideas how to avoid email and internet addresses generally? I'm tired
of removing each hyperlink.

Thanks in advance,
Nathalie