Excel automatically converts typed web addresses and email addresses into clickable hyperlinks. This AutoCorrect feature is designed for convenience but can disrupt data entry and formatting. The behavior is controlled by a single setting in the Excel Options menu. This article explains how to turn off automatic hyperlinks and manage them in your worksheets.
Key Takeaways: Disabling Automatic Hyperlinks
- File > Options > Proofing > AutoCorrect Options: This is the main dialog where you can turn off the automatic formatting of internet and network paths.
- Ctrl + Z (Undo): Immediately removes a hyperlink that was just created, reverting the text to plain format.
- Right-click > Remove Hyperlink: Deletes the hyperlink from a single cell without affecting the displayed text.
How Excel’s AutoCorrect for Hyperlinks Works
Excel’s AutoCorrect feature includes a rule for recognizing internet and network paths. When you type a string that matches a common URL pattern like www.example.com or an email address like user@domain.com, Excel applies hyperlink formatting. The text turns blue and underlined, and clicking it will open your default web browser or email client. This happens in real time as you press Enter or move to another cell.
The feature is intended to save time when creating documents with live links. However, it can be problematic when entering data for analysis, lists, or import into other systems where hyperlinks are not wanted. The setting applies globally to Excel but does not affect hyperlinks that have already been created in a workbook.
Steps to Turn Off Automatic Hyperlinks
You can disable this feature permanently through the AutoCorrect settings. The change will apply to all new workbooks you create or edit on your computer.
- Open Excel Options
Launch Excel and click the File tab on the ribbon. Select Options from the bottom of the left-hand menu. - Navigate to Proofing Settings
In the Excel Options dialog box, select the Proofing category from the left sidebar. - Open AutoCorrect Options
Click the AutoCorrect Options button in the top right section of the window. - Disable the Hyperlink Rule
In the AutoCorrect dialog, go to the AutoFormat As You Type tab. Uncheck the box labeled Internet and network paths with hyperlinks. Click OK to confirm, then click OK again to close Excel Options.
Remove Hyperlinks from Existing Data
Disabling the setting stops new hyperlinks from forming. To clean up existing hyperlinks in a worksheet, use a different method.
- Select the Cells
Select the range of cells containing the hyperlinks you want to remove. To select all cells, click the triangle at the intersection of the row and column headers. - Use the Clear Command
On the Home tab of the ribbon, find the Editing group. Click the Clear button, which looks like an eraser. From the dropdown menu, select Remove Hyperlinks.
Common Mistakes and Limitations
Hyperlinks Reappear After Editing the Cell
If you edit a cell that previously contained a hyperlink and type the URL again, Excel may recreate the link. This happens even with the AutoCorrect setting off if the original hyperlink format was not fully cleared. Ensure you use the Remove Hyperlinks command before re-entering data. Alternatively, format the cell as Text before typing the URL.
Pasting Text from Web Pages Creates Hyperlinks
Copying text from a browser and pasting it into Excel often brings hidden hyperlink formatting. The AutoCorrect setting does not control this paste behavior. To paste only the plain text, use Home > Paste > Paste Special and select Values. You can also right-click the destination cell and choose the Paste Values icon under Paste Options.
Setting Does Not Apply to Other Users
The AutoCorrect setting is stored in your application preferences on your computer. If you share a workbook, other users will still have hyperlinks created automatically on their systems if their setting is enabled. To distribute a workbook without active hyperlinks, you must remove all hyperlinks before sending the file.
AutoCorrect Settings vs. Manual Removal: Key Differences
| Item | Disable AutoCorrect Setting | Manual Remove Hyperlinks Command |
|---|---|---|
| Scope | Prevents new hyperlinks in all future workbooks | Clears hyperlinks only from the currently selected cells |
| Effect on Existing Data | No change to links already in the file | Immediately converts hyperlinks to plain text |
| Persistence | Setting stays off until you re-enable it | Action is one-time; new links can still form |
| Best Use Case | When you never want automatic links during data entry | For cleaning up a specific dataset or before sharing a file |
You can now stop Excel from creating unwanted hyperlinks during data entry. Use the AutoCorrect setting in Proofing options for a permanent solution. For quick cleanup, remember the Remove Hyperlinks command on the Home tab. A useful advanced tip is to use the keyboard shortcut Alt + H + E + H to run the Remove Hyperlinks command without using the mouse.