How do I delete links to websites in Excel spreadsheet?

A

Andy

I copied a table of numbers from a website to work with it in Excel. The
numbers arrived nicely, but I got a few photos and links to other sites.
Most I could delete, by deleting a range of cells. One is left that I can't
delete. I'd like to. How? Can't select it (it goes to that website), I
can't delete those rows (doesn't work).

How?
 
D

Dave Peterson

Maybe the links are associated with the pictures/shapes that were pasted.

If you want to remove all the shapes (and their associated hyperlinks), you
could try:

Edit|goto|special|Objects
then hit the delete key

If you want to get rid of all the hyperlinks that were pasted into the cells
(essentially using insert|hyperlink), you can:

select your range to clean
alt-f11 (to see the VBE)
ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete

And then close this window and go back to excel.

You could even select all the cells on the sheet if you wanted.
 
Top