How to delete links in Excel

How to delete links in Excel. Hyperlink in Excel gives you quick access to web links, links to sheets in Excel files or links to files on your computer.

Hyperlink in Excel gives you quick access to web links, links to sheets in Excel files or links to files on your computer. In many cases, the link will help you a lot, but sometimes it is troublesome for you. So you want to delete hyperlinks in Excel.

Here's how to delete links in Excel, you can delete each link or delete all links in Excel.

Delete a hyperlink in Excel

On Excel file, select Hyperlink to delete, right-click and choose Remove Hyperlink to delete.

How to delete links in Excel Picture 1How to delete links in Excel Picture 1

Delete all Hyperlinks in Excel

Step 1: Select all sheets by pressing Ctrl + A or clicking the triangle icon at the intersection of column and header rows in Excel.

How to delete links in Excel Picture 2How to delete links in Excel Picture 2

Step 2: Right-click and select Remove Hyperlink to remove all links in the sheet you choose.

How to delete links in Excel Picture 3How to delete links in Excel Picture 3

So you deleted all the Hyperlink in the sheet you selected.

How to delete links in Excel Picture 4How to delete links in Excel Picture 4

Use Find & Replace to find and delete Hyperlink in Excel

If your Excel file has a lot of data, but you only need to delete some Hyperlinks, you can use Excel's Find & Replace feature.

Step 1 : In Excel, select Home -> Find & Select -> Find , or press Ctrl + F to open the search and replace dialog box.

How to delete links in Excel Picture 5How to delete links in Excel Picture 5

Step 2 : In the Find and Replace dialog box, select Options to expand the options.

How to delete links in Excel Picture 6How to delete links in Excel Picture 6

Step 3 : Select the down arrow icon in the Format section and choose Choose Format From Cell.

How to delete links in Excel Picture 7How to delete links in Excel Picture 7

Step 4: At this time, the mouse pointer changes into a white + symbol and a marker, click the link inserted box to get the original landmark.

How to delete links in Excel Picture 8How to delete links in Excel Picture 8

Step 5: On the Find & Replace dialog box, there will appear the word Preview * , click Find All to search for Hyperlinks in Excel file.

How to delete links in Excel Picture 9How to delete links in Excel Picture 9

You will see all Hyperlinks are displayed in the list below Find All.

How to delete links in Excel Picture 10How to delete links in Excel Picture 10

Step 6 : Click on the Hyperlink you want to delete in the list of search results, then the cell containing Hyperlink will be selected, just right-click on the cell and select Remove Hyperlink.

How to delete links in Excel Picture 11How to delete links in Excel Picture 11

Use Visual Basic to delete Hyperlink in Excel

Step 1 : On the Excel file, select the Developer tab -> Visual Basic ( press Alt + F11 ).

How to delete links in Excel Picture 12How to delete links in Excel Picture 12

Step 2 : On the VBA working window, in the Project –VBAProject section, right-click on the sheet to delete the link and select Insert -> Module.

How to delete links in Excel Picture 13How to delete links in Excel Picture 13

Step 3 : On the code interface you enter the following code lines :

Sub RemoveHyperlink ()

ActiveSheet.Hyperlinks.Delete

End Sub

Then you select Run -> Run Sub / UserForm (or F5 key ) to run the program to delete links in Excel.

How to delete links in Excel Picture 14How to delete links in Excel Picture 14

Step 4 : Turn off Visual Basic, you will see the results of all links are deleted.

How to delete links in Excel Picture 15How to delete links in Excel Picture 15

Instructions on how to turn off the automatic conversion into links in Excel (Autocorrect)

When you paste a link into a cell in Excel when you remove the mouse from the cell, the link will automatically turn into a link.

How to delete links in Excel Picture 16How to delete links in Excel Picture 16

If you want to remove this feature, do the following:

Step 1: On the Excel spreadsheet, select File -> Options.

How to delete links in Excel Picture 17How to delete links in Excel Picture 17

Step 2 : In Excel Options window, select Proofing , then select AutoCorrect Options.

How to delete links in Excel Picture 18How to delete links in Excel Picture 18

Step 3 : An AutoCorrect dialog box appears , select the AutoFormat As You Type tab and uncheck the box before Internet and network paths with hyperlinks.

How to delete links in Excel Picture 19How to delete links in Excel Picture 19

Click OK and close Excel Options . Now you can paste a link into Excel and see the result.

How to delete links in Excel Picture 20How to delete links in Excel Picture 20

The above are ways to delete links in Excel and how to turn off the automatic conversion into links in Excel. Hopefully with the information that the article will share you will have more useful knowledge. Good luck!

5 ★ | 1 Vote