How to remove all hyperlinks in an excel sheet

Excel automatically converts URLs entered into spreadsheets into hyperlinks. You can open websites in a browser by clicking their links in cells. However, it’s not always ideal to have links in spreadsheets because selecting their cells can open websites even when you don’t need them.

If you want to have a list of URLs in plain text, here is how you can remove all hyperlinks from Excel worksheets.

Using context menu to remove hyperlink option

If you are using a newer version of Excel, you can remove all hyperlinks from a sheet with a context menu option.

  1. Open a blank Excel spreadsheet and enter in cell B2. excel spreadsheet
  2. Then you can right click on this cell and select the Remove hyperlink option in the context menu. This will convert the hyperlink to a plain text URL.
  1. To remove multiple hyperlinks from an Excel worksheet, hold down CTRL key and select multiple cells with URLs at once.
  2. Right click on one of the selected cells and select the Remove hyperlink option.
  3. To remove all hyperlinks from a sheet, press the key CTRL+A keyboard shortcut to select all cells in the worksheet.
  4. Right click on any cell and select Remove hyperlink to convert all links to plain text.

Remove links from sheets in Excel 2007

Not all versions of Excel include the “Remove Hyperlink” context menu option. As such, you cannot select this option in Excel 2007. However, 2007 users can still remove links from worksheets using the “Paste Special” trick.

  1. For example, enter in cell B3then enter 1 in cell C3 from the same spreadsheet. Select cell C3 and press the CTRL+C keyboard shortcut to copy it to the clipboard.
  2. Then right click on the cell containing the hyperlink, else B3, and select Special bonding > Special bonding… in the context menu to open the Special bonding window below.
  3. In the Operation section of the window, select Multiply, then press the OKAY button to remove the hyperlink.

Paste URLs into spreadsheets as plain text

If you need to paste many URLs into a spreadsheet, you can remove their hyperlink formatting by selecting the icon Keep text only option.

  1. For example, copy the following URL:
  2. In Excel to cell D3 or your favorite cell, right click on it and select Paste text only (T)which is the clipboard icon with the big letter A.
  3. The pasted cell now displays the URL without a hyperlink.

Configure a macro that removes hyperlinks

Macros are a recorded sequence of selected options. This Tech junkie article (and its video) tells you how to record macros in Windows. The full Excel application includes a macro recording tool for recording macros, but you can also set up macros manually by entering Visual Basic for Applications (VBA) code. So why not implement a macro that removes all hyperlinks from an Excel sheet?

  1. press the Other + F11 keyboard shortcut to open the VB editor in Excel.
  2. Double-click This workbook in the VBAProject panel. Excel-VBA application
  3. Copy and paste the following code into the VB code window:
    Sub RemoveAllHyperlinks()
    'Code by Sumit Bansal @
    End Sub
  4. Option 1: You can run the subroutine in VBA if you want at this point by selecting To run at the top, but you won’t see the changes on the worksheet unless you move the VBA window. The removal of hyperlinks is now complete.
  5. Option 2: Close the VBA window and return to the active Excel worksheet. press the Other + F8 shortcut key combination to open a Macro window, select ThisWorkbook.RemoveAllHyperlinks in the list, then press the To run button.

The macro above removes all hyperlinks from the “active” worksheet and not from the workbook. However, you can modify the code to work on each sheet in the workbook and do many other things.

Disable automatic hyperlinks

Excel automatically converts URLs to links, but you can configure the software to keep all URLs entered in plain text. Here’s how.

  1. Select the Case tab and click Choice to open the window just below.
  2. Select Proofing to the left and press the Autocorrect options button.
  3. The Autocorrect window appears. Select the Auto-formatting as you type tab on this window.
  4. Deselect the Internet and network paths with hyperlinks option.
  5. press the OKAY button and close the Excel Options window.

Now, URLs entered into spreadsheet cells will remain text only. Disabling automatic hyperlinks can save you a lot of unnecessary work.

In conclusion, you have several ways to remove some or all of the hyperlinks in an Excel worksheet. You can delete them individually, in groups, or all at once. Depending on your scenario and needs, you can also configure Excel to never convert URLs to hyperlinks, which is handy if you have a lot of URL entries to type.

Whether it’s selecting a group of cells or all of them and using right-click actions to add VBA macros as subs and disable automatic URL entries, you have plenty of options to find one that meets your needs.

Comments are closed.