How do I delete links to websites in Excel spreadsheet?
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? |
How do I delete links to websites in Excel spreadsheet?
have you tried to nright click and remove the hyperlink -- sjgidman ------------------------------------------------------------------------ sjgidman's Profile: http://www.excelforum.com/member.php...o&userid=36174 View this thread: http://www.excelforum.com/showthread...hreadid=559530 |
How do I delete links to websites in Excel spreadsheet?
have you tried to nright click and remove the hyperlink -- sjgidman ------------------------------------------------------------------------ sjgidman's Profile: http://www.excelforum.com/member.php...o&userid=36174 View this thread: http://www.excelforum.com/showthread...hreadid=559530 |
How do I delete links to websites in Excel spreadsheet?
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. Andy wrote: 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? -- Dave Peterson |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com