Spreadsheet Links need Deleted

%3CLINGO-SUB%20id%3D%22lingo-sub-1306028%22%20slang%3D%22en-US%22%3ESpreadsheet%20Links%20need%20Deleted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306028%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20a%20spreadsheet%20with%20external%20links%20to%20a%20website.%26nbsp%3B%20Don't%20know%20how%20it%20got%20there%20and%20want%20it%20deleted.%26nbsp%3B%20It%20is%20in%20multiple%20continuous%20cells%20in%20a%20column.%26nbsp%3B%20I've%20tried%20all%20the%20ways%20to%20delete%20it%20but%20not%20successful.%26nbsp%3B%20How%20do%20I%20delete%20it%3F%26nbsp%3B%20Cells%20in%20yellow%20have%20the%20link.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1306028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1306191%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20Links%20need%20Deleted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306191%22%20slang%3D%22en-US%22%3EThere%20are%20hundreds%20of%20small%20drawing%20objects%20on%20your%20sheet%20which%20contain%20those%20links.%20You%20can%20get%20rid%20of%20them%20all%20in%20one%20go%20as%20follows%3A%3CBR%20%2F%3E-%20Hit%20the%20F5%20function%20key%3CBR%20%2F%3E-%20Click%20the%20%22Special%22%20button%3CBR%20%2F%3E-%20Select%20%22Objects%22%3CBR%20%2F%3E-%20Wait%20until%20Excel%20becomes%20responsive%20again%20(might%20take%20some%20time!)%3CBR%20%2F%3E-%20Hit%20the%20Del%20key%3CBR%20%2F%3E-%20Wait%20until%20Excel%20becomes%20responsive%20again%20(might%20take%20quite%20some%20time!)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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!)
Highlighted

@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!

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