How can I select/delete multiple pictures

[Jim T]

I just discovered some of my spreadsheets have hundreds of pictures in them.
Most are just a pixel at a cell intersection. I figured out where they
originated and will prevent more from showing up, but I am stuck with around
400 pictures in this spreadsheet.

How can I select all pictures and delete? I do not have any pictures that
should be in this sheet. I have trouble even seeing these things, let alone
selecting and deleting several hundred of them one at a time.

Thanks in advance.

Jim T

 

[Dave Peterson]

Can you remove all the pictures?

If yes...

Open the workbook
select that worksheet
hit alt-f11 to get to the vbe
hit ctrl-g to see the immediate window
Type this and hit enter:
Activesheet.pictures.delete

This will fail if the number of pictures is too large (and I don't recall what
that limit is).

But you could use a macro:

Option Explicit
Sub testme()
dim myPict as picture
for each mypict in activesheet.pictures
mypict.delete
next mypict
end sub

 

[Dave Peterson]

ps...

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[lewisjamesprice.work]

I just discovered some of my spreadsheets have hundreds of pictures in them.
Most are just a pixel at a cell intersection. I figured out where they
originated and will prevent more from showing up, but I am stuck with around
400 pictures in this spreadsheet.

How can I select all pictures and delete? I do not have any pictures that
should be in this sheet. I have trouble even seeing these things, let alone
selecting and deleting several hundred of them one at a time.

Thanks in advance.

Jim T

A simple solution is in excel 2010 is select 1 image. Predd CTL & 'a' then delete.

That's it..

 

[bna858]

Awesome, yeah that worked. Where do these pictures come from?

 

[murrugarrad]

I know this was posted years ago, but it was a major time saver and I REALLY appreciated it. Have a great day and know that your gift keeps on giving.

d

 

[yflako]

A simple solution is in excel 2010 is select 1 image. Predd CTL & 'a' then delete.



That's it..

Thanks so much James!

 

[priyashere]

Great advice! thank you!!

 

[arjun.melb]

Lewis Mate.. U r a champ.. Thanks..

A simple solution is in excel 2010 is select 1 image. Predd CTL & 'a' then delete.



That's it..

 

[duke.kittisiri]

I just discovered some of my spreadsheets have hundreds of pictures in them.
Most are just a pixel at a cell intersection. I figured out where they
originated and will prevent more from showing up, but I am stuck with around
400 pictures in this spreadsheet.

How can I select all pictures and delete? I do not have any pictures that
should be in this sheet. I have trouble even seeing these things, let alone
selecting and deleting several hundred of them one at a time.

Thanks in advance.

Jim T

Try select any picture.
Then, hit Ctrl+A (Windows) Command+A (Mac).
Then, DELETE !!

 

[shanujas123]

Try select any picture.

Then, hit Ctrl+A (Windows) Command+A (Mac).

Then, DELETE !!

wonderful

 

[devinder.dev]

Thanks to You. Kudos

 

[lee21]

Thank you.. It works great

Try select any picture.

Then, hit Ctrl+A (Windows) Command+A (Mac).

Then, DELETE !!

 

[maxlanerealty]

This is the one if you have Excel 2010. Simple. Thanks!

 

[maxlanerealty]

Lewis nailed it, if you have Excel 2010! Easiest way, for sure.

 

[pcscdma]

Can you remove all the pictures?If yes...Open the workbook select that worksheethit alt-f11 to get to the vbe hit ctrl-g to see the immediate windowType this and hit enter: Activesheet.pictures.deleteThis will fail if the number of pictures is too large (and I don't recall what that limit is).But you could use a macro:Option Explicit Sub testme()dim myPict as picture foreach mypict in activesheet.picturesmypict.deletenext mypict end subJim T wrote:> > I just discovered some of my spreadsheets have hundreds of pictures in them. > Most are just a pixel at a cell intersection. I figured out where they > originated and will prevent more from showing up, but I am stuckwith around > 400 pictures in this spreadsheet.> > How can I select all pictures and delete? I do not have any pictures that > should be in this sheet. I have trouble even seeing these things, let alone > selecting and deleting several hundred of them one at a time.> > Thanks in advance.> > Jim T--Dave Peterson

Dave,

After all these years, not sure you will ever see this, but I want to let everyone knows that I just use your solutuin on Office 2010, and works great.. Just did what you said, i.e.,

Open the workbook
select that worksheet
hit alt-f11 to get to the vbe
hit ctrl-g to see the immediate window
Type this and hit enter:
Activesheet.pictures.delete

Thanks again! Nader

 

[ubaidgillani]

I have 1000+ pictures in Excel sheet. and want to delete first 758 pictures once a time and other want to remain save. then how it possible to delete picture without selecting Ctrl+Mouse click one by one.

Anybody to resolve the issue

 

[ubaidgillani]

I have 1000+ pictures in Excel sheet. and want to delete first 758 pictures once a time and other want to remain save. then how it possible to delete picture without selecting Ctrl+Mouse click one by one.

Anybody to resolve the issue

 

[adufondi]

I just discovered some of my spreadsheets have hundreds of pictures in them.
Most are just a pixel at a cell intersection. I figured out where they
originated and will prevent more from showing up, but I am stuck with around
400 pictures in this spreadsheet.

How can I select all pictures and delete? I do not have any pictures that
should be in this sheet. I have trouble even seeing these things, let alone
selecting and deleting several hundred of them one at a time.

Thanks in advance.

Jim T

---

Jim,

Take a look at Picture Manager For Excel add-in utility which does remove and insert multiple pictures and to multiple Excels. Check out the video and download at Doality.com

-AD

 

[gretchen.r.waters]

THANK YOUU!!!!!