How to *not* highlight, color, and underline web and email addresses?

[jsteph]

Hi all,
I have an excel sheet where I'm storing email and web addresses, and I need to edit existing data a fair amount, also need to copy/paste portions of some data to other cells.

The problem is that when Excel does that thing where it 'automatically' creates a hyperlink, it makes it difficult to edit.

I can't find an option that seems to fit that behaviour which I could turn off.
The purpose of this spreadheet is not to be a web page (I didn't think Excel was ever meant for that) so I don't need people linking directly from this excel sheet to the web or email.
Thanks,
--Jim

 

[randy700]

If you right click the cell, you can select the option to remove the hyperlink.


Randy

 

[PeterMoran]

Hi,

You have not said which version of Excel you are using, but anyway this may be of assistance:

http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html

This is a great site!

I also did a search on "Stop hyperlinks" (top right corner of screen) here for some other approaches if this does not cover your needs.

Good Luck.

Peter Moran

 

[SkipVought]

Hi,

This procedure will delete all hyperlinks in the active workbook.

Sub RemoveHLs()
    Dim ws As Worksheet, hl As Hyperlink
    
    For Each ws In ActiveWorkbook.Worksheets
        For Each hl In ws.Hyperlinks
            hl.Delete
        Next
    Next
End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Gruuuu]

Auto Link Generation is a function of Auto Correct.
You can turn off the Auto Correct option for email addresses and web addresses.