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?

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.

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

no effect Dave, seanrigby's suggestion works

Originally Posted by Dave Peterson

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

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

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?

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

thanks it solved my problem.