Excel: Remove Hyperlinks Automatically Inserted by Excel

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: Excel has an annoying habit. Whenever you type something in a cell that looks like an e-mail address or a Web site URL, Excel will underline the value, change the font color to blue, and make it a clickable hyperlink.

  1. Excel will automatically create hyperlinks.

    Strategy: To remove a hyperlink, you right-click the cell and choose Remove Hyperlink.

    You can prevent Excel from adding hyperlinks in the first place. Choose File, Options. Select the Proofing category and then click the AutoCorrect Options button. Choose the AutoFormat As You Type tab in the AutoCorrect dialog. Uncheck the Internet and Network Paths with Hyperlinks check box.

    Additional Details: New in Excel 2010, you can remove the hyperlinks from an entire range at one time. Select the range of hyperlinks and make sure that the active cell contains a hyperlink. Right-click and choose Remove All Hyperlinks.