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
- Click Data Validation.
- In the Allow drop-down list, select Text.
- In the Text box, type 0; click Allow.
- Click Settings in the Data Validation box.
- On the Settings tab, click Add.
- Click Hyperlink.
- In the Hyperlink box, type 0.
- Click Ok
Select Data Validation from the drop-down menu
- Select List from the Data Validation Type drop-down menu
- Click on the Edit button to open the window below
- Enter list in the Source box
- Select ‘By Dropdown’ in the drop-down menu
- Enter 0 in the Source box
- Select ‘By Checkbox’ in the drop-down menu
- Enter 0 in the Source box
- Select the cell range in the sheet
- Click on the Data Validation tab
- Click Ok
Change your validation criteria
- From the Tools menu, select Data Validation, and then click the Settings button.
- In the Settings window, click on the Error Alert tab.
- Select the Hyperlink error alert option.
- Next, check the option to Specify which cells trigger the error alert.
- Select the cells that contain hyperlinks you want to delete.
- Click the OK button to store the settings.
