Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • OneDrive
      • Google Docs
      • Google Sheets
      • Google Drive
    • Email
      • Gmail
      • Outlook
      • Emal Etiquette
    • Office Etiquette
    • Productivity
    Inside The Web
    Home»Office»Excel»How to Quickly Remove Hyperlink on Excel

    How to Quickly Remove Hyperlink on Excel

    Nisha GurungBy Nisha GurungAugust 4, 2023 Excel 4 Mins Read

    Whenever you enter a URL address or person’s email, Excel auto-creates the Hyperlink. You may also get them when you paste the words containing hyperlinks from the internet source. 

    While these hyperlinks are undoubtedly helpful to navigate to the original source, they can also be painfully annoying.

    If the hyperlinks are insignificant, it is best to remove them. You could delete them while keeping or removing the text formats. We have covered five separate cases to unlink the hyperlinks from the texts in this article.

    Case 1: Remove a Single Hyperlink 

    Firstly, if you wish to remove hyperlinks from only single text, you could use the AutoCorrect options menu. Here, all you have to do is hover your cursor near the bottom-left of the text. Then, click on Auto-Correct Options and pick Undo Hyperlink.

    Apart from removing links, you can also prevent Excel from adding automatic hyperlinks to texts. For this, again select AutoCorrect Options > Stop Automatically Creating Hyperlinks. 

    Case 2: Delete Multiple Hyperlinks

    As mentioned, deleting hyperlinks from AutoCorrect Options is only helpful for one or two texts. Using this method would be insanely tedious and monotonous if you had a large number of hyperlink texts.

    For such data, you could easily delete multiple hyperlinks from the Context Menu like how I usually do. Here, you just need to select and right-click on the cells with hyperlinks. Then, pick Remove Hyperlinks. 

    Case 3: Delete Hyperlinks but Keep Text Formats

    With the above-mentioned two methods, you will also lose the text formats along with the hyperlinks. But, in some cases, you may wish to get rid of the hyperlinks from the text but keep the format intact to represent them as a URL or email. For Instance, formats like colors and underlines in texts.

    During such cases, you can delete the hyperlinks from the Excel’s Home ribbon. To do so, select all cells using Ctrl + A shortcut. Then, from Home Tab, click on Clear > Clear Hyperlinks.

    Alternatively, if you want to clear everything, you can always go to Clear > Remove Hyperlinks.

    Case 4: Delete Only Specific Hyperlinks

    Sometimes, there can be instances when you might need to delete only a few hyperlinks. As some of those links could be important for your calculation and some you wish to delete.

    Let’s assume you need to remove hyperlinks only from Project A text while keeping the rest of them. For this, we will use the Find and Replace tool to locate only particular hyperlinks and delete them.

    1. Press Ctrl + A to select all.
    2. Enter Ctrl + F for Find and Replace menu.
    3. On Find what, enter Project A. On Format, expand the drop-down icon and pick Choose Format from Cell.
      On Find What, enter Project A. On Format, expand the drop-down icon and pick Choose Format from Cell
    4. Using the cursor, click on Hyperlink texts.
      Using the cursor, click on Hyperlink texts
    5. Select Find All. 
      Select Find All
    6. Enter Ctrl + A to select all Project A.
      Enter Ctrl + A to select all Project A
    7. Then, Right-click on Project A and pick Remove Hyperlinks. 
      Right-click on Project A and pick Remove Hyperlinks

    Case 5: Remove Hyperlinks From the Whole Workbook 

    Suppose you have hyperlink text data in multiple sheets of your workbook. In such cases, you can use the Visual Basics tool to delete all of the hyperlinks at once. For this, just launch the Visual Basics and run the code mentioned below.

    Note that you must go to Developer Tab to use it. If you cannot see this tab, enable it from Excel’s Options menu first.

    1. Click Developer Tab > Visual Basics.
      Click Developer Tab-Visual Basics
    2. Under Microsoft Visual Objects, click on ThisWorkbook twice. 
      Under Microsoft Visual Objects, click on ThisWorkbook twice
    3. Copy the given code. Then, paste it into the empty field.
      Copy the given code. Then, paste it into the empty field
    Sub RemoveHyperlinksInEntireWorkbook()
    Dim wrkSht As Worksheet
    For Each wrkSht In ActiveWorkbook.Worksheets
     wrkSht.UsedRange.Hyperlinks.Delete
    Next wrkSht
    End Sub
    
    1. To run the code, enter F5 key.
    2. If prompted, select Run button. 
      If prompted, select Run button

    How to Turn Off Automatic Hyperlinks in Excel?

    You might have noticed while entering URL addresses, Excel automatically converts the texts into hyperlinks. If you want to stop this, you can disable Automatic Hyperlink from the AutoCorrect Options. 

    1. On your worksheet, click on File.
    2. Go to the Options menu at the bottom.
      Go to Options menu at the bottom
    3. On Excel Options, click on Proofing. Then, select AutoCorrect Options. 
      On Excel Options, click on Proofing. Then, select AutoCorrect Options
    4. Under Replace as you type, uncheck the box for Internet and network paths with hyperlinks. 
      Under Replace as you type, uncheck the box for Internet and network paths with hyperlinks
    5. Click OK to confirm.
    Excel Basics
    Nisha Gurung

      As a Business Student, Nisha first used Excel to outline data trends for her college projects. Later, she started exploring basic Excel functions when she realized it is a powerful tool for all businesses today. Nisha believes she can relate to many of the issues users face when starting their Excel Journey. She uses this knowledge and experience to curate contents that are fit for all types of Excel users. Apart from writing, she enjoys reading books and traveling.

      Related Posts

      Excel By Nisha Gurung

      How to Compare Two Columns in Excel Using VLOOKUP

      Excel By Nisha Gurung

      How to Share Excel Files with Multiple Users

      Excel By Nisha Gurung

      How to Filter Based on a List in Excel

      Add A Comment
      Table of ContentsToggle Table of ContentToggle
      • Case 1: Remove a Single Hyperlink 
      • Case 2: Delete Multiple Hyperlinks
      • Case 3: Delete Hyperlinks but Keep Text Formats
      • Case 4: Delete Only Specific Hyperlinks
      • Case 5: Remove Hyperlinks From the Whole Workbook 
      • How to Turn Off Automatic Hyperlinks in Excel?
      • Home
      • About Us
      • Privacy Policy
      © 2025 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.