How to Remove Hyperlinks but Keep the Text in Excel｜From Bulk Deletion to Advanced Use Cases

You’ve probably noticed it — every time you paste or import data with web addresses, Excel automatically converts them into blue, underlined hyperlinks. While this can be useful, it often becomes a nuisance when you only want the plain text.

Thankfully, Excel offers several methods to remove hyperlinks while keeping the text intact, whether you’re working with a few cells or thousands.

In this complete guide, you’ll learn how to delete hyperlinks without losing data, perform bulk hyperlink removal, and even explore smart ways to repurpose hyperlink text for advanced data operations.

---

✅ Why Remove Hyperlinks but Keep the Text?

Before we look at the methods, let’s understand why this is such a common need.

・1. Imported Data from Web or Email Lists

When you copy from browsers, reports, or emails, Excel automatically adds clickable links. Removing them keeps your dataset clean.

・2. Visual Clarity

Blue underlined text can distract from your data’s readability — plain text looks more professional in reports.

・3. Formula or Reference Consistency

Hyperlinks can interfere with formulas like VLOOKUP or COUNTIF that expect plain text matches.

・4. Printing and Exporting

Hyperlinks add unnecessary styling when printing or converting to PDF.

・5. Performance

Large spreadsheets with hundreds of links can slightly slow down scrolling and saving.

In short: removing hyperlinks without deleting text is a quick way to improve your workbook’s appearance and efficiency.

---

✅ Method 1: Remove Hyperlinks via Right-Click Menu (Quickest Way)

If you only have a few hyperlinks, the right-click method is the fastest.

・Steps:

1. Select the cell or range containing hyperlinks.
2. Right-click the selection.
3. Choose Remove Hyperlink.

Excel instantly removes the clickable link and formatting — leaving the plain text.

💡 Tip:
This method keeps the text exactly as it was. You can still copy, format, or reference it as normal.

---

✅ Method 2: Remove All Hyperlinks in a Sheet (Using Right-Click)

If your worksheet is filled with hyperlinks, Excel lets you delete them all at once.

・Steps:

1. Press Ctrl + A to select all cells.
2. Right-click anywhere in the selection.
3. Click Remove Hyperlinks.

Every hyperlink on the sheet disappears — only text remains.

・Pros:

• Fast and simple.
• Works in any Excel version (2010 and later).

・Cons:

• Doesn’t work across multiple sheets simultaneously.

For large files, consider VBA (see below).

---

✅ Method 3: Remove Hyperlinks but Keep Text Using Keyboard Shortcuts

There’s a quick keyboard shortcut version of the above method.

・Steps:

1. Select your range (Ctrl + A for all).
2. Press Alt + E + A + A (older Excel versions), or use Ctrl + A → Right-click → Remove Hyperlinks.

This removes all links while preserving the displayed text — perfect for fast cleanup before analysis.

---

✅ Method 4: Remove Hyperlinks Automatically When Pasting

If you paste data from a website or another Excel file, hyperlinks are often inserted automatically.
You can stop this behavior and keep text-only values from the start.

・Option 1: Paste Values Only

1. Copy the data (Ctrl + C).
2. Right-click → Paste Values (or Alt + E + S + V).

This pastes the text without hyperlinks or formatting.

---

・Option 2: Use “Text Import Wizard” for CSVs

When importing data:

1. Go to Data → From Text/CSV.
2. Set the column format to Text.
3. Finish import.

This prevents Excel from auto-creating hyperlinks during import.

💡 Pro Tip:
If you frequently copy URLs but don’t want links, you can disable Excel’s automatic hyperlinking altogether (see Method 7).

---

✅ Method 5: Use VBA to Remove All Hyperlinks at Once (Across Sheets)

For large datasets, the VBA method is the most efficient — especially when multiple sheets contain links.

・Example VBA Code:

Sub RemoveAllHyperlinksWorkbook()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Hyperlinks.Delete
Next ws
End Sub

・Steps:

1. Press Alt + F11 to open the VBA editor.
2. Go to Insert → Module.
3. Paste the above code.
4. Press F5 (Run) or close and run from Alt + F8.

This script removes every hyperlink from the entire workbook while leaving all text untouched.

💡 Tip:
This works even on hidden sheets or protected links that manual methods may skip.

---

・VBA to Remove Only in Active Sheet

Sub RemoveAllHyperlinksSheet()
ActiveSheet.Hyperlinks.Delete
End Sub

Assign this macro to a shortcut key (Ctrl + Shift + H, for example) for one-click hyperlink cleanup.

---

✅ Method 6: Remove Hyperlinks While Keeping Formatting

By default, removing hyperlinks also removes blue underlines.
If you want to keep text color or style, you can manually control formatting.

・Steps:

1. Select cells with hyperlinks.
2. Go to Home → Styles → Cell Styles.
3. Reapply desired style (e.g., “Normal” or “Input”).
4. Right-click → Remove Hyperlink.

If you wish to retain the color or bold text applied manually, reformat after unlinking — Excel removes the hyperlink style but keeps user-applied formatting.

---

✅ Method 7: Disable Automatic Hyperlink Creation (Prevent Future Links)

You can stop Excel from automatically turning URLs and email addresses into hyperlinks.

・Steps:

1. Go to File → Options.
2. Select Proofing → AutoCorrect Options.
3. Click the AutoFormat As You Type tab.
4. Uncheck Internet and network paths with hyperlinks.
5. Click OK.

Now, Excel will never auto-convert text like “www.example.com” or “someone@email.com” into a clickable link again.

💡 Tip:
You can still create hyperlinks manually using Ctrl + K or the HYPERLINK formula.

---

✅ Method 8: Use Formulas to Extract Hyperlink Text or Address

If you want to separate hyperlink text and URLs, Excel doesn’t have a direct formula — but there are workarounds.

・1. Extract Displayed Text

If you copy hyperlink cells into Notepad and paste them back, only the text remains.
Alternatively, use:

=LEFT(A1,LEN(A1))

This just reconfirms the visible value (removing any hyperlink properties).

---

・2. Extract Hyperlink Address (with VBA)

To pull the underlying URL:

Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function

Then in Excel, use:

=GetURL(A1)

This shows the actual URL behind the hyperlink — useful when cleaning or auditing link-heavy datasets.

---

✅ Method 9: Remove Hyperlinks During Data Import with Power Query

If you’re consolidating data from multiple sources, Power Query can automatically strip hyperlinks.

・Steps:

1. Go to Data → Get Data → From Workbook.
2. Select the source file.
3. In the Power Query Editor, hyperlinks appear as plain text by default.
4. Load the query back into Excel.

This ensures your imported data contains no link formatting at all — just values.

---

✅ Method 10: Convert Hyperlinks to Static Text Using Copy-Paste Trick

If VBA isn’t an option, you can use a simple paste technique.

・Steps:

1. Select the cells with hyperlinks.
2. Copy (Ctrl + C).
3. Right-click → Paste Values.

This keeps only the visible text and removes hyperlink functionality.
It’s fast, reliable, and works in all Excel versions.

---

✅ Advanced Use: Repurposing Hyperlink Text for Smart Automation

Sometimes you don’t just want to delete links — you want to use the underlying text for other purposes.
Here are smart ways to reuse hyperlink text efficiently.

・1. Create Clickable Reports from Text

If you’ve stripped hyperlinks but later want them back dynamically:

=HYPERLINK("https://" & A2, "Visit Site")

This recreates hyperlinks from text data in column A.

---

・2. Extract and Analyze Domains

If you have a list of cleaned URLs:

=LEFT(A2,FIND("/",A2,9)-1)

This retrieves the domain name for grouping or analysis.

---

・3. Turn Text into File References

Link cleaned filenames to local folders:

=HYPERLINK("C:\Reports\" & A2 & ".xlsx","Open File")

This converts plain text into dynamic file links.

---

✅ Common Issues When Removing Hyperlinks

Problem	Cause	Solution
Hyperlinks return after re-import	Source formatting preserved	Use Paste Values or Power Query
Text loses color after unlinking	Style reset	Reapply manual formatting
Cannot remove hyperlinks	Protected sheet	Unprotect via Review tab
Links remain in shapes or charts	Object hyperlinks	Delete or edit manually via right-click
Undo unavailable	Manual cleanup	Save a backup before mass removal

---

✅ Bulk Hyperlink Management (Add, Remove, or Audit)

If you often manage hyperlinks, you can use VBA to handle them in bulk — not just remove but also track or rebuild them.

・List All Hyperlinks in a Sheet

Sub ListAllHyperlinks()
Dim ws As Worksheet
Dim hl As Hyperlink
Dim i As Long
Set ws = Sheets.Add
ws.Name = "HyperlinkList"
i = 1
For Each hl In ActiveSheet.Hyperlinks
ws.Cells(i, 1).Value = hl.TextToDisplay
ws.Cells(i, 2).Value = hl.Address
i = i + 1
Next hl
End Sub

This creates a summary sheet listing hyperlink text and their addresses — great for auditing before removing them.

---

・Rebuild All Hyperlinks from a List

After you’ve cleaned up text-only data:

Sub RecreateHyperlinks()
Dim i As Long
For i = 1 To Range("A" & Rows.Count).End(xlUp).Row
If Range("B" & i).Value <> "" Then
ActiveSheet.Hyperlinks.Add _
Anchor:=Range("A" & i), _
Address:=Range("B" & i).Value, _
TextToDisplay:=Range("A" & i).Value
End If
Next i
End Sub

This re-creates hyperlinks from cleaned data in column A (text) and B (addresses).

---

✅ Excel Versions and Compatibility Notes

Excel Version	Bulk Remove Feature	Auto Hyperlink Option	VBA Support
Excel 2010	✔	✔	✔
Excel 2013	✔	✔	✔
Excel 2016 / 2019	✔	✔	✔
Excel 365	✔	✔	✔
Excel for Web	✖ (limited)	✖	✖

💡 Note:
Excel Online (browser version) doesn’t support hyperlink removal via right-click or VBA.
Download the file and open it in the desktop app to perform these tasks.

---

✅ Real-World Examples

・1. Cleaning Imported CRM Data

Remove hyperlinks from customer email lists before running mail merges or filters.

・2. Exporting Data to CSV

Plain text ensures clean exports — hyperlinks can disrupt formatting in external tools.

・3. Preparing Reports for Printing

Removing hyperlinks eliminates colored text and underlines for a professional print layout.

・4. Bulk Processing Web Lists

Scrape URLs, remove links, and reapply them selectively for analysis or automation.

・5. Shared Workbooks

Removing hyperlinks reduces confusion and prevents accidental web navigation by collaborators.

---

✅ Best Practices for Managing Hyperlinks in Excel

1. Use Paste Values whenever importing data from external sources.
2. Disable Auto Hyperlink Creation if you don’t need it.
3. Keep a backup before running VBA scripts.
4. Audit hyperlink-heavy workbooks with a link summary sheet.
5. Apply consistent formatting after cleaning — especially for printed reports.

These habits ensure clean, functional data without losing valuable text content.

---

✅ Summary：Keep Your Text Clean and Hyperlink-Free in Excel

Removing hyperlinks but keeping text is a simple yet essential skill for anyone who manages imported or formatted data in Excel.

Key Takeaways:

• Use Right-click → Remove Hyperlink for quick edits.
• Use Ctrl + A → Remove Hyperlinks for entire sheets.
• Use VBA for workbook-wide cleanup.
• Disable Auto Hyperlinking to prevent future issues.
• Repurpose hyperlink text for automation and reporting.

By mastering these methods, you can keep your spreadsheets professional, readable, and optimized for analysis — all while maintaining the integrity of your data.