Excel and Hyperlinking

  User-312386 17:28 25 Jan 05
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 05

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 05

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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…