When pasting tabular data, financial exports, or scraped web content into Microsoft Excel, URLs and email addresses frequently convert into live, underlined blue hyperlinks. While useful for navigation, having hundreds of active links scattered across your spreadsheet can be a major nuisance: clicking a cell to edit or copy its value often accidentally launches your web browser instead of selecting the cell.
Fortunately, Microsoft Excel provides several built-in methods to strip hyperlinks from an entire worksheet or selected ranges in seconds—without deleting the underlying text or disrupting existing formatting. Here is how to remove hyperlinks across all cells in Excel using native context tools, the Clear menu, and automated macros.
In This Guide
- Method 1: Using the Right-Click Context Menu
- Method 2: Using the Clear Hyperlinks Tool on the Ribbon
- Method 3: Removing Hyperlinks Across All Worksheets Using VBA
- Removing Hyperlinks While Retaining Original Text Formatting
- Bonus: Preventing Excel from Creating Hyperlinks Automatically
- Frequently Asked Questions and Common Errors
Method 1: Using the Right-Click Context Menu
The quickest way to remove hyperlinks from a specific column, table, or the entire sheet is through Excel’s native right-click shortcut menu:
- Open your spreadsheet in Microsoft Excel.
- Select the cells containing the unwanted links:
- To select a specific range, click and drag across the cells.
- To select an entire column, click its column letter at the top.
- To select the whole worksheet, press Ctrl + A (or click the triangle selector icon at the top-left corner of the grid between column A and row 1).
- Right-click anywhere within the selected area.
- Scroll to the bottom of the context menu and click Remove Hyperlinks.
Excel will instantly convert every clickable link back into plain, static text. The blue colour and underline will be cleared automatically, returning the cells to standard text styling.
Method 2: Using the Clear Hyperlinks Tool on the Ribbon
If you prefer using the Excel ribbon, the Clear command within the Editing group provides two distinct hyperlink management options: removing links completely or merely clearing their clickable behaviour.
- Highlight the target cells or press Ctrl + A to select the entire sheet.
- Navigate to the Home tab on the Excel ribbon.
- In the Editing section on the right-hand side, click the Clear button (represented by an eraser icon).
- Choose one of the following two options from the dropdown:
- Remove Hyperlinks: Completely strips the hyperlink URLs and removes the blue underlined formatting, restoring default text appearance.
- Clear Hyperlinks: Strips the underlying clickable link but preserves the visual appearance (the blue font and underline remain visible until manually altered).
Method 3: Removing Hyperlinks Across All Worksheets Using VBA
If your workbook contains dozens of tabs and you need to purge hyperlinks from every single sheet simultaneously, doing it tab by tab is tedious. A one-line VBA command can clean the entire workbook in an instant.
- Press Alt + F11 (or Option + F11 on Mac) to open the Visual Basic for Applications (VBA) editor.
- Press Ctrl + G to open the Immediate window at the bottom of the editor.
- Paste the following command into the Immediate window and press Enter:
For Each ws In Worksheets: ws.Hyperlinks.Delete: Next ws - Close the VBA editor window and return to your Excel workbook.
Every active hyperlink across every worksheet in your workbook will be deleted immediately, leaving all cell values intact.
Removing Hyperlinks While Retaining Original Text Formatting
When you use standard hyperlink removal, Excel strips the blue underline and reverts the font colour to black. If your cells were styled with specific brand colours, fonts, or cell borders prior to hyperlink conversion, you might want to remove the link without resetting custom styling:
- Select the target range.
- Go to Home > Clear > Clear Hyperlinks.
- Notice that the text is no longer clickable, but the font formatting remains intact.
- Select the cells and change the font colour (under Home > Font Colour) and toggle off the Underline button (Ctrl + U) to match your custom aesthetic.
Bonus: Preventing Excel from Creating Hyperlinks Automatically
If you regularly paste raw web links or email addresses and do not want Excel to convert them into clickable hyperlinks automatically, you can disable this behaviour permanently in AutoCorrect options:
- Click File in the top-left corner and select Options.
- In the Excel Options dialogue box, click Proofing on the left.
- Click the AutoCorrect Options… button.
- Select the AutoFormat As You Type tab.
- Untick the box next to Internet and network paths with hyperlinks.
- Click OK twice to confirm and save your settings.
From this point onward, entering or pasting URLs into any Excel spreadsheet will leave them as plain text without generating live links.
Frequently Asked Questions and Common Errors
- Why is “Remove Hyperlinks” greyed out? The option will be disabled if your worksheet is currently protected. Navigate to the Review tab, click Unprotect Sheet, enter your password if prompted, and try the command again.
- Does this affect HYPERLINK formula functions? No. If a cell contains a formula such as
=HYPERLINK("https://digitash.com", "Site"), the Clear/Remove Hyperlinks command will not remove it because it is an active calculation. To convert formula-based hyperlinks to static text, copy the cells (Ctrl + C), right-click, and choose Paste Special > Values (V). - Can I undo hyperlink removal? Yes, pressing Ctrl + Z immediately after removing hyperlinks will restore them. However, VBA-based deletions cannot be reversed with Undo, so save a backup of your workbook before running macros.