How can I select/delete multiple pictures

  • Thread starter Thread starter Jim T
  • Start date Start date
J

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
 
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
 
Pictures are objects, so if you go onto 'Edit' > 'Goto' > click 'Special' on
the bottom left, select 'Objects' and hit delete, they will all be deleted.
Problem is that graphs etc are also objects so if you have anything like
that in the sheet they will be deleted too. Best way is to make a copy of
the file and experiment on that.
Regards,
Alan.
 
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
Click to expand...

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

That's it..
 
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
 
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
Click to expand...

Try select any picture.
Then, hit Ctrl+A (Windows) Command+A (Mac).
Then, DELETE !!
 
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
Click to expand...


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
 
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
 
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
 
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
Click to expand...

---

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
 
Back
Top