📜 ⬆️ ⬇️

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