Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get rid of hyperlinks when cutting and pasting e-mail addre
i just made a post concerning the problem of cutting and pasting e-mail
addresses into excel. they always come out as hyperlinks and it's driving me crazy. i was told to do the following and it does not work. possibly i am going to be forced to type every e-mail address in and if i do that it doesn't happen. Click ToolsAutoCorrect Options... then click the "AutoFormat As You Type" tab, and uncheck "Internet and network paths with hyperlinks" please e-mail me at: thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get rid of hyperlinks when cutting and pasting e-mail addre
Mike, when you paste the hyperlinks into Excel, choose the paste values
option instead of the regular paste. (If you're using the Paste icon in the Excel toolbar, click on the little arrow to the right of it and select the "Values" option; or right-click, choose "Paste Special..." then choose the Values option). "Mike Nolan" wrote: i just made a post concerning the problem of cutting and pasting e-mail addresses into excel. they always come out as hyperlinks and it's driving me crazy. i was told to do the following and it does not work. possibly i am going to be forced to type every e-mail address in and if i do that it doesn't happen. Click ToolsAutoCorrect Options... then click the "AutoFormat As You Type" tab, and uncheck "Internet and network paths with hyperlinks" please e-mail me at: thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get rid of hyperlinks when cutting and pasting e-mail addre
aha! i have it now paul. pretty simple, but for the life of me i could not
figure it out! thanks and have a great day. mike nolan "Mike Nolan" wrote: i just made a post concerning the problem of cutting and pasting e-mail addresses into excel. they always come out as hyperlinks and it's driving me crazy. i was told to do the following and it does not work. possibly i am going to be forced to type every e-mail address in and if i do that it doesn't happen. Click ToolsAutoCorrect Options... then click the "AutoFormat As You Type" tab, and uncheck "Internet and network paths with hyperlinks" please e-mail me at: thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get rid of hyperlinks when cutting and pasting e-mail addre
"Mike Nolan" wrote in message
... i just made a post concerning the problem of cutting and pasting e-mail addresses into excel. they always come out as hyperlinks and it's driving me crazy. i was told to do the following and it does not work. possibly i am going to be forced to type every e-mail address in and if i do that it doesn't happen. Click ToolsAutoCorrect Options... then click the "AutoFormat As You Type" tab, and uncheck "Internet and network paths with hyperlinks" please e-mail me at: thank you. Three points: 1 Don't start a new thread. Keep the discussion in your original thread. 2 Don't ask people to e-mail you. If you ask a question in the group, then look for the reply in the group. That way other people can learn. 3 It is pointless just to say "it doesn't work". If you want further help you'll need to explain what you're doing, what you want to happen, and what the error symptoms are. If your concern is that the answer which you were given stopped you generating new hyperlinks but left you with your existing ones and you want to know how to get rid of them, either Google for: Excel "remove hyperlinks" [and take some of the answers with a pinch of salt] or look at http://support.microsoft.com/default...b;EN-US;223789 -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect sheets against cutting / pasting | Excel Worksheet Functions | |||
Formats when cutting and pasting | Excel Discussion (Misc queries) | |||
Setting up some sort of cutting and pasting loop | Excel Worksheet Functions | |||
Problem encountered when cutting and pasting | Excel Discussion (Misc queries) | |||
when cutting and pasting to different files the year changes... w. | Excel Worksheet Functions |