Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to delete page break on Excel spreadsheet | Excel Worksheet Functions | |||
How do I delete a text box from an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) |