keepcalculator

06 Numbers and Powers

Cancel These Hyperlinks? How to Remove Unwanted Links

Card No. 06·49745 · Updated · Standard formula, shown below

Average pace 5.00 min/km
Average speed
12.00 km/h
Result
Finish time
50 min
You entered
Distance
10 km
You entered
You enter
Finish time, Distance
You get
Average pace, Average speed
Rounding
2 dp

Yes, you can cancel (remove) unwanted hyperlinks from a webpage, document, or spreadsheet. The exact method depends on where the link lives — in a Word document, an Excel cell, an HTML file, or a content management system — and this article walks through each common scenario with step-by-step instructions.

What “Canceling” a Hyperlink Actually Means

When people say “cancel these hyperlinks,” they usually mean one of three things: remove the clickable link and keep the text, delete the link and the text entirely, or stop automatic link creation in the future. Each action has a different effect, and choosing the wrong one can leave you with broken formatting or lost content.

Removing the hyperlink (but keeping the text) is the most common request. For example, you might have a document where every URL is automatically turned into a blue, underlined link, but you want the plain text “www.example.com” without the clickable behavior. That is a simple formatting change, not a deletion of content.

Deleting the link and the text is more drastic — you remove the visible words and the underlying URL. This is useful when a link is outdated, irrelevant, or potentially harmful. In a spreadsheet, you might have hundreds of cells with hyperlinks that need to be cleared without touching the display text.

Stopping automatic hyperlinks is a settings change. Word, Excel, Google Docs, and most email clients will auto-convert typed URLs into clickable links. If you are tired of that behavior, you can turn it off globally or for a specific document.

Removing Hyperlinks in Microsoft Word

Word offers several ways to remove hyperlinks, depending on how many you need to fix.

  • Single link: Right-click the link and choose Remove Hyperlink. The text remains but the link formatting disappears.
  • Multiple links: Select all the text (Ctrl+A or Cmd+A), then press Ctrl+Shift+F9 (Windows) or Cmd+Shift+F9 (Mac). This removes all hyperlinks in the selection at once.
  • Paste without links: When pasting from a browser or another document, use Paste Special and choose Unformatted Text to avoid bringing links in.

If you want to stop Word from creating links automatically, go to File > Options > Proofing > AutoCorrect Options (Windows) or Word > Preferences > AutoCorrect (Mac). Under the AutoFormat As You Type tab, uncheck Internet and network paths with hyperlinks.

Clearing Hyperlinks in Excel

Excel is trickier because hyperlinks live in cells, and the display text is often different from the URL. Here are the standard methods:

  • Right-click a cell: Choose Remove Hyperlink. This clears the link but leaves the cell’s text.
  • Remove multiple links: Select the range, right-click, and choose Remove Hyperlinks (Excel 2010 and later). In older versions, you may need to use a small macro.
  • Clear all links in a sheet: Press Ctrl+A to select the whole sheet, then right-click any cell and choose Remove Hyperlinks. This works even if some cells are empty.
  • Remove links but keep text via formula: If you have a column of URLs, you can use a formula like =HYPERLINK("",A1) but that still creates a link. Better: copy the column, paste it as values (Paste Special > Values), which strips the hyperlink formatting.

To prevent Excel from auto-creating links, go to File > Options &em; Proofing > AutoCorrect Options, and on the AutoFormat As You Type tab, uncheck Internet and network paths with hyperlinks.

Removing Links in Google Docs and Sheets

Google’s apps work similarly but have their own shortcuts.

In Google Docs, right-click the link and choose Remove link. To remove all links in a document, select all (Ctrl+A or Cmd+A), then press Ctrl+Shift+K (Windows/ChromeOS) or Cmd+Shift+K (Mac). This is a handy shortcut that many people don’t know.

In Google Sheets, right-click a cell and choose Remove link. To remove multiple links, select the cells, right-click, and choose Remove link. There is no one-click “remove all” in Sheets, but you can use the menu Insert > Link and delete the URL, or use a script if you have hundreds of cells.

To stop Google Docs from auto-linking, go to Tools > Preferences and uncheck Automatically detect links. This setting applies to new documents you create, not existing ones.

Removing Hyperlinks in HTML (Web Pages)

If you maintain a website and want to cancel hyperlinks in the code, you have a few options depending on your setup.

  • Edit the HTML directly: Find the <a href="..."> tag and remove it. For example, <a href="https://example.com">Click here</a> becomes just Click here.
  • Use a content management system (CMS): In WordPress, click the link in the editor, then click the “unlink” icon (a broken chain) in the toolbar. This removes the link but keeps the text.
  • Batch removal with find-and-replace: In a code editor like VS Code or Notepad++, you can use a regular expression to strip all <a ...> opening and closing tags. For example, replace <a[^>]*>(.*?)</a> with $1 to keep the inner text.

Be careful with regex on HTML — if your links contain nested tags or special characters, the pattern may fail. For simple sites, manual removal is safer.

Common Problems and Misconceptions

One common mistake is thinking that removing the visible text also removes the link. In Word and Excel, the link is a property of the text or cell, so you must explicitly remove the hyperlink formatting.

Another issue: when you copy text from a webpage and paste it into Word, the hyperlinks come along. Many users try to remove them one by one, not realizing the Ctrl+Shift+F9 shortcut removes all at once.

A frequent misconception is that “unlinking” a link in a CMS deletes the content. It does not — it only removes the clickable behavior. The text stays, and the URL is gone.

If you have a spreadsheet with hundreds of hyperlinks, manually right-clicking each cell is tedious. The fastest way is to select the entire column, use Remove Hyperlinks, or copy the column and paste it as values.

Finally, some users worry that removing a hyperlink will break a formula or a reference. In Excel, removing a hyperlink does not affect the cell’s value or formula — it only removes the link formatting. In Word, the text remains unchanged.

How to Choose the Right Method

Your choice depends on the context and the number of links.

  • One or two links: Right-click and remove individually.
  • Many links in a document: Use the keyboard shortcuts (Ctrl+Shift+F9 in Word, Ctrl+Shift+K in Docs).
  • Many links in a spreadsheet: Use the right-click Remove Hyperlinks or paste-as-values trick.
  • Links in a website’s HTML: Edit the source or use your CMS’s unlink tool.
  • Preventing future links: Turn off auto-formatting in your app’s settings.

If you are working with a file that others will edit, consider whether you want to remove the link entirely or just make it non-clickable. In collaborative documents, removing the link may confuse others who expected it to be clickable.

Safety and Accuracy Considerations

Before removing hyperlinks in bulk, make a backup of your file. In Word and Excel, use Save As to create a copy. In a CMS, use the revision history to ensure you can revert if something goes wrong.

When removing links from HTML, be careful not to delete the text between the opening and closing tags. A regex error could wipe out entire paragraphs. Test on a small section first.

If you are removing links because they are broken or lead to malicious sites, verify that the text itself is still appropriate. Sometimes the link text is misleading, and you may want to remove the text as well.

For websites, removing a link does not remove the page it points to — it only removes the clickable reference. If you want to delete the target page, you must do that separately.

Frequently Asked Questions

How do I remove all hyperlinks in a Word document at once?

Select all text (Ctrl+A or Cmd+A), then press Ctrl+Shift+F9 (Windows) or Cmd+Shift+F9 (Mac). This removes every hyperlink in the selection while keeping the text. It works in Word 2007 and later.

Why does Excel keep turning my URLs into links?

Excel auto-detects URLs and formats them as hyperlinks by default. To stop this, go to File > Options > Proofing > AutoCorrect Options, and on the AutoFormat As You Type tab, uncheck “Internet and network paths with hyperlinks.” This affects new entries, not existing ones.

Does removing a hyperlink delete the text?

No. Removing a hyperlink only removes the clickable link and the URL. The visible text stays exactly as it was. If you want to delete the text too, you must select it and press Delete.

Can I remove hyperlinks from a PDF?

Yes, but it requires a PDF editor. In Adobe Acrobat, use the Link tool to select and delete links. Free tools like PDF-XChange Editor also allow link removal. If you don’t have an editor, you can print the PDF to a new PDF, which usually strips hyperlinks.

How do I remove a hyperlink in Google Sheets without losing the cell value?

Right-click the cell and choose “Remove link.” The text stays, and the link is cleared. For multiple cells, select them, right-click, and choose “Remove link” — it applies to all selected cells at once.

What is the difference between unlinking and deleting a link in WordPress?

Unlinking removes the hyperlink but keeps the anchor text. Deleting the link (by selecting the text and pressing Delete) removes both the text and the link. In the block editor, the unlink icon is in the toolbar above the selected text.

Related

Formula used
in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0 | 100000
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →