..... I should have explained that you can turn off Excel's eagerness to create hyperlinks in the Options. Let's see, here... Ah, here it is: File, Options, Proofing, AutoCorrect Options, go to the AutoFormat As You Type tab, uncheck "Internet and network paths with hyperlinks".


Bob, I tried this and I think it would prevent any new email addresses I enter into the spreadsheet from being autoformatted as hyperlinks, but I've got nearly 700 lines of data, and I don't want to have to retype every email address to get them NOT to be hyperlinks! After I did this, the remove hyperlink choice is still not available.

I tried looking at protecting the file. It's completely unprotected. It is a shared file, however, but I don't know what that does or how to undo that.

Anyway...I'm done for the night.

Thanks again for helping!

Ain't technology grand?!