How do I disable hyperlinks in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to turn off whatever it is that makes live hyperlinks out of
everything with an @ in it. Any ideas?
 
Hi sweetj95-

Go to Tools>Autocorrect Options. On the 'AutoFormat As You Type' page,
remove the check for Internet....

HTH |:>)
 
Go to Tools>Autocorrect Options. On the 'AutoFormat As You Type' page,
remove the check for Internet....
Click to expand...

Thank you for the response, but I don't have an AutoFormat As You Type page.
Maybe I'm working with a different version. My Autoformat box has only one
tab, "AutoCorrect". The Options are:
Correct TWo INitial CApitals
Captilalize first letter of sentence
Capitalize names of days
Correct accidental cAPS lOCK
Replace Text as you type

And there's an Exceptions box.
 
Hi

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
 
Apparently you are using Excel 2000 or earlier.

I don't know of a global setting t disable the effect altogether, but you
can right-click a hyperlink cell, point to Hyperlink in the shortcut menu &
choose Remove hyperlink.

BTW- It's always a good idea to specify version when posting.

Good Luck |:>)
 
It is possible to do this:

Office Button > Excel Options > Proofing > AutoCorrect options >

Under Replace as you type, un-check the box that says ' internet and network paths with hyperlinks'.

I am using Excel 2007.

Cheers
 
Back
Top