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

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

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

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

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

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

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

Removing email address links
 

thanks it solved my problem.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=556472