Is there any way to prevent Excel from automatically making a hyperlink out
of anything that looks like it ought to be one? I find this "feature" very
annoying.

I don't even like hyperlinks in my spreadsheets. I almost never have a use
for that. Why does Excel force me to deal with them?

Also, there really ought to be an easier, single-click way to remove all
hyperlinks at once. Or is there one I don't know about?

Paul,

Use Tools, AutoCorrent Options... "Autoformat as you type" and un-check "Internet and network links
with hyperlinks"

HTH,
Bernie
MS Excel MVP


"Paul Pedersen" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Is there any way to prevent Excel from automatically making a hyperlink out of anything that looks
> like it ought to be one? I find this "feature" very annoying.
>
> I don't even like hyperlinks in my spreadsheets. I almost never have a use for that. Why does
> Excel force me to deal with them?
>
> Also, there really ought to be an easier, single-click way to remove all hyperlinks at once. Or is
> there one I don't know about?
>
>
>

If you know VBA, it would be easy to write a macro that would remove all of
your hyperlinks froma worksheet.

"Bernie Deitrick" wrote:

> Paul,
>
> Use Tools, AutoCorrent Options... "Autoformat as you type" and un-check "Internet and network links
> with hyperlinks"
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Paul Pedersen" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > Is there any way to prevent Excel from automatically making a hyperlink out of anything that looks
> > like it ought to be one? I find this "feature" very annoying.
> >
> > I don't even like hyperlinks in my spreadsheets. I almost never have a use for that. Why does
> > Excel force me to deal with them?
> >
> > Also, there really ought to be an easier, single-click way to remove all hyperlinks at once. Or is
> > there one I don't know about?
> >
> >
> >
>
>
>

Thanks!

"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:%(E-Mail Removed)...
> Paul,
>
> Use Tools, AutoCorrent Options... "Autoformat as you type" and un-check
> "Internet and network links with hyperlinks"
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Paul Pedersen" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Is there any way to prevent Excel from automatically making a hyperlink
>> out of anything that looks like it ought to be one? I find this "feature"
>> very annoying.
>>
>> I don't even like hyperlinks in my spreadsheets. I almost never have a
>> use for that. Why does Excel force me to deal with them?
>>
>> Also, there really ought to be an easier, single-click way to remove all
>> hyperlinks at once. Or is there one I don't know about?
>>
>>
>>
>
>