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.
Then click on the Special button on the bottom of the dialog box to open the Go To Special dialog box.
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.
56 comentários:
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!
Glad that my work helped you save time. That's why I do it.
Thanks for your feedback.
jppinto
Thanks man!! Hats off to MS for thinking about this scenario and thanks to you for writing about it :)
Ditto! This saved me a crazy amount of time - thanks man!!!
Excellent tip! Thanks :)
This just saved me so much time! Thanks
Thanks! life saver!
Great tip! thanks
Work like a champ
fantastic time saver - thanks
thanks a lotttttt...
Good trick. really superb!!!!!!!!!!
THANK YOU!!!
Excelent Tip! Thanks. I used "select images excel 2010"
Freaking AWESOME!! You saved me a horrendous amount of work! THANKS!
Just too good.
Thanks buddy, it's reaaly vary useful
Abso-freakin-lutely AWESOME!
Man,
You saved me so much time.....
Thanks
You are awesome! Thank you
Thank you, this post is money saver.
You just added four hours to my life.
You are the MAN! Just wish I'd found this sooner.
Thank you so much for sharing !
Thank you so much! Saved a lot of time!
Thankyou so much ....saved a ton of my time
CTRL + G = Go To in Excel 2010
This will highlight the objects but not actual pictures. Any suggestions?
A picture is an object...
Great Post! This saved me a whole lot of time. Thanks!
You saved me so much time. Thanks!
I echo the sentiments of everyone else...this just saved me a ton of time...Thanks!
Wow, this is a great advice. Thanks a lot for that. Saved me tons of time. Appreciate it
This just saved my so much time! Thanks a lot, very good trick. really superb!!!!!!!
ASHU PATEL
What a time saver... awesome.
This saved my time. People like you make the computer a great technology. Keep up the good work and thanks for sharing this tip.
A lot of time saved!
I mean a hell of a lot of time
Thanks a lot!!!!! Its so simple, I have got luckly with this blog. Saves so much of time.....
Thank you for the great tip! It is definitely a time saver.
Thanks, I did my job with your tips.
Very nice and helpfull.
thx man! a real time saver!
Thanks! sure beats manualy selcting over 400 images for deletion :)
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.
Thank you so much! I've been struggling with this for an hour!
Great help...saves so much time...i have been wasting my time all these years...
just the thing i wanted.. perfectly and easily done..
Successfully deleted all the pictures.. thank you very much...
Thank you for the tip!
the thank you list will go on forever.
God bless
Thanks a ton..!!! My workbook was crashing with too many logos inside. This has saved me Saved me a lot of precious time.
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.
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.
What if I only want to select the pictures? Using this function will also select text boxes. Any idea? Thanks!
Thanks for helping me. Rakesh India
Thanku so much, bro. It has been a great help.
Emon,Bangladesh: Excellent Tips , Its work.
Thank you.
Post a Comment