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.
100 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.
Ditto to all the good comments above!!!!!!!
This worked perfectly for me! Thank you so much for the help!
Brilliantly simple!
Thanks to you
& Microsft Office who has built this function inside the Excel
I use free demo version of Picture Manager For Excel from Doality.com and it can delete pictures from several excel files also.
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?
Woh.......!!!!!! Its awesome.... Tk UU somuchhhh...
This was so easy and helpful! THANK YOU, THANK YOU, THANK YOU!!!
Grateful for this excellent, time saving tip!
genius. thank you!!!
Can I get an "AMEN". Thanks for this tip. Worked like a charm.
this blog is awesome im very thankyou to this blog I like it
GREAT work! Thanks for the easy answer.
Your a brilliant person. Thanks for sharing :)
Thanks a million!!! That just saved me a ton of time!
Thanks so much. Google displayed your link on page 2, requiring me to click on several others links to pages that simply said, "select the graph then hit the Delete key." Really, if it was that easy, I wouldn't have asked how to do it.
(And by teh way, selecting the graph and hitting the DEL keys does NOT work).
Thanks a million !!
Oh wow! Thanks a billion. Your tip helped me save a lot of time! -Saravana
Thanks a lot!It saved a lot of time.
Thanks greatly.
You are a sick, SICK individual. This tip worked brilliantly. It's gonna help people for years to come. Thank you.
Awesome. Spent 30 minutes deleting less than half individually then finished the job in 3 seconds. Thanks for that.
Great, thanks.
Save the day, thanks
Thanks a ton! Since I have to work on excel on a daily basis, this was a headache every time I copied data from a report and had to remove it manually which used to take hell lot of time.
Many thanks for providing the solution!
Huge time saver - thank you!
Saved me tons of time!!! Thanks for the tip!
dịch vụ báo cáo thuế tại tỉnh bình dương
dịch vụ báo cáo thuế tại quận bình thạnh
dịch vụ báo cáo thuế tại quận tân phú
dịch vụ báo cáo thuế tại quận 5
dịch vụ báo cáo thuế tại quận 3
dịch vụ báo cáo thuế tại tphcm
dịch vụ báo cáo thuế tại quận long biên
dịch vụ báo cáo thuế tại quận hà đông
dịch vụ báo cáo thuế tại quận thanh xuân
dịch vụ báo cáo thuế tại quận cầu giấy
dịch vụ báo cáo thuế tại gia lâm
dịch vụ báo cáo thuế tại đông anh
dịch vụ báo cáo thuế tại thanh trì
dịch vụ báo cáo thuế tại quận hoàng mai
dịch vụ báo cáo thuế tại quận hai bà trưng
dịch vụ báo cáo thuế tại quận từ liêm
dịch vụ báo cáo thuế tại quận hoàn kiếm
dịch vụ báo cáo thuế tại quận tây hồ
dịch vụ báo cáo thuế tại quận ba đình
dịch vụ báo cáo thuế tại quận đống đa
THANK YOU!! saved me so much time!!!!
I hope some one replies to me ...
Yes its a Great tip.. but..I have 2 question..
HOW CAN I SELECT ALL EXCEPT A FEW IMAGES
HOW CAN I SELECT ONLY IMAGES AND NOT OBJECTS.
Wav. its very helpful.
Thank you fro the tip. Great help.
THANKS FOR INFORMATION AND PERMISSION SHARE http://gamatori.com -- Terima kasih izin ngeshare ya http://gamatori.com
THANKS FOR INFORMATION AND PERMISSION SHARE
http://www.klikgamat.com/p/blog-page.html
http://www.klikgamat.com/2018/05/obat-mujarab-luka-diabetes_19.html
It’s really a cool and helpful piece of info. I am happy that you simply shared this helpful
info with us. Please stay us up to date like this.
Thanks for sharing.
https://bit.ly/2oITVef | https://bit.ly/2wPdrsW | https://bit.ly/2NiLdkS
It’s really a cool and helpful piece of info. I am happy that you simply shared this helpful
info with us. Please stay us up to date like this.
Thanks for sharing.
http://www.klikgamat.com/2018/09/obat-alami-scabies-pada-manusia-paling-ampuh.html
http://gamatori.com/2018/09/28/obat-alami-gatal-dan-bercak-putih-pada-vagina-paling-ampuh/
http://www.klikgamat.com/2018/11/cara-menyembuhkan-dan-mencegah-demensia-secara-alami-paling-ampuh-tanpa-efek-samping.html
http://gamatori.com/2018/11/12/cara-menyembuhkan-dan-mengobati-infeksi-serviks-secara-alami-paling-ampuh/
http://www.klikgamat.com/2018/11/cara-mengobati-dan-mencegah-tumor-otak-secara-alami-tanpa-efek-samping.html
I like that and thanks you for information
izin share guys :)
http://gamatori.com/2018/11/30/cara-menyembuhkan-urine-atau-fases-bocor-ke-dalam-vagina-secara-alami-paling-ampuh/
http://www.klikgamat.com/2018/11/cara-menyembuhkan-lumpuh-otak-sementara-secara-alami-paling-ampuh.html
http://gamatori.com/2018/11/23/cara-menyembuhkan-fistula-kandung-kemih-secara-alami-paling-ampuh/
http://www.klikgamat.com/2018/11/cara-mengobati-stres-berat-secara-alami-tanpa-efek-samping-paling-ampuh.html
1
2 sabung ayam
3
4
5 daftar scr888 indonesia
6 slot osg777
7
8
https://panasoniclampung.blogspot.com/
https://servicecentersamsungbandarlampung.blogspot.com/
https://servicehuaweicenter.blogspot.com/
https://serviceiphonelampung.blogspot.com/
https://servicecenteriphone.blogspot.com/
https://servicecentervivo.blogspot.com/
https://servicecenteroppo.blogspot.com/
https://servicecenterxiaomi.blogspot.com/
www.lampungservice.com
https://servicecenteraxioo.blogspot.com/
now present in your city
Awesome post!!! Nice...suprememobiles
Well done! Great article...
Performance issues on standalone network in Sage 50
How to fix Sage 50 Error 3 or 95 in file
Small business icpayment chase within QuickBooks
How to fix Sage error code 1935
Fix not Enough Menory for printing or invalid printer setup Error in Sage
QuickBooks Registration code bypass
Fix Multi User mode issues when access Sage network
How to fix Sage 300 Error 49153 cannot access database
How to Resolve Script Error in 2018
QuickBooks desktop and QuickBooks online
Post a Comment