Does anybody now "if" and "how" I can remove multiple hyperlinks from an excel sheet? One cell in every 4th row out of 2000 rows has a hyperlink and naturally this is quite time consuming to remove each one individually as I have 8 worksheets the same in one workbook. How can I select all and remove in one action?

press and hold alt while pressing f11 this will open visual basic editor.
then select module under the insert menu then paste the folowing into the new module.



Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub

then under file menu select Close and Return to Microsoft Excel

Under the Tools menu select Macro > Macros highlight the macro called Remove Hyperlinks and click on the Run button

that should solve the problem if not please get back in touch