How to Remove Hyperlinks in Excel: Single & Bulk Methods 2026 September

Hyperlinks in Excel start out helpful and quickly become annoying. You paste a list of company names from a website, and every single one turns blue. You type an email address into a cell, hit Enter, and Excel converts it into a clickable link without asking. Then you try to click the cell to edit it — and instead Excel opens your browser. Frustrating? Absolutely.

This guide shows you how to remove hyperlinks in Excel the fast way. Right-click handles a single cell. Ctrl+A plus right-click clears every link on a sheet in newer Excel versions. The Clear command on the Home tab gives you finer control over what stays and what goes. And if you're dealing with imported data that keeps coming back hyperlinked, the AutoCorrect setting will stop the problem at the source.

You'll also see how to deal with HYPERLINK formulas — these aren't the same as the blue underlined text Excel creates automatically, and they need a different approach. Macros help when you're working with thousands of links across multiple sheets. By the end, removing hyperlinks won't feel like a chore. It'll feel like muscle memory.

Before diving into specific methods, it's worth understanding what kind of link you're looking at. Excel has two flavors of hyperlinks, and they behave differently. The first is the friendly auto-format link — Excel sees something that looks like a URL or email, slaps blue formatting on it, and registers a click target. The second is the HYPERLINK function, written as a formula like =HYPERLINK("https://example.com", "Click here"). Same blue appearance, completely different beast.

Why does this matter? Because the right-click menu only removes auto-format hyperlinks. If you've got formula-based links, you need to delete the formula itself or convert it to a plain value. Mistaking one for the other wastes time and leaves links behind. Click a cell and check the formula bar. See =HYPERLINK(...)? That's a formula. See a plain URL or just text? That's the auto-format kind.

The quickest method for a single cell is right-click then Remove Hyperlink. Two clicks and you're done. The text stays. The blue formatting and underline go away. The cell becomes plain text. This works on Windows, Mac, and Excel for the web. The keyboard shortcut equivalent is Shift+F10, which opens the context menu without your hand leaving the keyboard.

For multiple cells, select the range first. Drag across the cells, or hold Shift and click the last cell in your selection, or use Ctrl+Click for non-adjacent cells. Then right-click any selected cell and choose Remove Hyperlinks (plural). Excel strips every link in the selection at once. Speed depends on the cell count — under a thousand cells finishes instantly, ten thousand might pause for a second.

The whole-sheet trick is Ctrl+A then right-click Remove Hyperlinks. The first Ctrl+A selects the current data region. The second Ctrl+A press selects every cell in the worksheet. Right-click after either of these, pick Remove Hyperlinks, and you're done. This option only appeared in newer Excel versions — 2010 and later on Windows, 2016 and later on Mac. Older versions need a different approach, which is where the macro comes in.

The Clear menu on the Home tab gives you precision the right-click menu can't. Select your cells, head to Home > Editing > Clear (the little eraser icon), and you'll see five options. Clear All wipes everything — values, formatting, hyperlinks, comments, the lot. Clear Formats removes formatting but keeps the data and (importantly) the hyperlink. Clear Contents kills the value but leaves formatting and the link. Clear Comments handles cell comments. Clear Hyperlinks — the one you want — removes the link target but leaves the blue formatting behind.

Wait, blue formatting stays? Yes, and that's deliberate. Clear Hyperlinks only kills the underlying link. The visual style sticks around. If you want clean black text with no underline, follow up with Clear Formats, or use Remove Hyperlink from the right-click menu, which handles both in one step. The Clear menu shines when you've got formatting you want to preserve — like bold dates or color-coded cells — and just need the clickable behavior gone.

Paste Special is the secret weapon for hyperlinks that arrive with imported data. You copy a table from a website. You paste it into Excel. Half the cells turn blue. Sound familiar? Skip the cleanup entirely by pasting differently the next time. Copy the source, but instead of Ctrl+V, use Ctrl+Alt+V to open Paste Special. Choose Values, then OK. Excel pastes the text without any of the source formatting or links.

For data already pasted, you can fake the same effect. Select the messy range, press Ctrl+C, then Ctrl+Alt+V, and pick Values. Excel replaces the selected cells with their own values — minus all the link infrastructure. It's a strip-mining operation that works on any kind of formatting too: conditional formats, custom number formats, you name it. The cells reset to plain values with default styling.

There's a subtle distinction between Paste Values and Paste Values and Number Formats. The first option strips everything — formatting included — so numbers in currency format show up as raw digits. The second option keeps number formats while removing the rest. Pick based on whether you want the visual presentation preserved. For pure hyperlink stripping with no other goals, plain Paste Values gives you the cleanest result. For business reports where currency or percentage formatting matters, the second option saves time later.

Worth remembering: Paste Special > Values overwrites the source cells. If you want to keep the original linked data and create a separate clean version, paste into a different range or worksheet instead. Many analysts maintain a "raw" sheet with imported data and a "clean" sheet with the stripped values. The pattern works well because you can re-import or re-paste raw data without losing your clean copy.

HYPERLINK formulas need their own treatment. Right-click won't help. The Clear Hyperlinks command won't touch them. They're formulas, and Excel sees them as such. To remove them, you've got two paths. Path one: delete the formula. Select the cells, press Delete, formula gone. But the values they returned are also gone — useful only if you wanted the link AND the link text removed.

Path two is more common: convert to values. Select the cells with HYPERLINK formulas, press Ctrl+C, then Ctrl+Alt+V, pick Values, press Enter. Excel replaces the formulas with their displayed text (the second argument of the HYPERLINK function). You keep the visible content. The clickable link disappears. Mission accomplished without losing data.

Stopping Excel from making hyperlinks in the first place is better than removing them after the fact. The setting lives under File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type tab. Look for "Internet and network paths with hyperlinks" and uncheck it. From that point on, when you type a URL or email address, Excel leaves it as plain text. No blue. No underline. No accidental browser launches.

On Mac, the same option is under Excel > Preferences > AutoCorrect > AutoFormat As You Type. Same checkbox name, same effect. The setting is per-application, not per-workbook, so once you turn it off, every new file behaves itself. Existing hyperlinks won't disappear — this only affects future typing — but you've cut off the source of the problem.

If you ever want a hyperlink back, you can still create one manually. Right-click any cell and choose Hyperlink (or Ctrl+K) to open the Insert Hyperlink dialog. Pick your target, add display text, and the link appears. This gives you control: links when you want them, plain text when you don't.

VBA macros are overkill for one sheet but unbeatable across a workbook. The Hyperlinks collection in Excel's object model holds every link on every sheet. A one-line macro can clear them all. Press Alt+F11 to open the VBA editor, Insert > Module, and paste this: Sub KillLinks() on one line, then ActiveWorkbook.Hyperlinks.Delete, then End Sub. Actually, that only clears workbook-level links. To wipe sheet hyperlinks too, you loop through worksheets:

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

Run it with F5 while inside the macro. Every hyperlink across every sheet vanishes. The formatting stays — same caveat as Clear Hyperlinks — so you may want to follow up with formatting cleanup. Power Query users can achieve similar bulk results by re-importing data and refusing the auto-format step, but VBA is faster for one-off jobs.

Common snags trip people up even with the right method. Tip number one: Remove Hyperlink doesn't appear on the right-click menu? You probably right-clicked a cell that doesn't have a hyperlink. Click a cell that's actually blue, then right-click. The option will be there. If you're trying to remove a HYPERLINK formula, the menu won't help — you need Paste Special > Values instead.

Tip two: blue formatting refuses to leave. After removing the link, the cell still looks like a hyperlink. That's because Clear Hyperlinks (and the macro approach) only kills the link target, not the visual style. Use the right-click Remove Hyperlink option instead — it handles both — or follow up with Clear Formats on the Home > Clear menu.

Tip three: file came from a colleague and protected sheet won't let you remove links? Review > Unprotect Sheet (you'll need the password if there is one), then remove. Re-protect afterward to preserve the original setup. And if you're working with shared workbooks, changes propagate to everyone — coordinate before mass-removing links someone else is relying on.

Now you have a complete toolkit. Right-click handles single cells. Ctrl+A then right-click clears a whole sheet in modern Excel. The Home > Clear menu handles edge cases where you need to keep formatting but lose the link, or vice versa. Paste Special > Values strips HYPERLINK formulas. The AutoCorrect setting prevents future links from auto-generating. And a quick VBA macro wipes everything across an entire workbook in seconds.

Practice each method once and you'll know which one to reach for instinctively. Test your Excel skills with the practice questions below — they cover hyperlinks, shortcuts, and formula syntax you'll use daily. Hyperlinks are a small piece of Excel mastery, but knowing how to control them saves real time every week.

One last thing worth saying out loud: removing hyperlinks doesn't delete cell content. The text stays. The values stay. Only the clickable behavior and the blue styling go away. So you're never risking your data when you use any of these methods. The worst that happens is you remove a link you actually wanted — and that's a quick Ctrl+Z away from being undone.

If you find yourself fighting Excel often, that's a sign the default settings don't fit your workflow. Adjust them. Turn off AutoCorrect for URLs. Pin Paste Special > Values to your Quick Access Toolbar. Add a one-key macro for KillAllLinks. Small tweaks compound. The cleaner your environment, the faster you work, and the less of your day Excel eats with little frustrations.

There's also a difference between removing hyperlinks and removing the underlying data those hyperlinks reference. Some workbooks use HYPERLINK formulas to point to cells on other sheets — a navigation feature, basically. Strip those, and your internal jump links break, even though no data is technically lost. If you're cleaning up a model someone else built, scan for HYPERLINK usage before mass-removing anything. A quick Find & Replace looking for "HYPERLINK(" surfaces every formula link in the workbook.

Imported data is the other common source of stubborn hyperlinks. CSV files don't carry hyperlinks, but Excel often auto-formats URLs and emails on import. HTML pasted from a browser drags every link along for the ride. JSON or XML imports through Power Query can carry link metadata too. The fix in each case is the same — paste as values, or use Power Query's option to import as text and let Excel skip the formatting step entirely. Workflow tip: build a Power Query template for any recurring data source and bake the cleaning into the load step.

For corporate workbooks shared across teams, hyperlinks accumulate over time. Someone pastes a meeting agenda from Outlook. Another colleague drops in a SharePoint URL. The file grows messier with every edit. Consider scheduling a monthly cleanup pass using the workbook-wide VBA macro. Run it before each new reporting cycle, and the file stays presentable. If your IT department blocks macros, the Ctrl+A + right-click + Remove Hyperlinks combination still works sheet by sheet — slower, but no macro permissions needed.

A final pro tip: combine these techniques with Excel's Find and Replace. Press Ctrl+H to open Replace. Click Options. Set "Find what" to the URL pattern (or use wildcards like http* with "Find entire cell contents" unchecked). Leave "Replace with" empty. Replace All wipes the URLs themselves out of the visible text, on top of stripping the hyperlink behavior. Great for cells where the URL was displayed as text rather than friendly link text — you'd rather see the company name than the long messy URL string anyway.

The keyboard-driven workflow many Excel power users prefer goes like this. Ctrl+A to select all. Shift+F10 to open the right-click menu without touching the mouse. R to pick Remove Hyperlinks (the hotkey letter). Enter to confirm. That sequence takes under a second once your hands know it. Then Ctrl+S to save, and you're on to the next task. The faster you can clean up imported data, the more time you spend on actual analysis instead of formatting hygiene.