How to Remove Hyperlink in Excel

Today I am writing an article about Remove Hyperlink in Excel. This article is very easy to understand for readers with basic computer skills. When you want to remove the hyperlink that appeared by mistake, then follow below steps :-     1. Open your excel file     2. Select the cell where the hyperlink appears     3. click on “Data” menu, and select “Text to Columns” option; now select “Delimited”.     4. Now click on “Next” button …

Remove hyperlink in excel, remove hyperlink excel file how do I remove the hyperlinks from an Excel sheet? There are several ways that you can remove hyperlinks in Microsoft Excel spreadsheets. This article will describe three of the most historically common methods.

Issues when Working with Hyperlinks in Excel

When you have some hyperlinks in your worksheet, you may feel some level of frustration dealing with it (at least I do).

Below are some of the issues you can face when you have hyperlinks in your workbook:

  1. It’s difficult to select, copy, and delete cells containing hyperlinks. This is because when you click on the cell, Excel opens up your default browser and directly takes you to that link. This can feel more like unsolicited assistance and waste a lot of time. There is one way around this though. You can click on the cell and hold your mouse button till the pointer turns into a plus symbol. But this slows you down and is not helpful at all when you’re trying to get important work done.
  2. Say you find an error in the URL of a website in one of the cells. To change or correct it, you need to double click the contents of the cell. This becomes really difficult when Excel marks the contents as a hyperlink.
  3. If Excel sees any content that looks like a URL, email address, or file location, it automatically converts it into a hyperlink, even if that link doesn’t actually exist. This could mislead someone else going through your spreadsheet.

For all the above cases, the best solution would be to either remove the hyperlinks, so the cell contents behave and look like regular text, or to disable automatic hyperlink conversions altogether.

In this tutorial, we are going to look at how you can remove hyperlinks from a single cell, multiple cells, and a whole worksheet.

We will also show you how to disable Excel from automatically converting anything to a hyperlink.

Remove Hyperlink from a Single Cell

To remove a hyperlink from a single cell, right-click on the cell directly (don’t left-click to select it first).

Next, select “Remove Hyperlink” from the popup menu.

That’s all, your cell gets converted to a cell with regular text.

Bear in mind, though, that this removes any other formatting that had been applied to the cell too.

If you want to remove hyperlinks from a range of cells, here’s a quick, two-click method:

  1. Select the range of cells containing the hyperlinks you want to remove.
  2. Right-click on the selection and select “Remove Hyperlinks” from the dropdown menu.
Right-click and then Remove Hyperlinks

Again, this technique removes hyperlinks along with any formatting from the selected cells.

ALSO READ:   How to Convert a Picture to Pdf

Remove all Hyperlinks from the Entire Worksheet

If you have hyperlinks in different areas of your spreadsheet, it’s quicker to just remove all the hyperlinks in the sheet at once.

Here’s how you can do this in just two clicks:

  1. Select all the cells in your worksheet, either by clicking on the triangle on the top right corner of your sheet or pressing CTRL+A from the keyboard.
  2. Right-click anywhere on your worksheet, and select “Remove Hyperlinks” from the dropdown menu.
Remove Hyperlinks from the entire workshet

This also removes all hyperlinks in the worksheet as well as any formatting done on the cells with links. Formatting of other cells, however, remains unchanged.

Clear Hyperlinks Without Changing Format Settings

If you would rather retain the formatting when removing hyperlinks, there’s another technique:

  1. Select the cells you want to work on. You can select a single cell, group of cells, or the entire worksheet.
  2. Under the Home tab, you will find the Clear option in the ‘Editing’ group. Click on it and select “Clear Hyperlinks” from the dropdown list.Click on Clear Hyperlinks
  3. When you do this, you will see a pink eraser icon. If you had selected a group of cells, the eraser should appear at the bottom right corner of your selection. If you had selected the entire worksheet, it should appear at the top right corner of your sheet.Click on the Pink Eraser and the Clear Hyperlinks
  4. Click on this eraser icon. You will see a drop-down list with two options:
    • Clear Hyperlinks only
    • Clear Hyperlinks and Formats
  5. If you click on “Clear Hyperlinks only”, your hyperlinks will be removed, but formatting will remain intact. However, if you click on “Clear Hyperlinks and Formats”, it will remove both the hyperlinks as well as any formatting applied to those cells.

Note that hyperlinks automatically get a format where the text is blue with an underline. When you use the above method, it will remove the hyperlink, but it will not remove any formatting, including the blue text and underline.

So it may look as if there are hyperlinks in the cell, but it’s just the formatting.

Related: How to Extract URL from Hyperlinks in Excel (Using VBA Formula)

Remove hyperlinks with a VBA Macro

If you need to work with hyperlinks quite often and are comfortable using VB macros, you can create a simple macro script to do this..

To remove hyperlinks from a selection, here’s the code that you can use:

Sub RemoveSelectedHyperlinks()
End Sub

Follow these steps:

  1. Select the range of cells for which you want to remove hyperlinks.
  2. From the Developer Menu Ribbon, select Visual Basic.
  3. Once your VBA window opens, Click Insert->Module. Now you can start coding. Type or copy-paste the above lines of code into the module window:
  4. Run the macro by navigating to Developer->Macros->RemoveSelectedHyperlinks->Run or just clicking the button.
  5. When you go back to your spreadsheet, you will find the selected all hyperlinks removed from the selection.
ALSO READ:   How to Create Dashboard in Excel

To remove hyperlinks from the entire sheet, you can use the following code:

Sub RemoveAllHyperlinks()
End Sub

Since you want to work on the entire sheet you don’t need to make any selections. Just make sure the sheet you want to apply the code on is the active sheet.

Follow these steps:

  1. From the Developer Menu Ribbon, select Visual Basic.
  2. Once your VBA window opens, Click Insert->Module. Now you can start coding. Type or copy-paste the above lines of code into the module window:
  3. Run the macro by navigating to Developer->Macros-> RemoveAllHyperlinks ->Run or just clicking the button.
  4. When you go back to your spreadsheet, you will find all hyperlinks removed from the entire sheet.

Once your VBScript is ready and working, you can link this to a macro button and add it to your quick access toolbar.

Here’s how to do this:

  1. Click on the Customize Quick Access Toolbar dropdown. You will find it at the top of your Excel window.Customize Quick Access toolbar drop down
  2. Click on “More Commands
  3. This will open the Excel Options dialog box.
  4. Click on the drop-down list below “Choose Commands From” and select the “Macros” option.
  5. Select the name of the macro you created. In our case, it’s either ‘ThisWorkbook.RemoveSelectedHyperlinks’ or ‘ThisWorkbook.RemoveAllHyperlinks’.
  6. Click on the Add>> button.
  7. Click OK.
Add Macro to Quick Access Toolbar

This will create a Quick Access macro button for you and place it on your Quick Access Toolbar, so whenever you click it, your macro can run and remove all your required hyperlinks.

Macro Added in the toolbar

In this way, you can get your hyperlinks removed even faster, with just one click.

Note: Running this macro will remove all your hyperlinks permanently, so you will not be able to reverse the changes even by using the Undo command.

Turn off Automatic Hyperlink Conversion for all Worksheets

Finally, if you don’t want to deal with automatic conversion to hyperlink altogether, you can turn off this feature. Here’s what you need to do:

  1. Click on File->Options.
  2. This will open the Excel Options dialog box. Select “Proofing” from the left sidebar.
  3. Click the “AutoCorrect Options” button.
  4. This will open the “AutoCorrect” dialog box. Click on the “AutoFormat As You Type” tab.
  5. Uncheck the “Internet and Network Paths with Hyperlinks” checkbox.
  6. Click OK to close the AutoCorrect dialog box.
  7. Click OK to close the Excel Options dialog box.
Turning Off Automatic Hyperlink Conversion

This will take you back to your Excel sheet. Now if you type any URL, email address, or file location, Excel will retain it in regular text format, instead of converting it.

Note: At any point, if you want to convert the contents of a cell to a hyperlink, you can simply right-click the cell, select “Hyperlink” from the popup menu and then enter the address you want to link to.

ALSO READ:   Youtube Tools Extension

From Microsoft

Remove or turn off hyperlinks

Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 Word 2021 More…

You can remove a hyperlink from a single address, remove many links at once, turn automatic hyperlinks off, and turn off the requirement to press Ctrl to follow a hyperlink.

Remove a hyperlink

To remove a hyperlink but keep the text, right-click the hyperlink and click Remove Hyperlink.

Right click menu, Remove Hyperlink

To remove the hyperlink completely, select it and then press Delete.

In Excel:

If the hyperlink was created using the HYPERLINK function, you can remove the hyperlink by using the following steps:

  1. Select the cell containing the hyperlink.
  2. Press CTRL+C to copy the hyperlink.
  3. Right Click and paste using the Values paste option.

Remove all hyperlinks at the same time

If you’re using Word or Outlook, or Excel 2010 or later, you can remove all hyperlinks in a file by using a keyboard shortcut.

In Word and Outlook:

  1. Press Ctrl+A to select all text.
  2. Press Ctrl+Shift+F9.

In Excel 2010 and later:

  • Select all cells that contain hyperlinks, or press Ctrl+A to select all cells.
  • Right-click, and then click Remove Hyperlinks.

Turn off automatic hyperlinks

When it’s not convenient to have Office automatically create hyperlinks in your document as you type, you can turn them off.

  1. In Office 2010 and later:Click File > Options > Proofing.(In Outlook, click File > Options > Mail > Editor Options > Proofing.)In Office 2007:Click the Microsoft Office button, and then click Options > Proofing.(In Outlook, open a new message, click the Microsoft Office button, and then click Editor Options > Proofing.)
  2. Click AutoCorrect Options, and then click the AutoFormat As You Type tab.
  3. Clear the Internet and network paths with hyperlinks check box.

Turn off Ctrl+Click to follow a link

By default, Word and Outlook require you to press Ctrl when you click to follow a hyperlink. This extra step keeps you from accidentally going to a linked destination while you’re editing a document.

If you want to click links without having to press Ctrl, try this:

  1. In Word 2010 and later, click File > Options > Advanced.In Word 2007, click the Microsoft Office button > Word Options > Advanced.In Outlook 2010 and later, click File > Options > Mail > Editor Options > Advanced.In Outlook 2007, open a new message and click the Microsoft Office button > Editor Options > Advanced.
  2. Under Editing Options, clear the Use CTRL + Click to follow hyperlink check box.


Every day we get a lot of emails from users saying that they tried our solution and either didn’t work or can’t open the Excel file after running the macro. Usually, the cause is hyperlinks in headers or footers that do nothing but waste space and serve no purpose. I decided to create this step-by-step tutorial, which demonstrates how you can remove hyperlink in Excel quickly with minimal errors.

Leave a Comment