Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
johncory
 
Posts: n/a
Default 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   Report Post  
Cutter
 
Posts: n/a
Default 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   Report Post  
johncory
 
Posts: n/a
Default 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   Report Post  
Cutter
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting pictures then sorting Dav Excel Discussion (Misc queries) 2 November 3rd 05 11:39 AM
insert copied cells maryj Excel Discussion (Misc queries) 1 October 24th 05 07:56 PM
McGimpsey's Disappearing Pictures PW11111 Excel Discussion (Misc queries) 1 October 10th 05 03:52 PM
Is it possible to use some pictures in an IF function? [email protected] Excel Worksheet Functions 1 October 4th 05 05:10 AM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"