Date: Wed, 8 Jun 2005 15:34:08 -0400 From: Bob Lendrim <[log in to unmask]> Subject: Excel and hyperlinks I use Excel 2000 to keep a list of email addresses. When an address is entered in a cell, Excel, by default, makes it a hyperlink. It is possible, but time consuming, to eliminate the hyperlinks one at a time. Can anyone tell me how to change Excel so it doesn't create hyperlinks automatically? Thank you, Bob Bob, I found a tip and a snippet of code from this website forum and copied it directly. Credit goes to Gord Dibben. "To prevent in the future........ Tools>Autocorrect Options>Autoformat as you type. Uncheck the "replace as you type" box. To get rid of current ones you can edit manually or run a macro on a selected range. Sub removeAllLinksFromSelection() Selection.Hyperlinks.Delete End Sub Gord Dibben Excel MVP" Hope this helps. Chris Ryan [log in to unmask] The NOSPIN Group has added a new feature on our website, web based bulletinboard for questions and answers: Visit our sister website at http://nospin.com