When entering website addresses, server pathways, or email addresses into a Microsoft Excel worksheet—such as “example.com” or “[email protected]”—Excel automatically converts your plain text into a blue, underlined, clickable hyperlink the moment you press Enter or Tab. While live links are useful in executive summaries, this automated formatting creates immense frustration during database management, website audits, and inventory logging. The moment you click on a cell to select it, copy its contents, or edit its formula, your default web browser or email client immediately opens, pulling you out of Excel. Selecting cells with hyperlinks requires clumsy click-and-drag maneuvers. Fortunately, Microsoft Excel allows you to turn off automatic hyperlink generation completely. Here is how to stop Microsoft Excel from automatically turning typed URLs into hyperlinks.
Why Disable Automatic Hyperlinks in Microsoft Excel?
Preventing Excel from turning plain text URLs into interactive web links resolves several frequent spreadsheet annoyances:
- Effortless Cell Selection: Single-clicking a cell selects it cleanly for copying, dragging, or formatting without launching your internet browser.
- Consistent Aesthetic Typography: Avoids jarring blue underlined fonts that disrupt your custom workbook font schemes and financial borders.
- Faster Bulk Data Entry: Enter hundreds of domain names, product URLs, or contact email lists without Excel pausing to parse web protocols.
- Clean CSV and Database Exports: Keeps text strings pure without embedded hyperlink metadata interfering with backend database imports.
Step-by-Step: Stop Excel from Auto-Creating Hyperlinks as You Type (Windows)
You can disable this setting permanently across all future workbooks in Excel’s AutoCorrect options:
- Open Microsoft Excel on your computer.
- Click on the File tab in the ribbon and select Options at the bottom of the left-hand navigation pane.
- In the Excel Options dialogue, click on the Proofing category on the left.
- Click the AutoCorrect Options button located near the top.
- In the AutoCorrect dialogue, switch to the AutoFormat As You Type tab.
- Under the section titled Replace as you type, locate the checkbox:
Internet and network paths with hyperlinks. - Untick this checkbox.
- Click OK, and then click OK once more to close Excel Options.
From this point onward, any URL, domain name, or email address you type into Excel will remain clean, unlinked text.
How to Turn Off Automatic Hyperlinks in Excel for Mac
On macOS, adjust the same preference through Excel’s AutoCorrect settings:
- Click Excel in the top Apple menu bar.
- Select Preferences (or press Cmd + ,).
- Under the Authoring section, click on AutoCorrect.
- Click on the AutoFormat As You Type tab.
- Untick the checkbox for Internet and network paths with hyperlinks.
- Close the preferences dialogue.
How to Quickly Remove Hyperlinks from Existing Excel Sheets
Disabling the AutoFormat setting prevents future links from forming, but leaves existing blue hyperlinks untouched. To strip hyperlinks from existing spreadsheet data without losing your text:
- Highlight the range of cells, entire column, or table containing the links (press Ctrl + A to select the entire worksheet).
- Right-click anywhere within the highlighted area.
- Select Remove Hyperlinks from the bottom of the context menu.
Excel instantly strips all underlying web links while preserving your text values and background formatting intact.
Comparison: Auto-Hyperlinks Enabled vs Disabled
| Action | Auto-Hyperlinks Enabled (Default) | Auto-Hyperlinks Disabled (Recommended) |
|---|---|---|
| Clicking a Cell | Launches browser/email client immediately | Selects the cell normally for editing |
| Text Appearance | Forces blue underlined text formatting | Retains your sheet’s native font and colour |
| URL Editing | Requires clicking cell margin or formula bar | Double-click or press F2 to edit directly |
| Manual Link Creation | Automatic on every typed protocol | Available on demand via Ctrl + K shortcut |
Manual Hyperlinks When Needed
Disabling the automatic setting does not prevent you from adding intentional hyperlinks when needed. To link a specific cell manually, simply highlight the cell, press Ctrl + K (or Cmd + K on Mac), paste the web address into the Address field, and click OK.