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 |
#1
|
|||
|
|||
Kill the hyperlinks!
I'm creating a mailing list in Excel. I have to add email
addresses, but don't want them as active hyperlinks because this will upset the next phase of the project. As soon as I type the addresses in, Excel 'helpfully' converts them to hyperlinks. If I right click on them, I can disable the hyperlink, but I'll have to do that over 5000 times! Is there a way to stop Excel from creating the hyperlinks in the first place? |
#2
|
|||
|
|||
Kill the hyperlinks!
Hi
depends on your Excel version: Excel 2002+: Goto 'Tools - Autocorrection' and choose the middle tab to disable this feature Prior to this version use one of the following alternatives: a) Use the following macro to remove hyperlinks of a chosen selection (after your data entry) Sub RemoveHyperLinks() selection.hyperlinks.delete end sub b) Without macro: - Type the number 1 in a blank cell and copy this cell - Select all your cells with hyperlinks - goto 'Edit - Paste Special' - choose multiply c) Process the Worksheet_change event (see http://www.mcgimpsey.com/excel/nohyperlinks2.html) -- Regards Frank Kabel Frankfurt, Germany Jax wrote: I'm creating a mailing list in Excel. I have to add email addresses, but don't want them as active hyperlinks because this will upset the next phase of the project. As soon as I type the addresses in, Excel 'helpfully' converts them to hyperlinks. If I right click on them, I can disable the hyperlink, but I'll have to do that over 5000 times! Is there a way to stop Excel from creating the hyperlinks in the first place? |
#3
|
|||
|
|||
Kill the hyperlinks!
Go to Tools -- AutoCorrect Options. Click on the tab titled "AutoFormat As You Type." Uncheck the box next to "Internet and network paths with hyperlinks." -----Original Message----- I'm creating a mailing list in Excel. I have to add addresses, but don't want them as active hyperlinks because this will upset the next phase of the project. As soon as I type the addresses in, Excel 'helpfully' converts them to hyperlinks. If I right click on them, I can disable the hyperlink, but I'll have to do that over 5000 times! Is there a way to stop Excel from creating the hyperlinks in the first place? . |
Thread Tools | |
Display Modes | |
|
|