How do I remove multiple pictures ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CPhil - 09 Jan 2006 15:20 GMT

I often copy accross large lists of data from web resources, when I d
this, each of the cells in one column contains a small picture whic
remains on the worksheet even if I have moved the data elsewhere.

I can get rid of them using "cut" - but it would take too long to d
them all like this.

Is there any way of removing these en mass ?

Reply to this Message

Dave Peterson - 09 Jan 2006 15:44 GMT

You can show the Drawing toolbar and use the Arrow icon.

Lasso all the pictures you can (to select them) and then hit the delete key.

You could also customize a toolbar:
tools|customize|commands tab
drag the select multiple objects to your favorite toolbar.

Then click this button, select the pictures/objects you want gone and hit the
delete key.

> I often copy accross large lists of data from web resources, when I do
> this, each of the cells in one column contains a small picture which
[quoted text clipped - 10 lines]
> CPhil's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29842
> View this thread: http://www.excelforum.com/showthread.php?threadid=499394

Signature

Dave Peterson

Reply to this Message

CPhil - 09 Jan 2006 16:05 GMT

thanks Dave, that works well

Signature

CPhil

Reply to this Message

Bob Umlas - 09 Jan 2006 15:58 GMT

Edit/goto special, Objects. Now all the objects are selected. Press the
Delete key.

> I often copy accross large lists of data from web resources, when I do
> this, each of the cells in one column contains a small picture which
[quoted text clipped - 4 lines]
>
> Is there any way of removing these en mass ??

Reply to this Message