Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to kill ALL copied pictures?
Hi, I've been copying-in dozens of pages of html into excel and, with them, hundreds of thousands of little "spacer" images. When their links break they show up as annoying little dots. My question is, is there any way to do a global kill on images in an Excel doc? "Delete all images?" Any other like remedies would be greatly appreciated... except comments of, "Don't break the links." Trust me, the links will be broken no matter how I deliver the project. They show up as "Picture 546," "Picture 129," etc. Maybe a find-and-replace thwack? THANKS CORY -- johncory ------------------------------------------------------------------------ johncory's Profile: http://www.excelforum.com/member.php...o&userid=28507 View this thread: http://www.excelforum.com/showthread...hreadid=481008 |
#2
|
|||
|
|||
How to kill ALL copied pictures?
Try this: (assuming there are no graphic objects that you want to keep) Go to Edit Go to click on the button marked Special and then choose Objects Click OK You now have all objects on the sheet selected. Hit the Delete key and they're gone. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=481008 |
#3
|
|||
|
|||
How to kill ALL copied pictures?
Cutter, you rule. THANKS CORY -- johncory ------------------------------------------------------------------------ johncory's Profile: http://www.excelforum.com/member.php...o&userid=28507 View this thread: http://www.excelforum.com/showthread...hreadid=481008 |
#4
|
|||
|
|||
How to kill ALL copied pictures?
My wife disagrees! (and so does my daughter) But thanks anyway, and you're welcome. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=481008 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting pictures then sorting | Excel Discussion (Misc queries) | |||
insert copied cells | Excel Discussion (Misc queries) | |||
McGimpsey's Disappearing Pictures | Excel Discussion (Misc queries) | |||
Is it possible to use some pictures in an IF function? | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |