Remove hyperlinks from Excel
To quickly remove all links (links) from the Excel sheet, open the ALT + F11 Macros and run the code:
Sub UnLinkAll()
'Unlink all hyperlinks from sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Everything.
PS And in Word it is even easier: we mark the necessary piece of text (or the entire text on CTRL + A) and press CTRL + Shift + F9.
')
Source: https://habr.com/ru/post/92958/
All Articles