The Accidental Email Trigger
When you are typing data into Microsoft Excel, such as a list of client contacts, you will notice that the moment you type an email address (like `[email protected]`) and press Enter, Excel automatically turns that text into a blue, underlined hyperlink. This is incredibly frustrating because the next time you try to click on that cell to edit the spelling of the name, Excel interprets your click as a command to launch Microsoft Outlook and compose a new email. You are forced to awkwardly click the blank white space at the edge of the cell just to select it safely.
How to Disable “AutoFormat As You Type”
You can turn off this automatic link creation entirely by modifying Excel’s core AutoCorrect settings, ensuring that URLs and email addresses remain as plain, unclickable text.
1. Open Microsoft Excel.
2. Click on the File tab in the top-left corner of the ribbon.
3. Select Options at the bottom of the left-hand green sidebar.
4. In the Excel Options window, click on Proofing in the left menu.
5. Click the large button near the top labelled AutoCorrect Options…
6. A new, smaller window will appear. Click the tab at the top labelled AutoFormat As You Type.
7. Look in the “Replace as you type” section.
8. Untick the checkbox labelled Internet and network paths with hyperlinks.
9. Click OK on both windows to save your changes.
How to Remove Existing Hyperlinks
Changing this setting prevents Excel from making new hyperlinks, but it will not fix the blue text you have already typed. To clean up an existing list of emails without deleting the text itself, highlight all the affected cells, right-click anywhere in the highlighted area, and select Remove Hyperlinks from the context menu (usually near the very bottom). The text will instantly revert to standard black font and become safe to click on again.