A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel & hyperlinks



 
 
Thread Tools Display Modes
  #1  
Old December 28th, 2003, 11:14 PM
external usenet poster
 
Posts: n/a
Default Excel & hyperlinks

How do I opt out of the automatic creation of hyperlinks in
Excel? I know how to remove them once they are created,
but I don't want to have to do that. Instead, I want the
default to be that Excel just treats it as text, and not a
URL or email address. How do I do that? Thanks.
  #2  
Old December 28th, 2003, 11:44 PM
Norman Harker
external usenet poster
 
Posts: n/a
Default Excel & hyperlinks

Hi!

For XL2002/2003 you can turn this feature off in Tools/Autocorrect.

For other versions, see JE's instructions:

http://www.mcgimpsey.com/macoffice/e...yperlinks.html

and

http://www.mcgimpsey.com/macoffice/e...perlinks2.html


He's written from a MacXL perspective, but the concepts translate
easily to WinXL.

Perhaps, the easiest way is to precede the entry with an '


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
wrote in message
...
How do I opt out of the automatic creation of hyperlinks in
Excel? I know how to remove them once they are created,
but I don't want to have to do that. Instead, I want the
default to be that Excel just treats it as text, and not a
URL or email address. How do I do that? Thanks.



  #3  
Old December 29th, 2003, 12:33 AM
Jim
external usenet poster
 
Posts: n/a
Default Excel & hyperlinks

Thanks for the help!

-----Original Message-----
Hi!

For XL2002/2003 you can turn this feature off in

Tools/Autocorrect.

For other versions, see JE's instructions:


http://www.mcgimpsey.com/macoffice/e...yperlinks.html

and


http://www.mcgimpsey.com/macoffice/e...perlinks2.html


He's written from a MacXL perspective, but the concepts

translate
easily to WinXL.

Perhaps, the easiest way is to precede the entry with an '


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax

and Arguments)
available free to good homes.
wrote in message
...
How do I opt out of the automatic creation of

hyperlinks in
Excel? I know how to remove them once they are created,
but I don't want to have to do that. Instead, I want

the
default to be that Excel just treats it as text, and

not a
URL or email address. How do I do that? Thanks.



.

  #4  
Old December 29th, 2003, 12:57 AM
Norman Harker
external usenet poster
 
Posts: n/a
Default Excel & hyperlinks

Hi Jim!

It's JE and Ron de Bruin who should be thanked here!

I knew that this was recently covered and did a Google Search using
Ron de Bruin's Google Search tool and found a recent posting by JE.

For Ron's extremely useful and user friendly search tool, pay a visit
to:

Ron de Bruin
http://www.rondebruin.nl/Google.htm

Google Search 6.0 has now been released and is a great improvement on
the older versions. Indeed, as I write, there have been a couple of
additional changes made. The user Guide is still the old Google Search
5.0 one but the Version 6.0 is getting towards completion. However,
the tool is pretty intuitive and the Guide is really only needed for
beginners and those with problems.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Jim" wrote in message
...
Thanks for the help!

-----Original Message-----
Hi!

For XL2002/2003 you can turn this feature off in

Tools/Autocorrect.

For other versions, see JE's instructions:


http://www.mcgimpsey.com/macoffice/e...yperlinks.html

and


http://www.mcgimpsey.com/macoffice/e...perlinks2.html


He's written from a MacXL perspective, but the concepts

translate
easily to WinXL.

Perhaps, the easiest way is to precede the entry with an '


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax

and Arguments)
available free to good homes.
wrote in message
...
How do I opt out of the automatic creation of

hyperlinks in
Excel? I know how to remove them once they are created,
but I don't want to have to do that. Instead, I want

the
default to be that Excel just treats it as text, and

not a
URL or email address. How do I do that? Thanks.



.



  #5  
Old January 1st, 2004, 04:34 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default Excel & hyperlinks

Hi Jim,
I personally find it a lot easier to just let then get created then run
a macro to eliminate the hyperlinks from the selection area(s).
This way if you actually want them they aren't automatically removed.
The other methods do nothing to stop them from being created they
simply remove them once created.

Build Table of Contents, similar listings, working with Hyperlinks
Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
http://www.mvps.org/dmcritchie/excel...#DelHyperLinks,

Use of a single name as an anonymous poster or different names
in postings and replies, and from one thread to another will not help
you find your postings and threads later on in the newsgroups archives
Even with two names before the anonymous portion, there may be
others with the same fake email address, but at least it will narrow
the range in finding your own postings and their threads.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jim" wrote in message ...
Thanks for the help!

-----Original Message-----
Hi!

For XL2002/2003 you can turn this feature off in

Tools/Autocorrect.

For other versions, see JE's instructions:


http://www.mcgimpsey.com/macoffice/e...yperlinks.html

and


http://www.mcgimpsey.com/macoffice/e...perlinks2.html


He's written from a MacXL perspective, but the concepts

translate
easily to WinXL.

Perhaps, the easiest way is to precede the entry with an '


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax

and Arguments)
available free to good homes.
wrote in message
...
How do I opt out of the automatic creation of

hyperlinks in
Excel? I know how to remove them once they are created,
but I don't want to have to do that. Instead, I want

the
default to be that Excel just treats it as text, and

not a
URL or email address. How do I do that? Thanks.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.