| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing email address links
I have forgotton the option to make the email address as underlined link. where it is so that I could uncheck it? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing email address links
If you want to remove the hyperlink, try Right-clicking the address you want to deactivate, point to Hyperlink on the shortcut menu, and then click Remove Hyperlink. -- seanrigby ------------------------------------------------------------------------ seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133 View this thread: http://www.excelforum.com/showthread...hreadid=556472 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing email address links
Tools|autocorrect options|autoformat as you type tab
uncheck the "Replace as you type" box starguy wrote: I have forgotton the option to make the email address as underlined link. where it is so that I could uncheck it? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing email address links
no effect Dave, seanrigby's suggestion works Dave Peterson Wrote: Tools|autocorrect options|autoformat as you type tab uncheck the "Replace as you type" box starguy wrote: I have forgotton the option to make the email address as underlined link. where it is so that I could uncheck it? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 -- Dave Peterson -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing email address links
That setting won't affect any existing links. But it will stop any of your new
entries from converting to hyperlinks. starguy wrote: no effect Dave, seanrigby's suggestion works Dave Peterson Wrote: Tools|autocorrect options|autoformat as you type tab uncheck the "Replace as you type" box starguy wrote: I have forgotton the option to make the email address as underlined link. where it is so that I could uncheck it? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 -- Dave Peterson -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing email address links
I have many email addresses which I have already entered in a column. I want them to be as text not hyperlinks. some cells in that column are empty and some have email addresses I want those emails (which are now hyperlinks) to be as text and those as well which I enter later. how could this be done? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing email address links
You can select the range of cells that contain hyperlinks.
Then hit alt-f11 to get to the VBE then hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete You can select as many or as few cells as you want. starguy wrote: I have many email addresses which I have already entered in a column. I want them to be as text not hyperlinks. some cells in that column are empty and some have email addresses I want those emails (which are now hyperlinks) to be as text and those as well which I enter later. how could this be done? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=556472 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make XL stop interpreting email addresses as highlighted links? | Excel Discussion (Misc queries) | |||
| Can you enter @ symbol without becomig email address in a cell? | Excel Discussion (Misc queries) | |||
| I want to pull out companies without an email address? | Excel Worksheet Functions | |||
| how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
| Remove Email address header | Excel Discussion (Misc queries) | |||
Hybrid Mode
