Spreadsheet Links need Deleted

Copper Contributor

Have a spreadsheet with external links to a website.  Don't know how it got there and want it deleted.  It is in multiple continuous cells in a column.  I've tried all the ways to delete it but not successful.  How do I delete it?  Cells in yellow have the link.

3 Replies
There are hundreds of small drawing objects on your sheet which contain those links. You can get rid of them all in one go as follows:
- Hit the F5 function key
- Click the "Special" button
- Select "Objects"
- Wait until Excel becomes responsive again (might take some time!)
- Hit the Del key
- Wait until Excel becomes responsive again (might take quite some time!)

@Jan Karel Pieterse 

 

That worked great!  I had other spreadsheets I checked that had them and it worked on all of them.  Thank you very much!

Please note that the method I have you also deleted objects like charts.