How to Remove Hyperlink in Excel Sheet

Many users reported that Excel in Excel 2015, 2016, and 2019 has an annoying hyperlink formatting issue.
> I have hyperlinks in some of my Excel spreadsheets. > > I copied and pasted a hyperlink into a spreadsheet. > > Now my hyperlink looks like this: http//www.google.com/ > > I would like to remove the http//www.google.com/ part. > > How do I fix this?
This issue can really mess up your Excel spreadsheets.
### How to Remove Hyperlink in Excel In this article, we will explore how you can remove hyperlinks in Excel.

  • Excel is the go-to application for lots of users, but hyperlinks are one of its features.
  • A hyperlink is any text, image, or video that, when clicked, takes you to another website.
  • Hyperlinks are widely used in documents.
  • However, they can sometimes cause issues, and here’s how you can fix them.

Select Data Validation

  1. Click Data Validation.
    Click Data Validation.
  2. In the Allow drop-down list, select Text.
  3. In the Text box, type 0; click Allow.
  4. Click Settings in the Data Validation box.
  5. On the Settings tab, click Add.
  6. Click Hyperlink.
  7. In the Hyperlink box, type 0.
  8. Click Ok

Select Data Validation from the drop-down menu

  1. Select List from the Data Validation Type drop-down menu
  2. Click on the Edit button to open the window below
  3. Enter list in the Source box
    Enter list in the Source box
  4. Select ‘By Dropdown’ in the drop-down menu
  5. Enter 0 in the Source box
  6. Select ‘By Checkbox’ in the drop-down menu
    Select ‘By Checkbox’ in the drop-down menu
  7. Enter 0 in the Source box
  8. Select the cell range in the sheet
  9. Click on the Data Validation tab
  10. Click Ok

Change your validation criteria

  1. From the Tools menu, select Data Validation, and then click the Settings button.
  2. In the Settings window, click on the Error Alert tab.
    In the Settings window, click on the Error Alert tab.
  3. Select the Hyperlink error alert option.
  4. Next, check the option to Specify which cells trigger the error alert.
  5. Select the cells that contain hyperlinks you want to delete.
  6. Click the OK button to store the settings.
    Click the OK button to store the settings.
Scroll to Top