Excel and Hyperlinking

  User-312386 17:28 25 Jan 2005
Locked

Hi all

I have an excel sheet with loads of e-mail addresses and i DO NOT want them to be hyperlinked. I know you can hold down and right click and remove hyperlink. I just don't want hyperlinking on.

I cant see in the menus where this option is to turn it off.

From a very frustrated madboy

  VoG II 17:45 25 Jan 2005

I don't know how to turn this feature off. However you can convert them. E.g with a hyperlink in B4

=LEFT(B4,LEN(B4))

and you could then copy this down as far as needed.

  User-312386 20:25 25 Jan 2005

Go to tools>Auto Correct Options>Auto Format As you type "tab"

Now untick the box that says "Internet and network paths with hyperlinks"

Found it after 2 hours

Thanks for your help VoG™

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Nokia 8 vs Galaxy S8

How artist Alex Yanes worked with his daughter on this bright 3D mural for Monument Valley 2

iMac 21.5-inch (2017) review

Comment regarder le lancement du Galaxy Note 8 en direct ?