how to completely remove hyperlink

L

leasaac

I was keying in some information in excel and all of them begins wit
http://www.... It kind of irritates me when I am always clicking ont
the information and it brings me to the web address type in, which i
not what I want. Is there a way to completely key in just text and n
links or whatsoever
 
L

litos_aldovea

I hope this helps,

If you add an apostrophe before the internet address, the cell stil
will look as it was before and you avoid the hyperlink. This techniqu
is usually used when you want excel to recognise numbers as text, fo
example in headings and stuff like that.

'http://.......

regards,
Carlos
 
R

Ron de Bruin

In 2002/2003 you can turn it of

Tools > Options > Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK

If you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start with a '


You can run this macro also to make text of all hyperlinks
in your worksheet

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run
 
Top