If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|