prevent cell content from being interpreted as a hyperlink?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

keithb - 31 Aug 2005 20:19 GMT

Is there some way of formatting cells that prevents cell content from being
interpreted as a hyperlink?

Thanks,

Keith

Reply to this Message

Dave Peterson - 31 Aug 2005 20:44 GMT

xl2002 added a feature to turn this off.

tools|autocorrect|autoformat as you type tab
uncheck that top box.

If you're using xl2k or below, hit ctrl-z as soon as excel converts it to a
hyperlink.

Or start your entry with an apostrophe:

'www.microsoft.com

> Is there some way of formatting cells that prevents cell content from being
> interpreted as a hyperlink?
>
> Thanks,
>
> Keith

Signature

Dave Peterson

Reply to this Message

keithb - 31 Aug 2005 23:54 GMT

I have 'inherited' a group of spreadsheets that has cells containing @
symbols, and tools|autocorrect|autoformat replace as you type is unchecked.
Even so, Excel treats these cell as a hyperlink. How can remove the
hyperlink treatement while retaining the cell content?

Thanks,

Keith

> xl2002 added a feature to turn this off.
>
[quoted text clipped - 16 lines]
>>
>> Keith

Reply to this Message

Dave Peterson - 01 Sep 2005 01:01 GMT

Select the range to clean up
(ctrl-a (twice in xl2003) will select the whole sheet.)
then hit alt-f8 (to get to the VBE)
then hit ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete

Then back to excel to see what happened.

> I have 'inherited' a group of spreadsheets that has cells containing @
> symbols, and tools|autocorrect|autoformat replace as you type is unchecked.
[quoted text clipped - 29 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message