How can I select/delete multiple pictures

22730 views
Skip to first unread message

Jim T

unread,
Nov 14, 2007, 8:18:52 PM11/14/07
to
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

unread,
Nov 14, 2007, 8:28:43 PM11/14/07
to
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

Dave Peterson

unread,
Nov 14, 2007, 8:30:50 PM11/14/07
to
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

--

Dave Peterson

Alan

unread,
Nov 14, 2007, 8:32:26 PM11/14/07
to
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.
"Jim T" <abaco8...@yahoo.com> wrote in message
news:ueOv8Vy...@TK2MSFTNGP06.phx.gbl...

josephm...@gmail.com

unread,
Jun 20, 2012, 1:48:56 PM6/20/12
to
Alan and Dave,

Great advice. Thanks!

lewisjames...@gmail.com

unread,
Aug 8, 2012, 3:30:16 AM8/8/12
to
A simple solution is in excel 2010 is select 1 image. Predd CTL & 'a' then delete.

That's it..

bna...@gmail.com

unread,
Aug 23, 2012, 1:31:45 PM8/23/12
to
Awesome, yeah that worked. Where do these pictures come from?

murru...@gmail.com

unread,
Aug 29, 2012, 11:26:41 AM8/29/12
to pete...@verizonxspam.net
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

yfl...@msn.com

unread,
Sep 13, 2012, 11:24:51 AM9/13/12
to
Thanks so much James!

krystale...@gmail.com

unread,
Sep 20, 2012, 2:30:21 PM9/20/12
to
Alan, YOU ROCK!!! Its so embarassing to admit how much time i spent trying to figure this out. Thanx a Bunch. Its people like you that make my life soo much easier!!!! :)

priya...@gmail.com

unread,
Oct 16, 2012, 6:18:05 PM10/16/12
to
Great advice! thank you!!
>
> Jim T

arjun...@gmail.com

unread,
Dec 9, 2012, 7:58:54 PM12/9/12
to
Lewis Mate.. U r a champ.. Thanks..

duke.ki...@gmail.com

unread,
Dec 12, 2012, 2:59:57 AM12/12/12
to
Try select any picture.
Then, hit Ctrl+A (Windows) Command+A (Mac).
Then, DELETE !!

shanu...@gmail.com

unread,
Dec 18, 2012, 2:11:33 AM12/18/12
to
wonderful

devind...@gmail.com

unread,
Dec 27, 2012, 3:04:48 AM12/27/12
to
Thanks to You. Kudos

mrb...@gmail.com

unread,
Feb 12, 2013, 9:01:45 PM2/12/13
to
Thanks it worked!!! Tried many times to fix this. Appreciate your post/help! M & V

lee21

unread,
May 24, 2013, 9:47:05 AM5/24/13
to
Thank you.. It works great
Message has been deleted

maxlan...@gmail.com

unread,
Jun 14, 2013, 12:27:02 PM6/14/13
to
Lewis nailed it, if you have Excel 2010! Easiest way, for sure.

pcs...@gmail.com

unread,
Aug 7, 2013, 4:40:34 PM8/7/13
to
On Wednesday, November 14, 2007 8:28:43 PM UTC-5, Dave Peterson wrote:
> 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 for each 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 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


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

ubaidg...@gmail.com

unread,
Sep 1, 2013, 3:50:14 AM9/1/13
to
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

ubaidg...@gmail.com

unread,
Sep 1, 2013, 3:51:28 AM9/1/13
to

aduf...@techie.com

unread,
Sep 12, 2013, 4:02:47 AM9/12/13
to
---

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...@gmail.com

unread,
Oct 16, 2013, 3:26:47 PM10/16/13
to
THANK YOUU!!!!!

joel.d...@gmail.com

unread,
Oct 29, 2013, 10:35:06 AM10/29/13
to
On Sunday, September 1, 2013 9:51:28 AM UTC+2, ubaidg...@gmail.com wrote:
> 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

You can select multiple objects in a rectangular region. To do this with Excel 2010, click on "Find & Select" to display the sub-menu and then, click on "Select Objects". Then you can trace a rectangular region (by click-down and move mouse) on your Excel sheet, over the pictures you want to select.

mattm...@gmail.com

unread,
Nov 6, 2013, 12:17:45 PM11/6/13
to
You just saved me hours! Thank you!!!
Reply all
Reply to author
Forward
0 new messages