Excel guide · 4 min read
How to remove hyperlinks in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Supplier | Website | Contact email | Link |
| 2 | Northwind Supply | www.northwind-supply.com | [email protected] | Northwind Supply |
| 3 | Harbor Packaging | www.harborpack.co.uk | [email protected] | Harbor Packaging |
| 4 | Atlas Freight | www.atlasfreight.com | [email protected] | Atlas Freight |
| 5 | Cedar Print | www.cedarprint.ie | [email protected] | Cedar Print |
| 6 | Delta Labels | www.deltalabels.com | [email protected] | Delta Labels |
Download this sheet as an Excel practice file (.xlsx)
Remove one hyperlink or a whole range
Clicking a linked cell opens the link, so select it with the arrow keys, or click and hold until the pointer changes to a cross. Then use the right-click menu. Remove Hyperlink keeps the text in the cell and drops the link's blue underlined formatting.
The same command works on any selection in Excel 2010 and later: select a column of supplier websites, or press Ctrl+A to select the whole sheet, and the menu item becomes Remove Hyperlinks. Pressing Delete instead would clear the text as well as the link.
- Select the cells with links (Ctrl+A selects the whole sheet).
- Right-click any selected cell.
- Choose Remove Hyperlinks (Remove Hyperlink for a single cell).
Clear Hyperlinks vs Remove Hyperlinks: keeping the formatting
The Home tab has two versions under Clear (the eraser in the Editing group). Remove Hyperlinks takes away the link and its formatting. Clear Hyperlinks takes away only the link, so the text still looks like a link but no longer is one, which confuses people later.
After Clear Hyperlinks, a small Clear Hyperlink Options button appears next to the selection with Clear Hyperlinks Only and Clear Hyperlinks and Formats; pick the second to drop the blue as well. Use Clear Hyperlinks when the cells have formatting you want to keep, such as a fill colour or borders, and then set the font colour yourself. The clear formatting shortcut removes formats in one go.
- Select the cells.
- Go to Home > Clear (in the Editing group).
- Choose Remove Hyperlinks to drop the link and its formatting, or Clear Hyperlinks to drop only the link.
Stop Excel creating hyperlinks as you type
When you type something that looks like a web address (www.harborpack.co.uk) or an email address and press Enter, Excel's AutoFormat turns it into a link. To undo it for that one cell, press Ctrl+Z straight away: the text stays, the link goes. The AutoCorrect Options button that appears under the cell also offers Undo Hyperlink and Stop Automatically Creating Hyperlinks.
To turn it off for good, change the AutoCorrect setting. It's an Excel setting, not a workbook setting, so it applies to every file you work on from then on, and it doesn't touch links that already exist. Other AutoCorrect surprises are covered in Excel autocorrect changing text.
- Go to File > Options > Proofing.
- Click AutoCorrect Options and open the AutoFormat As You Type tab.
- Untick Internet and network paths with hyperlinks and click OK twice.
Links made with the HYPERLINK function
If the cell shows =HYPERLINK(...) in the formula bar, the formula is what makes the link, so the commands above aren't the reliable fix. Column D here builds a link from each website with =HYPERLINK("https://"&B2,A2), which shows the supplier's name and opens their site.
To keep the visible text without a link, select the cells, copy, and paste them as values (Home > Paste > Paste Values, or the paste values shortcut): the formula is replaced by its result, plain text. To keep the address as text instead, drop the HYPERLINK wrapper from the formula.
Result: Northwind Supply
Northwind Supply: the friendly name, which in Excel is a clickable link to https://www.northwind-supply.com.
How do I keep the web address as plain text?
Build the text without HYPERLINK.
Result: https://www.northwind-supply.com
https://www.northwind-supply.com as plain text. A formula result isn't turned into a link; only typing does that.
Links pasted from a web page, and the macro option
Copying a table from a website or an email often brings its links with it. Paste as text instead: Home > Paste > Paste Special, then choose Text or Unicode Text. You get the words without links or web formatting.
For a big workbook where every inserted link on a sheet should go, a one-line macro does it: press Alt+F11, then Ctrl+G to open the Immediate window, type ActiveSheet.Hyperlinks.Delete and press Enter. Save a copy first, because a macro can't be undone with Ctrl+Z. It removes links added with Insert > Link or by AutoFormat, but not HYPERLINK formulas. If a link is meant to work but doesn't, see Excel hyperlink not working.
Common mistakes
Pressing Delete to get rid of a link
Delete clears the text too. Use right-click > Remove Hyperlink to keep the text.
Using Clear Hyperlinks and leaving blue underlined text
Use Remove Hyperlinks, or choose Clear Hyperlinks and Formats from the options button that appears.
Removing links that come back as you keep typing
Turn off Internet and network paths with hyperlinks in AutoCorrect Options > AutoFormat As You Type.
Trying Remove Hyperlinks on a HYPERLINK formula
Paste the cells as values, or edit the formula to return plain text.
FAQ
How do I remove all hyperlinks in Excel at once?
Press Ctrl+A to select the whole sheet, right-click any cell and choose Remove Hyperlinks. The text stays and only the links are removed.
How do I remove a hyperlink but keep the text in Excel?
Right-click the cell and choose Remove Hyperlink. If the link comes from a HYPERLINK formula, copy the cell and paste it as values instead.
Why does Excel keep turning email addresses into links?
AutoFormat As You Type converts anything that looks like a web or email address. Press Ctrl+Z right after typing to undo one, or untick Internet and network paths with hyperlinks in File > Options > Proofing > AutoCorrect Options.
How do I select a cell with a hyperlink without opening it?
Move to it with the arrow keys, or click and hold the mouse button until the pointer becomes a cross, then let go.
Functions used
Related guides
- Excel hyperlink not working: 7 fixes
- How to stop Excel AutoCorrect changing your text
- How to extract the domain from an email address in Excel
- How to use Format Painter in Excel
- How to create an email address from first and last name in Excel
Updated