The Accidental Emails
When you are building a contact list or a customer database in Microsoft Excel, typing an email address (like `[email protected]`) will result in Excel automatically converting that plain text into a blue, underlined, clickable hyperlink the moment you press Enter. While this seems helpful, it is incredibly annoying for data entry. If you later try to click on that cell to edit a typo in the email address, you will accidentally trigger the hyperlink, forcing Excel to launch Microsoft Outlook or your default mail client in a new window, completely derailing your workflow.
How to Disable Automatic Hyperlinks Globally
You can turn off this AutoFormat behavior deep within the Excel options, forcing the software to treat all email addresses (and website URLs) as plain, unclickable text forever.
1. Open Microsoft Excel.
2. Click on the File tab in the top-left corner of the ribbon.
3. Click Options at the bottom of the left-hand sidebar.
4. In the Excel Options window, click on Proofing in the left menu.
5. Click the large button at the top right labelled AutoCorrect Options…
6. A new dialog box 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, then click OK again to close the Options menu.
From now on, anything you type will remain exactly as plain text.
How to Remove Existing Links in Bulk
Disabling the setting above prevents new links from forming, but it does not fix the hundreds of blue hyperlinks already infecting your spreadsheet. To clean up your existing data:
1. Press Ctrl + A to select your entire worksheet (or highlight just the column containing the email addresses).
2. Right-click anywhere inside the highlighted area.
3. From the context menu, select Remove Hyperlinks (it is usually near the bottom of the list).
Instantly, every single blue link in the selected area will be stripped of its hyperlink properties and converted back to standard, plain text formatting.