Excel - Select or Delete Multiple Images or Objects in a Spreadsheet - Episode 363

1,312 views · Published 4 November 2009 · 1:43 · Indexed 27 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: There is a secret icon that will let you select all of the items on the drawing toolbar. Episode 363 shows you how.

Welcome back to the MrExcel netcast, where we provide you with helpful tips and tricks to make your Excel experience smoother. In today's episode, we will be discussing a common problem that many of us face when copying data from a website into Excel - the pesky little graphic icons that come along with it. These icons may be links to check-images or other website features, but they can be a real hassle to delete one by one. But fear not, because I have a hidden trick that will save you time and frustration.

First, you need to make sure that the Drawing toolbar is displayed. You can do this by going to View, Toolbars, and selecting Drawing. The toolbar will generally appear at the bottom of your screen, but you can move it to the top for easier access. On the left-hand side of the toolbar, you will see a white arrow - this is the Select Objects arrow. When you click on it, you will enter Select Objects mode, where you won't be able to select cells, but you can drag a rectangle to select multiple objects at once.

Once you have selected all the unwanted graphics, simply hit the Delete key and they will disappear. Remember to click on the arrow again to exit Select Objects mode and go back to selecting single cells. This trick will save you a lot of time and effort, especially when dealing with a large number of graphics on a worksheet. So next time you encounter this issue, remember to use the Select Objects arrow and make your life easier.

Thank you for tuning in to today's netcast from MrExcel. We hope this tip will come in handy for your future Excel projects. Don't forget to subscribe to our channel for more helpful videos like this one. See you tomorrow for another episode of the MrExcel netcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction
(00:17) Annoying problem with copying data from website
(00:27) Hidden trick for getting rid of graphics
(00:39) First step: Display Drawing toolbar
(00:50) Using the Select Objects arrow
(01:06) Deleting selected objects
(01:16) Exiting Select mode
(01:26) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelshapes

This video answers these common search terms:
how to select multiple objects at once in excel
how to select multiple images excel
choose multiple pictures or icons in excel
excel select all graphic objects
excel select all embedded images and icons
where is select objects in excel
select all pictures and icons in excel
bulk select images in excel
select all shapes and images in excel worksheet
bulk selection of images and icons in excel
mass select graphics in excel
select all objects in excel including images
excel select all clip art and pictures

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152732/

More from this channel