Delete all pictures or charts on Worksheet

This is a tip on how you can delete all pictures and/or charts on a worksheet without having to manually select each one and delete them.
So, you can use the F5 shortcut key on Excel to open the Go To dialog box.

GoTo1
Then click on the Special button on the bottom of the dialog box to open the Go To Special dialog box.

GoTo2

Select the Objects option and click the OK button to close the dialog box. Now you have all of the objects on your worksheet selected. Check if you don’t have any more objects on your sheet that you don’t want to delete, like a company logo or something, before you press Delete key to delete all of them at the same time.

67 comentários:

Tore said...

Luckily for me this tip showed up as the first hit when googling "excel 2010 remove all pictures". This saved me a lot of tedious work, thanks a lot!

jppinto said...

Glad that my work helped you save time. That's why I do it.
Thanks for your feedback.

jppinto

ammo said...

Thanks man!! Hats off to MS for thinking about this scenario and thanks to you for writing about it :)

Anonymous said...

Ditto! This saved me a crazy amount of time - thanks man!!!

Kiran said...

Excellent tip! Thanks :)

Anonymous said...

This just saved me so much time! Thanks

Anonymous said...

Thanks! life saver!

Anonymous said...

Great tip! thanks

Anonymous said...

Work like a champ

Prestige Restaurant and Patio Lounge said...

fantastic time saver - thanks

Anonymous said...

thanks a lotttttt...

Anonymous said...

Good trick. really superb!!!!!!!!!!

ekjb said...

THANK YOU!!!

Prensa said...

Excelent Tip! Thanks. I used "select images excel 2010"

Anonymous said...

Freaking AWESOME!! You saved me a horrendous amount of work! THANKS!

Anonymous said...

Just too good.

Anonymous said...

Thanks buddy, it's reaaly vary useful

Anonymous said...

Abso-freakin-lutely AWESOME!

Rajat Bindra said...

Man,

You saved me so much time.....

Thanks

Anonymous said...

You are awesome! Thank you

Anonymous said...

Thank you, this post is money saver.

Anonymous said...

You just added four hours to my life.

Anonymous said...

You are the MAN! Just wish I'd found this sooner.

Anonymous said...

Thank you so much for sharing !

Anonymous said...

Thank you so much! Saved a lot of time!

Anonymous said...

Thankyou so much ....saved a ton of my time

Anonymous said...

CTRL + G = Go To in Excel 2010

Anonymous said...

This will highlight the objects but not actual pictures. Any suggestions?

jppinto said...

A picture is an object...

Rejoice said...

Great Post! This saved me a whole lot of time. Thanks!

Anonymous said...

You saved me so much time. Thanks!

Anonymous said...

I echo the sentiments of everyone else...this just saved me a ton of time...Thanks!

Manollo said...

Wow, this is a great advice. Thanks a lot for that. Saved me tons of time. Appreciate it

ASHU PATEL said...

This just saved my so much time! Thanks a lot, very good trick. really superb!!!!!!!

ASHU PATEL

Anonymous said...

What a time saver... awesome.

Shaan Rizvi said...

This saved my time. People like you make the computer a great technology. Keep up the good work and thanks for sharing this tip.

Anonymous said...

A lot of time saved!
I mean a hell of a lot of time

Anonymous said...

Thanks a lot!!!!! Its so simple, I have got luckly with this blog. Saves so much of time.....

Anonymous said...

Thank you for the great tip! It is definitely a time saver.

Sepeda Motor Bebek Injeksi Kencang dan Irit Jupiter Z1 said...

Thanks, I did my job with your tips.
Very nice and helpfull.

Anonymous said...

thx man! a real time saver!

Anonymous said...

Thanks! sure beats manualy selcting over 400 images for deletion :)

Anonymous said...

I do not post comments a lot - but I found myself compelled to post one now. Thank you very much for this - this is extremely awesome, and has saved and will save me a ton of time.

Thank you.

Anonymous said...

Thank you so much! I've been struggling with this for an hour!

Anonymous said...

Great help...saves so much time...i have been wasting my time all these years...

Anonymous said...

just the thing i wanted.. perfectly and easily done..

Ansif KM said...

Successfully deleted all the pictures.. thank you very much...

Anonymous said...

Thank you for the tip!

the thank you list will go on forever.

God bless

Anonymous said...

Thanks a ton..!!! My workbook was crashing with too many logos inside. This has saved me Saved me a lot of precious time.

Anonymous said...

Thank you, really helpful However, I was trying to show this to my father who copies online statements which bring little arrows into the spreadsheet and he found it too hard to remember.

An easier, alternative way for him to remember the process was to go to "Find & select" on the toolbar and click "Objects" from the menu, which modifies the cursors properties, then click and drag it over all the afflicted cells (you can even drag it over the entire sheet) to select all the objects in the specified area, then its just a case of Hitting the "Delete" key.

This method has the benefit of allowing you to select only the objects you want to delete and not all of them.

Someone else hinted at this above which is how I found out, but I thought I woud make it clearer for any less "PC literate" folk.

We use Office 2007.

Bank Mandiri Bank Terbaik di Indonesia said...

Thanks for the informative blog. The place else may possibly just I get that kind of info written in such a excellent approach? I’ve a venture that I’m just now operating on, and I’ve been on the glance out for such info.

Anonymous said...

What if I only want to select the pictures? Using this function will also select text boxes. Any idea? Thanks!

Anonymous said...

Thanks for helping me. Rakesh India

Anonymous said...

Thanku so much, bro. It has been a great help.

Emranur Rahman said...

Emon,Bangladesh: Excellent Tips , Its work.

Anonymous said...

Thank you.

Anonymous said...

Ditto to all the good comments above!!!!!!!

Unknown said...

This worked perfectly for me! Thank you so much for the help!

Unknown said...

Brilliantly simple!

Anonymous said...

Thanks to you
& Microsft Office who has built this function inside the Excel

Anonymous said...

I use free demo version of Picture Manager For Excel from Doality.com and it can delete pictures from several excel files also.

Anonymous said...

The "Objects" select button is grayed-out and won't let me click on it. I've tried clicking on the embedded picture and it won't let me either. Any ideas?

Sony Mathew said...

Woh.......!!!!!! Its awesome.... Tk UU somuchhhh...

Anonymous said...

This was so easy and helpful! THANK YOU, THANK YOU, THANK YOU!!!

Ed said...

Grateful for this excellent, time saving tip!

Anonymous said...

genius. thank you!!!

Steve said...

Can I get an "AMEN". Thanks for this tip. Worked like a charm.