: Iâ€™ve had a hyperlink problem in my Excel files for ages: false hyperlinks had crept in (even in empty cells) and were multiplying regularly whenever I inserted new lines. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell?
Answer: You will need to create a macro to delete the hyperlink addresses in your Excel sheet.
Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press -F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.
Paste the following code into your new module:
â€˜Remove all hyperlinks from the active sheet
Close the Visual Basic editor window by selecting â€œClose and Return to Microsoft Excelâ€ under the File menu.
Now, go to the sheet that contains the hyperlinks that you wish to delete.
Under the Tools menu, select Macro > Macros. Highlight the macro called â€œRemoveHyperlinksâ€ and click on the Run button.
Now your hyperlinks should be deleted.
If you need to remove hyperlinks from other sheets, just repeat the steps above.